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 2335: FROM mtl_system_items_vl

2331: AND osp.org_id = MO_GLOBAL.get_current_org_id(); -- BUG 5058027
2332:
2333: CURSOR get_item_number ( pc_item_id IN NUMBER, pc_org_id IN NUMBER) IS
2334: SELECT concatenated_segments
2335: FROM mtl_system_items_vl
2336: WHERE inventory_item_id = pc_item_id
2337: AND organization_id = pc_org_id;
2338:
2339: CURSOR price_list_org(cv_price_list_id IN NUMBER) IS

Line 4718: FROM mtl_system_items_vl

4714: CURSOR get_inventory_item_id( pc_item_number IN VARCHAR2
4715: , pc_org_id IN NUMBER
4716: ) IS
4717: SELECT inventory_item_id
4718: FROM mtl_system_items_vl
4719: WHERE concatenated_segments = pc_item_number
4720: AND organization_id = pc_org_id;
4721:
4722: CURSOR chk_inventory_item_id (pc_item_id IN NUMBER) IS

Line 4724: FROM mtl_system_items

4720: AND organization_id = pc_org_id;
4721:
4722: CURSOR chk_inventory_item_id (pc_item_id IN NUMBER) IS
4723: SELECT 'X'
4724: FROM mtl_system_items
4725: WHERE inventory_item_id = pc_item_id;
4726:
4727: BEGIN
4728: IF OZF_DEBUG_HIGH_ON THEN