DBA Data[Home] [Help]

APPS.OE_ORDER_MISC_UTIL dependencies on MTL_SYSTEM_ITEMS_VL

Line 52: FROM mtl_system_items_vl

48: ,description
49: INTO x_ordered_item
50: ,x_inventory_item
51: ,x_ordered_item_desc
52: FROM mtl_system_items_vl
53: WHERE inventory_item_id = p_inventory_item_id
54: AND organization_id = l_organization_id;
55:
56: ELSIF NVL(p_item_identifier_type, 'INT') = 'CUST' AND

Line 67: ,mtl_system_items_vl sitems

63: ,x_inventory_item
64: ,x_ordered_item_desc
65: FROM mtl_customer_items citems
66: ,mtl_customer_item_xrefs cxref
67: ,mtl_system_items_vl sitems
68: WHERE citems.customer_item_id = cxref.customer_item_id
69: AND cxref.inventory_item_id = sitems.inventory_item_id
70: AND sitems.inventory_item_id = p_inventory_item_id
71: AND sitems.organization_id = l_organization_id

Line 101: , mtl_system_items_vl sitems

97: ,x_inventory_item
98: ,x_ordered_item_desc
99: FROM mtl_cross_reference_types types
100: , mtl_cross_references items
101: , mtl_system_items_vl sitems
102: WHERE types.cross_reference_type = items.cross_reference_type
103: AND items.inventory_item_id = sitems.inventory_item_id
104: AND sitems.organization_id = l_organization_id
105: AND sitems.inventory_item_id = p_inventory_item_id