APPS.INV_STATUS_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 685: FROM wms_license_plate_numbers plpn

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
687: connect by parent_lpn_id = prior lpn_id
688: )
689: order by serial_summary_entry

Line 1014: FROM wms_license_plate_numbers

1010: WHERE status_id = p_onhand_status_id;
1011: --end of bug 6952533
1012: IF(l_allow_mixed_status = 2)THEN
1013: SELECT outermost_lpn_id into l_outermost_lpn_id
1014: FROM wms_license_plate_numbers
1015: WHERE lpn_id = p_lpn_id ;
1016: l_ret_status := get_mixed_status(p_lpn_id => p_lpn_id,
1017: p_organization_id =>p_organization_id,
1018: p_outermost_lpn_id => l_outermost_lpn_id,

Line 1081: FROM wms_license_plate_numbers

1077: mdebug('came here for updating serial in range to status '|| p_onhand_status_id);
1078:
1079: IF ( l_allow_mixed_status = 2) THEN
1080: SELECT outermost_lpn_id into l_outermost_lpn_id
1081: FROM wms_license_plate_numbers
1082: WHERE lpn_id = p_lpn_id ;
1083: l_ret_status := get_mixed_status_serial(p_lpn_id => p_lpn_id,
1084: p_organization_id =>p_organization_id ,
1085: p_outermost_lpn_id => l_outermost_lpn_id,

Line 1115: FROM wms_license_plate_numbers

1111: --lpn status project
1112: IF(p_lpn_id IS NOT null)THEN
1113: IF(l_allow_mixed_status = 2)THEN
1114: SELECT outermost_lpn_id into l_outermost_lpn_id
1115: FROM wms_license_plate_numbers
1116: WHERE lpn_id = p_lpn_id;
1117: l_ret_status := get_mixed_status(p_lpn_id => p_lpn_id,
1118: p_organization_id =>p_organization_id,
1119: p_outermost_lpn_id => l_outermost_lpn_id,

Line 1783: FROM wms_license_plate_numbers plpn

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
1785: connect by parent_lpn_id = prior lpn_id
1786: )
1787: and wlc.parent_lpn_id not in

Line 1789: FROM wms_license_plate_numbers plpn

1785: connect by parent_lpn_id = prior lpn_id
1786: )
1787: and wlc.parent_lpn_id not in
1788: (SELECT lpn_id
1789: FROM wms_license_plate_numbers plpn
1790: start with lpn_id = p_lpn_id
1791: connect by parent_lpn_id = prior lpn_id
1792: );
1793: CURSOR wlc_item_cur is

Line 1798: FROM wms_license_plate_numbers plpn

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
1800: connect by parent_lpn_id = prior lpn_id
1801: );
1802: CURSOR msn_cur(l_inventory_item_id NUMBER,l_lpn_id NUMBER) is

Line 1943: FROM wms_license_plate_numbers plpn

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
1945: connect by parent_lpn_id = prior lpn_id
1946: );
1947: CURSOR msn_cur(l_inventory_item_id NUMBER,l_lpn_id NUMBER) is