what is diifferent...

 what is diifferent between demand source type,demand source type_id,demand source header id,demand source line id ,source type ,transactions source type please help me .....


are u asking about

are u asking about INV.MTL_RESERVATIONS_INTERFACE??

from trm

 

DEMAND_SOURCE_TYPE_ID NUMBER
 
Yes Identifies demand source - Sales Order, Account, Account Alias, Inventory
DEMAND_SOURCE_NAME VARCHAR2 (30)
 
Identifier for inventory or user defined demand
DEMAND_SOURCE_HEADER_ID NUMBER
 

 
Header identifier for source of demand. For Sales Order: OE_ORDER_HEADERS.HEADER_ID. For Account: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. For Account Alias: MTL_GENERIC_DISPOSITIONS.DISPOSITION_ID
DEMAND_SOURCE_LINE_ID NUMBER
 

 
Line identifier for demand source. For Sales Order: OE_ORDER_LINES.LINE_ID
TO_DEMAND_SOURCE_TYPE_ID NUMBER
 

 
For update and transfer reservation, identifies destination demand source - Sales Order, Account, Account Alias, Inventory.
TO_DEMAND_SOURCE_NAME VARCHAR2 (30)
 
For update and transfer reservation, identifier for inventory or user defined destination demand source.
TO_DEMAND_SOURCE_HEADER_ID NUMBER
 

 
For update and transfer reservation, Header identifier fordestination source of demand. For Sales Order: OE_ORDER_HEADERS.HEADER_ID. For Account: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. For Account Alias: MTL_GENERIC_DISPOSITIONS.DISPOSITION_ID
TO_DEMAND_SOURCE_LINE_ID NUMBER
 

 
For update and transfer reservation, Line identifier for destination demand source. For Sales Order: OE_ORDER_LINES.LINE_ID
PRIMARY_UOM_CODE VARCHAR2 (3)
 
Primary unit of measure of reserved item
PRIMARY_UOM_ID NUMBER
 

 
Not currently used
RESERVATION_UOM_CODE VARCHAR2 (3) Yes Unit of measure in which reservation is made.
RESERVATION_UOM_ID NUMBER
 

 
Not currently used
RESERVATION_QUANTITY NUMBER
 
Yes Quantity reserved in RESERVATION_UOM_CODE
PRIMARY_RESERVATION_QUANTITY NUMBER
 

 
Quantity reserved in PRIMARY_UOM_CODE

 thank you sir

 thank you sir