eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_PRE_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 2231: FROM mtl_system_items_vl

2227: AND osp.org_id = MO_GLOBAL.get_current_org_id(); -- BUG 5058027
2228:
2229: CURSOR get_item_number ( pc_item_id IN NUMBER, pc_org_id IN NUMBER) IS
2230: SELECT concatenated_segments
2231: FROM mtl_system_items_vl
2232: WHERE inventory_item_id = pc_item_id
2233: AND organization_id = pc_org_id;
2234:
2235: CURSOR price_list_org(cv_price_list_id IN NUMBER) IS

Line 4383: FROM mtl_system_items_vl

4379: CURSOR get_inventory_item_id( pc_item_number IN VARCHAR2
4380: , pc_org_id IN NUMBER
4381: ) IS
4382: SELECT inventory_item_id
4383: FROM mtl_system_items_vl
4384: WHERE concatenated_segments = pc_item_number
4385: AND organization_id = pc_org_id;
4386:
4387: CURSOR chk_inventory_item_id (pc_item_id IN NUMBER) IS

Line 4389: FROM mtl_system_items

4385: AND organization_id = pc_org_id;
4386:
4387: CURSOR chk_inventory_item_id (pc_item_id IN NUMBER) IS
4388: SELECT 'X'
4389: FROM mtl_system_items
4390: WHERE inventory_item_id = pc_item_id;
4391:
4392: BEGIN
4393: IF OZF_DEBUG_HIGH_ON THEN