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.WMS_TASK_LOAD dependencies on WMS_LPN_CONTENTS

Line 7365: FROM wms_lpn_contents wlc

7361: INTO l_item_cnt
7362: FROM DUAL
7363: WHERE EXISTS(
7364: SELECT 1
7365: FROM wms_lpn_contents wlc
7366: WHERE wlc.parent_lpn_id = p_fromlpn_id
7367: AND wlc.organization_id = p_org_id
7368: AND wlc.inventory_item_id = p_item_id
7369: AND NVL(wlc.revision, '-999') = NVL(p_rev, '-999'));

Line 7394: FROM wms_lpn_contents wlc, mtl_transaction_lots_temp mtlt

7390: INTO l_item_cnt
7391: FROM DUAL
7392: WHERE EXISTS(
7393: SELECT 1
7394: FROM wms_lpn_contents wlc, mtl_transaction_lots_temp mtlt
7395: WHERE wlc.parent_lpn_id = p_fromlpn_id
7396: AND wlc.organization_id = p_org_id
7397: AND wlc.inventory_item_id = p_item_id
7398: AND NVL(wlc.revision, '-999') = NVL(p_rev, '-999')

Line 7495: FROM wms_lpn_contents

7491: INTO l_item_cnt2
7492: , l_lot_cnt
7493: , l_rev_cnt
7494: , l_cg_cnt
7495: FROM wms_lpn_contents
7496: WHERE parent_lpn_id = p_fromlpn_id
7497: AND organization_id = p_org_id;
7498:
7499: SELECT COUNT(*)