APPS.OE_BULK_PROCESS_LINE dependencies on MTL_SYSTEM_ITEMS_VL

Line 580: FROM mtl_system_items_vl

576:
577: BEGIN
578: SELECT inventory_item_id
579: INTO l_inventory_item_id_int
580: FROM mtl_system_items_vl
581: WHERE concatenated_segments = l_inventory_item
582: AND customer_order_enabled_flag = 'Y'
583: AND bom_item_type in (1,2,4)
584: AND organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG;

Line 1138: ,mtl_system_items_vl sitems

1134: SELECT 'valid'
1135: INTO l_dummy
1136: FROM mtl_customer_items citems
1137: ,mtl_customer_item_xrefs cxref
1138: ,mtl_system_items_vl sitems
1139: WHERE citems.customer_item_id = cxref.customer_item_id
1140: AND cxref.inventory_item_id = sitems.inventory_item_id
1141: AND sitems.inventory_item_id = p_inventory_item_id
1142: AND sitems.organization_id =

Line 1153: ,mtl_system_items_vl sitems

1149: SELECT 'valid'
1150: INTO l_dummy
1151: FROM mtl_customer_items citems
1152: ,mtl_customer_item_xrefs cxref
1153: ,mtl_system_items_vl sitems
1154: WHERE citems.customer_item_id = cxref.customer_item_id
1155: AND cxref.inventory_item_id = sitems.inventory_item_id
1156: AND sitems.inventory_item_id = p_inventory_item_id
1157: AND sitems.organization_id = OE_Bulk_Order_PVT.G_ITEM_ORG

Line 1171: , mtl_system_items_vl sitems

1167: SELECT 'valid'
1168: INTO l_dummy
1169: FROM mtl_cross_reference_types types
1170: , mtl_cross_references items
1171: , mtl_system_items_vl sitems
1172: WHERE types.cross_reference_type = items.cross_reference_type
1173: AND items.inventory_item_id = sitems.inventory_item_id
1174: AND sitems.organization_id = OE_Bulk_Order_PVT.G_ITEM_ORG
1175: AND sitems.inventory_item_id = p_inventory_item_id