APPS.OE_CNCL_VALIDATE_LINE dependencies on MTL_SYSTEM_ITEMS_VL

Line 603: FROM mtl_system_items_vl

599: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
600: IF nvl(p_item_identifier_type, 'INT') = 'INT' THEN
601: SELECT 'valid'
602: INTO l_dummy
603: FROM mtl_system_items_vl
604: WHERE inventory_item_id = p_inventory_item_id
605: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
606: ELSIF nvl(p_item_identifier_type, 'INT') = 'CUST' THEN
607: SELECT 'valid'

Line 611: ,mtl_system_items_vl sitems

607: SELECT 'valid'
608: INTO l_dummy
609: FROM mtl_customer_items citems
610: ,mtl_customer_item_xrefs cxref
611: ,mtl_system_items_vl sitems
612: WHERE citems.customer_item_id = cxref.customer_item_id
613: AND cxref.inventory_item_id = sitems.inventory_item_id
614: AND sitems.inventory_item_id = p_inventory_item_id
615: AND sitems.organization_id =

Line 628: , mtl_system_items_vl sitems

624: SELECT 'valid'
625: INTO l_dummy
626: FROM mtl_cross_reference_types types
627: , mtl_cross_references items
628: , mtl_system_items_vl sitems
629: WHERE types.cross_reference_type = items.cross_reference_type
630: AND items.inventory_item_id = sitems.inventory_item_id
631: AND sitems.organization_id =
632: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')