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_LOGICAL_TRANSACTIONS_PVT dependencies on DUAL

Line 442: SELECT 1 INTO l_count FROM dual WHERE exists

438:
439: l_count := 0;
440:
441: BEGIN
442: SELECT 1 INTO l_count FROM dual WHERE exists
443: (
444: SELECT null FROM MTL_SECONDARY_INVENTORIES MTSI,
445: MTL_SYSTEM_ITEMS MSI
446: WHERE MSI.ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id

Line 517: SELECT 1 INTO l_count FROM dual WHERE exists

513:
514: l_count := 0;
515:
516: BEGIN
517: SELECT 1 INTO l_count FROM dual WHERE exists
518: (
519: SELECT null FROM MTL_SECONDARY_LOCATORS MSL,
520: MTL_SYSTEM_ITEMS MSI
521: WHERE MSI.ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id

Line 1658: FROM dual;

1654: IF (p_lot_control_code = 2) THEN
1655: IF (p_serial_control_code in (2, 5, 6)) THEN
1656: SELECT mtl_material_transactions_s.nextval
1657: INTO l_serial_transaction_id
1658: FROM dual;
1659: ELSE
1660: l_serial_transaction_id := null;
1661: END IF;
1662: