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 813: FROM wms_lpn_contents wlc

809: BEGIN
810:
811: SELECT 1 INTO l_item_cnt FROM DUAL WHERE exists
812: ( SELECT 1
813: FROM wms_lpn_contents wlc
814: WHERE wlc.parent_lpn_id = p_lpn
815: AND wlc.organization_id = p_org_id
816: AND wlc.inventory_item_id = p_item_id
817: AND Nvl(wlc.revision,'-999') = Nvl(p_rev,Nvl(wlc.revision,'-999'))); --bug 2495592

Line 842: FROM wms_lpn_contents wlc,

838: BEGIN
839:
840: SELECT 1 INTO l_item_cnt FROM DUAL WHERE exists
841: ( SELECT 1
842: FROM wms_lpn_contents wlc,
843: mtl_transaction_lots_temp mtlt
844: WHERE wlc.parent_lpn_id = p_lpn
845: AND wlc.organization_id = p_org_id
846: AND wlc.inventory_item_id = p_item_id

Line 944: FROM wms_lpn_contents

940: INTO l_item_cnt2,
941: l_lot_cnt,
942: l_rev_cnt,
943: l_cg_cnt
944: FROM wms_lpn_contents
945: WHERE parent_lpn_id = p_lpn
946: AND organization_id = p_org_id;
947:
948: select count(*)