DBA Data[Home] [Help]

APPS.BOM_DEFAULT_SUB_COMPONENT dependencies on BOM_INVENTORY_COMPONENTS

Line 39: * component sequence id key, from bom_inventory_components

35: * Parameter IN : Substitute Component unexposed Record
36: * Parameter OUT : Return_Status
37: * Mesg_Token_Tbl
38: * Purpose : Function will fetch the item quantity using the
39: * component sequence id key, from bom_inventory_components
40: * table and return it as the default value for
41: * Substitute_Item_Quantity
42: *******************************************************************/
43: FUNCTION Get_Substitute_Item_Quantity

Line 59: FROM bom_inventory_components

55: -- using the component sequence id.
56: ---+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
57: SELECT component_quantity
58: INTO l_sub_item_quantity
59: FROM bom_inventory_components
60: WHERE component_sequence_id =
61: p_Sub_Comp_Unexp_Rec.component_sequence_id;
62:
63: RETURN (l_sub_item_quantity);