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.WIP_JOBCLOSE_PRIV dependencies on MTL_TXN_REQUEST_LINES

Line 168: MTL_TXN_REQUEST_LINES MTRL

164: AND NOT EXISTS
165: (SELECT 'X'
166: FROM WIP_LPN_COMPLETIONS WLC,
167: WMS_LICENSE_PLATE_NUMBERS LPN,
168: MTL_TXN_REQUEST_LINES MTRL
169: WHERE WLC.ORGANIZATION_ID = p_organization_id
170: AND WLC.LPN_ID = LPN.LPN_ID
171: AND MTRL.LPN_ID = LPN.LPN_ID
172: AND MTRL.TXN_SOURCE_ID = WLC.WIP_ENTITY_ID

Line 769: FROM MTL_TXN_REQUEST_LINES

765: WHERE ORGANIZATION_ID = p_organization_id
766: AND TRANSACTION_SOURCE_TYPE_ID = 5
767: AND TRANSACTION_SOURCE_ID NOT IN
768: (SELECT TXN_SOURCE_ID
769: FROM MTL_TXN_REQUEST_LINES
770: WHERE TXN_SOURCE_ID = MMTT.TRANSACTION_SOURCE_ID
771: AND ORGANIZATION_ID = MMTT.ORGANIZATION_ID
772: AND LINE_STATUS = 9)
773: UNION ALL

Line 788: MTL_TXN_REQUEST_LINES MTRL

784: UNION ALL
785: SELECT WLC.WIP_ENTITY_ID
786: FROM WIP_LPN_COMPLETIONS WLC,
787: WMS_LICENSE_PLATE_NUMBERS LPN ,
788: MTL_TXN_REQUEST_LINES MTRL
789: WHERE WLC.ORGANIZATION_ID = p_organization_id
790: AND WLC.LPN_ID = LPN.LPN_ID
791: AND MTRL.LPN_ID = LPN.LPN_ID
792: AND MTRL.txn_source_id = WLC.wip_entity_id