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.EGO_ITEM_PEOPLE_IMPORT_PKG dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 2459: (SELECT 'x' FROM mtl_system_items_b_kfv item

2455: AND eipi.process_status = G_PS_IN_PROCESS
2456: AND ( (inventory_item_id IS NOT NULL
2457: AND
2458: NOT EXISTS
2459: (SELECT 'x' FROM mtl_system_items_b_kfv item
2460: WHERE item.organization_id = eipi.organization_id
2461: AND item.inventory_item_id = eipi.inventory_item_id)
2462: )
2463: OR

Line 2467: (SELECT 'x' FROM mtl_system_items_b_kfv item

2463: OR
2464: (inventory_item_id IS NULL
2465: AND
2466: NOT EXISTS
2467: (SELECT 'x' FROM mtl_system_items_b_kfv item
2468: WHERE item.organization_id = eipi.organization_id
2469: AND item.concatenated_segments = eipi.item_number)
2470: )
2471: );

Line 2476: from mtl_system_items_b_kfv item

2472:
2473: UPDATE ego_item_people_intf eipi
2474: SET item_number =
2475: (Select concatenated_segments
2476: from mtl_system_items_b_kfv item
2477: where item.organization_id = eipi.organization_id
2478: and item.inventory_item_id = eipi.inventory_item_id)
2479: WHERE eipi.data_set_id = G_DATA_SET_ID
2480: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER

Line 2487: from mtl_system_items_b_kfv item

2483:
2484: UPDATE ego_item_people_intf eipi
2485: SET inventory_item_id =
2486: (Select inventory_item_id
2487: from mtl_system_items_b_kfv item
2488: where item.organization_id = eipi.organization_id
2489: and item.concatenated_segments = eipi.item_number)
2490: WHERE eipi.data_set_id = G_DATA_SET_ID
2491: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER