DBA Data[Home] [Help]

APPS.CTO_MANUAL_LINK_CONFIG dependencies on BOM_INVENTORY_COMPONENTS

Line 651: FROM bom_inventory_components bic, bom_bill_of_materials bom

647: SELECT inventory_item_id, base_item_id
648: FROM mtl_system_items msi
649: WHERE inventory_item_id IN
650: ( SELECT component_item_id
651: FROM bom_inventory_components bic, bom_bill_of_materials bom
652: WHERE bom.assembly_item_id = pconfigId --p_config_id
653: AND bom.common_bill_sequence_id = bic.bill_sequence_id
654: AND bom.alternate_bom_designator IS NULL
655: AND bom.organization_id = pshipOrg