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_DEVICE_CONFIRMATION_PUB dependencies on WMS_LPN_CONTENTS

Line 1333: FROM wms_lpn_contents wlc

1329: BEGIN
1330:
1331: SELECT 1 INTO l_item_cnt FROM DUAL WHERE exists
1332: ( SELECT 1
1333: FROM wms_lpn_contents wlc
1334: WHERE wlc.parent_lpn_id = p_lpn
1335: AND wlc.organization_id = p_org_id
1336: AND wlc.inventory_item_id = p_item_id
1337: AND Nvl(wlc.revision,'-999') = Nvl(p_rev,Nvl(wlc.revision,'-999'))); --bug 2495592

Line 1362: FROM wms_lpn_contents wlc,

1358: BEGIN
1359:
1360: SELECT 1 INTO l_item_cnt FROM DUAL WHERE exists
1361: ( SELECT 1
1362: FROM wms_lpn_contents wlc,
1363: mtl_transaction_lots_temp mtlt
1364: WHERE wlc.parent_lpn_id = p_lpn
1365: AND wlc.organization_id = p_org_id
1366: AND wlc.inventory_item_id = p_item_id

Line 1464: FROM wms_lpn_contents

1460: INTO l_item_cnt2,
1461: l_lot_cnt,
1462: l_rev_cnt,
1463: l_cg_cnt
1464: FROM wms_lpn_contents
1465: WHERE parent_lpn_id = p_lpn
1466: AND organization_id = p_org_id;
1467:
1468: select count(*)