DBA Data[Home] [Help]

APPS.OE_ID_TO_VALUE dependencies on MTL_SYSTEM_ITEMS_VL

Line 5733: FROM mtl_system_items_vl

5729: SELECT concatenated_segments
5730: ,concatenated_segments
5731: INTO x_ordered_item
5732: ,x_inventory_item
5733: FROM mtl_system_items_vl
5734: WHERE inventory_item_id = p_inventory_item_id
5735: AND organization_id = p_organization_id;
5736: IF l_debug_level > 0 THEN
5737: oe_debug_pub.add( 'ORDERED_ITEM_DSP: '||X_ORDERED_ITEM ) ;

Line 5759: ,mtl_system_items_vl sitems

5755: INTO x_ordered_item
5756: ,x_inventory_item
5757: FROM mtl_customer_items citems
5758: ,mtl_customer_item_xrefs cxref
5759: ,mtl_system_items_vl sitems
5760: WHERE citems.customer_item_id = cxref.customer_item_id
5761: AND cxref.inventory_item_id = sitems.inventory_item_id
5762: AND sitems.inventory_item_id = p_inventory_item_id
5763: AND sitems.organization_id = p_organization_id

Line 5790: , mtl_system_items_vl sitems

5786: INTO x_ordered_item
5787: ,x_inventory_item
5788: FROM mtl_cross_reference_types types
5789: , mtl_cross_references items
5790: , mtl_system_items_vl sitems
5791: WHERE types.cross_reference_type = items.cross_reference_type
5792: AND items.inventory_item_id = sitems.inventory_item_id
5793: AND sitems.organization_id = p_organization_id
5794: AND sitems.inventory_item_id = p_inventory_item_id