DBA Data[Home] [Help]

APPS.CTO_MANUAL_LINK_CONFIG dependencies on BOM_BILL_OF_MATERIALS

Line 357: FROM bom_bill_of_materials bom

353: l_stmt_num := 190;
354:
355: SELECT 1
356: INTO l_bom_exists
357: FROM bom_bill_of_materials bom
358: WHERE bom.assembly_item_id = p_config_item_id
359: AND bom.organization_id = old_config_dtls.ship_from_org_id(1)
360: AND bom.alternate_bom_designator IS NULL;
361:

Line 418: FROM bom_bill_of_materials bom

414: l_stmt_num := 220;
415:
416: SELECT 1
417: INTO flag
418: FROM bom_bill_of_materials bom
419: WHERE bom.assembly_item_id = p_config_item_id
420: AND bom.organization_id = l_org
421: AND bom.alternate_bom_designator IS NULL;
422:

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