DBA Data[Home] [Help]

APPS.BOM_IMPORT_PUB dependencies on BOM_INVENTORY_COMPONENTS

Line 1032: FROM BOM_INVENTORY_COMPONENTS BIC

1028: -- Bug 10044476 - Add defaulting of component sequence id for delete case
1029: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
1030: SET COMPONENT_SEQUENCE_ID =
1031: (SELECT BIC.COMPONENT_SEQUENCE_ID
1032: FROM BOM_INVENTORY_COMPONENTS BIC
1033: WHERE BIC.BILL_SEQUENCE_ID = BICI.BILL_SEQUENCE_ID
1034: AND BIC.COMPONENT_ITEM_ID = BICI.COMPONENT_ITEM_ID
1035: AND BIC.OPERATION_SEQ_NUM = BICI.OPERATION_SEQ_NUM
1036: AND BICI.DISABLE_DATE BETWEEN BIC.EFFECTIVITY_DATE AND NVL(BIC.DISABLE_DATE, BICI.DISABLE_DATE+1)