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_DCP_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1227: FROM MTL_MATERIAL_TRANSACTIONS_TEMP a,MTL_SERIAL_NUMBERS b,

1223: A.SUBINVENTORY_CODE,A.LOCATOR_ID,A.REVISION,A.LOT_NUMBER,
1224: A.TRANSFER_SUBINVENTORY,a.TRANSFER_TO_LOCATION,
1225: b.CURRENT_SUBINVENTORY_CODE,b.CURRENT_LOCATOR_ID,b.REVISION current_revision,
1226: b.CURRENT_STATUS,b.SERIAL_NUMBER,b.current_organization_id,d.SERIAL_NUMBER_CONTROL_CODE
1227: FROM MTL_MATERIAL_TRANSACTIONS_TEMP a,MTL_SERIAL_NUMBERS b,
1228: MTL_SERIAL_NUMBERS_TEMP c,MTL_SYSTEM_ITEMS d
1229: WHERE A.TRANSACTION_TEMP_ID = C.TRANSACTION_TEMP_ID
1230: AND LPAD(B.SERIAL_NUMBER,30) >= LPAD(C.FM_SERIAL_NUMBER,30)
1231: AND LPAD(NVL(B.SERIAL_NUMBER,'-99'),30) <= LPAD(NVL(C.TO_SERIAL_NUMBER,'-99'),30)

Line 1228: MTL_SERIAL_NUMBERS_TEMP c,MTL_SYSTEM_ITEMS d

1224: A.TRANSFER_SUBINVENTORY,a.TRANSFER_TO_LOCATION,
1225: b.CURRENT_SUBINVENTORY_CODE,b.CURRENT_LOCATOR_ID,b.REVISION current_revision,
1226: b.CURRENT_STATUS,b.SERIAL_NUMBER,b.current_organization_id,d.SERIAL_NUMBER_CONTROL_CODE
1227: FROM MTL_MATERIAL_TRANSACTIONS_TEMP a,MTL_SERIAL_NUMBERS b,
1228: MTL_SERIAL_NUMBERS_TEMP c,MTL_SYSTEM_ITEMS d
1229: WHERE A.TRANSACTION_TEMP_ID = C.TRANSACTION_TEMP_ID
1230: AND LPAD(B.SERIAL_NUMBER,30) >= LPAD(C.FM_SERIAL_NUMBER,30)
1231: AND LPAD(NVL(B.SERIAL_NUMBER,'-99'),30) <= LPAD(NVL(C.TO_SERIAL_NUMBER,'-99'),30)
1232: AND A.ORGANIZATION_ID = nvl(B.CURRENT_ORGANIZATION_ID,A.ORGANIZATION_ID)