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

Line 343: FROM wms_lpn_contents wlc

339:
340: CURSOR wlc_cur
341: IS
342: SELECT *
343: FROM wms_lpn_contents wlc
344: WHERE wlc.parent_lpn_id IN
345: (SELECT lpn_id
346: FROM wms_license_plate_numbers plpn
347: start with lpn_id = p_lpn_id

Line 1158: FROM wms_lpn_contents wlc

1154: RETURN VARCHAR2 is
1155:
1156: CURSOR wlc_cur is
1157: SELECT *
1158: FROM wms_lpn_contents wlc
1159: WHERE wlc.parent_lpn_id IN
1160: (SELECT lpn_id
1161: FROM wms_license_plate_numbers plpn
1162: start with lpn_id = p_outermost_lpn_id

Line 1173: FROM wms_lpn_contents wlc

1169: connect by parent_lpn_id = prior lpn_id
1170: );
1171: CURSOR wlc_item_cur is
1172: SELECT *
1173: FROM wms_lpn_contents wlc
1174: WHERE wlc.parent_lpn_id IN
1175: (SELECT lpn_id
1176: FROM wms_license_plate_numbers plpn
1177: start with lpn_id = p_outermost_lpn_id

Line 1318: FROM wms_lpn_contents wlc

1314: p_status_id NUMBER)
1315: RETURN VARCHAR2 is
1316: CURSOR wlc_item_cur is
1317: SELECT *
1318: FROM wms_lpn_contents wlc
1319: WHERE wlc.parent_lpn_id IN
1320: (SELECT lpn_id
1321: FROM wms_license_plate_numbers plpn
1322: start with lpn_id = p_outermost_lpn_id