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.INV_COPY_ORGANIZATION_REPORT dependencies on MTL_ITEM_SUB_INVENTORIES

Line 2525: FROM MTL_ITEM_SUB_INVENTORIES sub1

2521: , p_organization_id NUMBER
2522: )
2523: IS
2524: SELECT kfv.CONCATENATED_SEGMENTS||': '||sub1.SECONDARY_INVENTORY
2525: FROM MTL_ITEM_SUB_INVENTORIES sub1
2526: , MTL_SYSTEM_ITEMS_KFV kfv
2527: WHERE kfv.ORGANIZATION_ID = sub1.ORGANIZATION_ID
2528: AND kfv.INVENTORY_ITEM_ID = sub1.INVENTORY_ITEM_ID
2529: AND sub1.ORGANIZATION_ID = p_model_org_id

Line 2532: FROM MTL_ITEM_SUB_INVENTORIES sub2

2528: AND kfv.INVENTORY_ITEM_ID = sub1.INVENTORY_ITEM_ID
2529: AND sub1.ORGANIZATION_ID = p_model_org_id
2530: AND NOT EXISTS
2531: ( SELECT 'x'
2532: FROM MTL_ITEM_SUB_INVENTORIES sub2
2533: WHERE sub2.SECONDARY_INVENTORY = sub1.SECONDARY_INVENTORY
2534: AND sub2.INVENTORY_ITEM_ID = sub1.INVENTORY_ITEM_ID
2535: AND sub2.ORGANIZATION_ID = p_organization_id
2536: );

Line 2541: FROM MTL_ITEM_SUB_INVENTORIES sub

2537:
2538: CURSOR l_cnt_csr ( p_org_id NUMBER )
2539: IS
2540: SELECT COUNT(sub.SECONDARY_INVENTORY)
2541: FROM MTL_ITEM_SUB_INVENTORIES sub
2542: WHERE sub.ORGANIZATION_ID=p_org_id;
2543:
2544: BEGIN
2545: