DBA Data[Home] [Help]

APPS.BOM_GLOBALS dependencies on BOM_INVENTORY_COMPONENTS_S

Line 2544: SELECT Bom_Inventory_Components_S.NEXTVAL INTO l_component_seqeunce_id FROM dual;

2540: l_end_rev_id NUMBER;
2541: l_temp_num NUMBER;
2542: BEGIN
2543: --Get the new ComponentSequenceId
2544: SELECT Bom_Inventory_Components_S.NEXTVAL INTO l_component_seqeunce_id FROM dual;
2545:
2546: --Get the parents effectivity control
2547: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B
2548: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);