DBA Data[Home] [Help]

APPS.BOM_OP_SEQ_UTIL dependencies on BOM_BILL_OF_MATERIALS

Line 1819: FROM BOM_BILL_OF_MATERIALS bom

1815: , bic.PROGRAM_APPLICATION_ID = Fnd_Global.Prog_Appl_Id
1816: , bic.PROGRAM_UPDATE_DATE = SYSDATE
1817: WHERE bic.operation_seq_num = p_com_operation_rec.operation_sequence_number
1818: AND bic.bill_sequence_id = (SELECT bom.BILL_SEQUENCE_ID
1819: FROM BOM_BILL_OF_MATERIALS bom
1820: , bom_operational_routings bor
1821: WHERE NVL(bor.alternate_routing_designator, 'NONE')
1822: = nvl(bom.alternate_bom_designator,'NONE')
1823: AND bom.assembly_item_id = bor.assembly_item_id