APPS.INV_STATUS_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 346: FROM wms_license_plate_numbers plpn

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
348: connect by parent_lpn_id = prior lpn_id
349: )
350: order by serial_summary_entry

Line 491: FROM wms_license_plate_numbers

487: WHERE status_id = p_onhand_status_id;
488: --end of bug 6952533
489: IF(l_allow_mixed_status = 2)THEN
490: SELECT outermost_lpn_id into l_outermost_lpn_id
491: FROM wms_license_plate_numbers
492: WHERE lpn_id = p_lpn_id ;
493: l_ret_status := get_mixed_status(p_lpn_id => p_lpn_id,
494: p_organization_id =>p_organization_id,
495: p_outermost_lpn_id => l_outermost_lpn_id,

Line 558: FROM wms_license_plate_numbers

554: mdebug('came here for updating serial in range to status '|| p_onhand_status_id);
555:
556: IF ( l_allow_mixed_status = 2) THEN
557: SELECT outermost_lpn_id into l_outermost_lpn_id
558: FROM wms_license_plate_numbers
559: WHERE lpn_id = p_lpn_id ;
560: l_ret_status := get_mixed_status_serial(p_lpn_id => p_lpn_id,
561: p_organization_id =>p_organization_id ,
562: p_outermost_lpn_id => l_outermost_lpn_id,

Line 592: FROM wms_license_plate_numbers

588: --lpn status project
589: IF(p_lpn_id IS NOT null)THEN
590: IF(l_allow_mixed_status = 2)THEN
591: SELECT outermost_lpn_id into l_outermost_lpn_id
592: FROM wms_license_plate_numbers
593: WHERE lpn_id = p_lpn_id;
594: l_ret_status := get_mixed_status(p_lpn_id => p_lpn_id,
595: p_organization_id =>p_organization_id,
596: p_outermost_lpn_id => l_outermost_lpn_id,

Line 1161: FROM wms_license_plate_numbers plpn

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
1163: connect by parent_lpn_id = prior lpn_id
1164: )
1165: and wlc.parent_lpn_id not in

Line 1167: FROM wms_license_plate_numbers plpn

1163: connect by parent_lpn_id = prior lpn_id
1164: )
1165: and wlc.parent_lpn_id not in
1166: (SELECT lpn_id
1167: FROM wms_license_plate_numbers plpn
1168: start with lpn_id = p_lpn_id
1169: connect by parent_lpn_id = prior lpn_id
1170: );
1171: CURSOR wlc_item_cur is

Line 1176: FROM wms_license_plate_numbers plpn

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

Line 1321: FROM wms_license_plate_numbers plpn

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