DBA Data[Home] [Help]

APPS.BOM_BILL_API dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 1461: bom_substitute_components bsc

1457: IF (org_id <> cmn_org_id) THEN /* Comp and sub comp in production */
1458: SELECT count(*)
1459: INTO cnt
1460: FROM bom_inventory_components bic,
1461: bom_substitute_components bsc
1462: WHERE bic.bill_sequence_id = cmn_bom_id
1463: AND bic.component_sequence_id = bsc.component_sequence_id
1464: AND bsc.substitute_component_id not in
1465: (select msi1.inventory_item_id