DBA Data[Home] [Help]

APPS.CTO_MANUAL_LINK_CONFIG dependencies on MTL_SYSTEM_ITEMS

Line 592: mtl_system_items msi --config item

588:
589: select distinct 1
590: into l_valid
591: from oe_order_lines_all oel, --model line
592: mtl_system_items msi --config item
593: where oel.line_id = p_model_line_id
594: and oel.inventory_item_id = msi.base_item_id
595: and msi.inventory_item_id = p_config_item_id;
596:

Line 648: FROM mtl_system_items msi

644: l_index NUMBER;
645:
646: CURSOR get_configs IS
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