DBA Data[Home] [Help]

APPS.BOM_OP_SEQ_UTIL dependencies on BOM_BILL_OF_MATERIALS

Line 1822: FROM BOM_BILL_OF_MATERIALS bom

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