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 2731: (SELECT 'x' FROM mtl_system_items_b_kfv item

2727: AND eipi.process_status = G_PS_IN_PROCESS
2728: AND ( (inventory_item_id IS NOT NULL
2729: AND
2730: NOT EXISTS
2731: (SELECT 'x' FROM mtl_system_items_b_kfv item
2732: WHERE item.organization_id = eipi.organization_id
2733: AND item.inventory_item_id = eipi.inventory_item_id)
2734: )
2735: OR

Line 2739: (SELECT 'x' FROM mtl_system_items_b_kfv item

2735: OR
2736: (inventory_item_id IS NULL
2737: AND
2738: NOT EXISTS
2739: (SELECT 'x' FROM mtl_system_items_b_kfv item
2740: WHERE item.organization_id = eipi.organization_id
2741: AND item.concatenated_segments = eipi.item_number)
2742: )
2743: );

Line 2748: from mtl_system_items_b_kfv item

2744:
2745: UPDATE ego_item_people_intf eipi
2746: SET item_number =
2747: (Select concatenated_segments
2748: from mtl_system_items_b_kfv item
2749: where item.organization_id = eipi.organization_id
2750: and item.inventory_item_id = eipi.inventory_item_id)
2751: WHERE eipi.data_set_id = G_DATA_SET_ID
2752: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER

Line 2759: from mtl_system_items_b_kfv item

2755:
2756: UPDATE ego_item_people_intf eipi
2757: SET inventory_item_id =
2758: (Select inventory_item_id
2759: from mtl_system_items_b_kfv item
2760: where item.organization_id = eipi.organization_id
2761: and item.concatenated_segments = eipi.item_number)
2762: WHERE eipi.data_set_id = G_DATA_SET_ID
2763: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER