DBA Data[Home] [Help]

APPS.BOM_GLOBALS dependencies on BOM_INVENTORY_COMPONENTS_S

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

2502: l_end_rev_id NUMBER;
2503: l_temp_num NUMBER;
2504: BEGIN
2505: --Get the new ComponentSequenceId
2506: SELECT Bom_Inventory_Components_S.NEXTVAL INTO l_component_seqeunce_id FROM dual;
2507:
2508: --Get the parents effectivity control
2509: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B
2510: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);