APPS.OE_ID_TO_VALUE dependencies on MTL_SYSTEM_ITEMS

Line 2326: FROM MTL_SYSTEM_ITEMS

2322: l_validation_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2323:
2324: SELECT DESCRIPTION
2325: INTO l_inventory_item
2326: FROM MTL_SYSTEM_ITEMS
2327: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2328: AND ORGANIZATION_ID = l_validation_org_id;
2329:
2330:

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

Line 6821: FROM MTL_SYSTEM_ITEMS_B

6817:
6818: --webroot bug 6826344 start
6819: SELECT service_item_flag
6820: INTO l_temp
6821: FROM MTL_SYSTEM_ITEMS_B
6822: WHERE inventory_item_id = p_inventory_item_id
6823: AND organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
6824:
6825: --OE_MSG_PUB.ADD_TEXT('l_temp' || l_temp);