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

678:
679: CURSOR wlc_cur
680: IS
681: SELECT *
682: FROM wms_lpn_contents wlc
683: WHERE wlc.parent_lpn_id IN
684: (SELECT lpn_id
685: FROM wms_license_plate_numbers plpn
686: start with lpn_id = p_lpn_id

Line 1780: FROM wms_lpn_contents wlc

1776: RETURN VARCHAR2 is
1777:
1778: CURSOR wlc_cur is
1779: SELECT *
1780: FROM wms_lpn_contents wlc
1781: WHERE wlc.parent_lpn_id IN
1782: (SELECT lpn_id
1783: FROM wms_license_plate_numbers plpn
1784: start with lpn_id = p_outermost_lpn_id

Line 1795: FROM wms_lpn_contents wlc

1791: connect by parent_lpn_id = prior lpn_id
1792: );
1793: CURSOR wlc_item_cur is
1794: SELECT *
1795: FROM wms_lpn_contents wlc
1796: WHERE wlc.parent_lpn_id IN
1797: (SELECT lpn_id
1798: FROM wms_license_plate_numbers plpn
1799: start with lpn_id = p_outermost_lpn_id

Line 1940: FROM wms_lpn_contents wlc

1936: p_status_id NUMBER)
1937: RETURN VARCHAR2 is
1938: CURSOR wlc_item_cur is
1939: SELECT *
1940: FROM wms_lpn_contents wlc
1941: WHERE wlc.parent_lpn_id IN
1942: (SELECT lpn_id
1943: FROM wms_license_plate_numbers plpn
1944: start with lpn_id = p_outermost_lpn_id