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_SECONDARY_INVENTORIES

Line 1162: FROM MTL_SECONDARY_INVENTORIES msi

1158: , p_organization_id NUMBER
1159: )
1160: IS
1161: SELECT msi.SECONDARY_INVENTORY_NAME
1162: FROM MTL_SECONDARY_INVENTORIES msi
1163: WHERE msi.ORGANIZATION_ID = p_model_org_id
1164: AND NOT EXISTS
1165: ( SELECT 'x'
1166: FROM MTL_SECONDARY_INVENTORIES msi2

Line 1166: FROM MTL_SECONDARY_INVENTORIES msi2

1162: FROM MTL_SECONDARY_INVENTORIES msi
1163: WHERE msi.ORGANIZATION_ID = p_model_org_id
1164: AND NOT EXISTS
1165: ( SELECT 'x'
1166: FROM MTL_SECONDARY_INVENTORIES msi2
1167: WHERE msi2.ORGANIZATION_ID = p_organization_id
1168: AND msi.SECONDARY_INVENTORY_NAME = msi2.SECONDARY_INVENTORY_NAME
1169: );
1170: CURSOR l_cnt_csr ( p_org_id NUMBER )

Line 1173: FROM MTL_SECONDARY_INVENTORIES msi

1169: );
1170: CURSOR l_cnt_csr ( p_org_id NUMBER )
1171: IS
1172: SELECT COUNT(msi.SECONDARY_INVENTORY_NAME)
1173: FROM MTL_SECONDARY_INVENTORIES msi
1174: WHERE msi.ORGANIZATION_ID = p_org_id;
1175:
1176: BEGIN
1177: IF G_DEBUG = 'Y' THEN

Line 4356: FROM MTL_SECONDARY_INVENTORIES

4352: END IF;
4353:
4354: SELECT 1
4355: INTO l_receiving_subinv_count
4356: FROM MTL_SECONDARY_INVENTORIES
4357: WHERE ORGANIZATION_ID = p_organization_id
4358: AND SUBINVENTORY_TYPE = 2
4359: AND ROWNUM = 1;
4360: