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 5815: , mtl_system_items_vl sitems

5811: INTO x_ordered_item
5812: ,x_inventory_item
5813: FROM mtl_cross_reference_types types
5814: , mtl_cross_references items
5815: , mtl_system_items_vl sitems
5816: WHERE types.cross_reference_type = items.cross_reference_type
5817: AND items.inventory_item_id = sitems.inventory_item_id
5818: AND sitems.organization_id = p_organization_id
5819: AND sitems.inventory_item_id = p_inventory_item_id