APPS.OE_BULK_PROCESS_LINE dependencies on MTL_SYSTEM_ITEMS_VL

Line 606: FROM mtl_system_items_vl

602:
603: BEGIN
604: SELECT inventory_item_id
605: INTO l_inventory_item_id_int
606: FROM mtl_system_items_vl
607: WHERE concatenated_segments = l_inventory_item
608: AND customer_order_enabled_flag = 'Y'
609: AND bom_item_type in (1,2,4)
610: AND organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG;

Line 1164: ,mtl_system_items_vl sitems

1160: SELECT 'valid'
1161: INTO l_dummy
1162: FROM mtl_customer_items citems
1163: ,mtl_customer_item_xrefs cxref
1164: ,mtl_system_items_vl sitems
1165: WHERE citems.customer_item_id = cxref.customer_item_id
1166: AND cxref.inventory_item_id = sitems.inventory_item_id
1167: AND sitems.inventory_item_id = p_inventory_item_id
1168: AND sitems.organization_id =

Line 1179: ,mtl_system_items_vl sitems

1175: SELECT 'valid'
1176: INTO l_dummy
1177: FROM mtl_customer_items citems
1178: ,mtl_customer_item_xrefs cxref
1179: ,mtl_system_items_vl sitems
1180: WHERE citems.customer_item_id = cxref.customer_item_id
1181: AND cxref.inventory_item_id = sitems.inventory_item_id
1182: AND sitems.inventory_item_id = p_inventory_item_id
1183: AND sitems.organization_id = OE_Bulk_Order_PVT.G_ITEM_ORG

Line 1197: , mtl_system_items_vl sitems

1193: SELECT 'valid'
1194: INTO l_dummy
1195: FROM mtl_cross_reference_types types
1196: , mtl_cross_references items
1197: , mtl_system_items_vl sitems
1198: WHERE types.cross_reference_type = items.cross_reference_type
1199: AND items.inventory_item_id = sitems.inventory_item_id
1200: AND sitems.organization_id = OE_Bulk_Order_PVT.G_ITEM_ORG
1201: AND sitems.inventory_item_id = p_inventory_item_id