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.GMI_MSCA_PUB dependencies on IC_LOTS_STS

Line 686: FROM ic_lots_sts sts

682: IS
683:
684: CURSOR get_lot_stat( item IN NUMBER, whse IN VARCHAR2, loct IN VARCHAR2, lot IN NUMBER, stat IN VARCHAR2) IS
685: SELECT ili.lot_status
686: FROM ic_lots_sts sts
687: , ic_loct_inv ili
688: WHERE ili.lot_status = sts.lot_status
689: AND sts.lot_status LIKE stat
690: AND ili.location = loct