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.JMF_SHIKYU_UTIL dependencies on RCV_TRANSACTIONS

Line 348: FROM RCV_TRANSACTIONS RT1, RCV_TRANSACTIONS RT2

344:
345: BEGIN
346: SELECT sum(RT1.PRIMARY_QUANTITY)
347: INTO l_returned_quantity
348: FROM RCV_TRANSACTIONS RT1, RCV_TRANSACTIONS RT2
349: WHERE RT1.TRANSACTION_TYPE = 'RETURN TO VENDOR'
350: AND RT1.PARENT_TRANSACTION_ID = RT2.TRANSACTION_ID
351: AND RT2.REPLENISH_ORDER_LINE_ID = p_replenishment_so_line_id;
352:

Line 389: FROM RCV_TRANSACTIONS

385:
386: BEGIN
387: SELECT PRIMARY_QUANTITY
388: INTO l_received_quantity
389: FROM RCV_TRANSACTIONS
390: WHERE TRANSACTION_TYPE IN ('RECEIVE','DELIVER')
391: AND REPLENISH_ORDER_LINE_ID = p_replenishment_so_line_id
392: AND ROWNUM = 1;
393: