DBA Data[Home] [Help]

APPS.ENG_DEFAULT_SUB_COMPONENT dependencies on BOM_INVENTORY_COMPONENTS

Line 20: * component sequence id key, from bom_inventory_components

16: * Parameter IN : Substitute Component unexposed Record
17: * Parameter OUT : Return_Status
18: * Mesg_Token_Tbl
19: * Purpose : Function will fetch the item quantity using the
20: * component sequence id key, from bom_inventory_components
21: * table and return it as the default value for
22: * Substitute_Item_Quantity
23: *******************************************************************/
24: FUNCTION Get_Substitute_Item_Quantity

Line 40: FROM bom_inventory_components

36: -- using the component sequence id.
37: ---+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
38: SELECT component_quantity
39: INTO l_sub_item_quantity
40: FROM bom_inventory_components
41: WHERE component_sequence_id =
42: p_Sub_Comp_Unexp_Rec.component_sequence_id;
43:
44: RETURN (l_sub_item_quantity);