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_SYSTEM_ITEMS_B

Line 2244: FROM MTL_SYSTEM_ITEMS_B msi1

2240: , p_organization_id NUMBER
2241: )
2242: IS
2243: SELECT kfv.CONCATENATED_SEGMENTS
2244: FROM MTL_SYSTEM_ITEMS_B msi1
2245: , MTL_SYSTEM_ITEMS_KFV kfv
2246: WHERE kfv.ORGANIZATION_ID = msi1.ORGANIZATION_ID
2247: AND kfv.INVENTORY_ITEM_ID = msi1.INVENTORY_ITEM_ID
2248: AND msi1.ORGANIZATION_ID = p_model_org_id

Line 2251: FROM MTL_SYSTEM_ITEMS_B msi2

2247: AND kfv.INVENTORY_ITEM_ID = msi1.INVENTORY_ITEM_ID
2248: AND msi1.ORGANIZATION_ID = p_model_org_id
2249: AND NOT EXISTS
2250: ( SELECT 'x'
2251: FROM MTL_SYSTEM_ITEMS_B msi2
2252: WHERE msi2.INVENTORY_ITEM_ID = msi1.INVENTORY_ITEM_ID
2253: AND msi2.ORGANIZATION_ID = p_organization_id
2254: );
2255:

Line 2259: FROM MTL_SYSTEM_ITEMS_B msi

2255:
2256: CURSOR l_cnt_csr ( p_org_id NUMBER )
2257: IS
2258: SELECT COUNT(msi.INVENTORY_ITEM_ID)
2259: FROM MTL_SYSTEM_ITEMS_B msi
2260: WHERE msi.ORGANIZATION_ID = p_org_id;
2261:
2262: BEGIN
2263: