APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1109: FROM wms_license_plate_numbers wlpn

1105: SELECT 1,
1106: lpn_context
1107: INTO l_lpn_exists,
1108: l_lpn_context
1109: FROM wms_license_plate_numbers wlpn
1110: WHERE wlpn.organization_id = p_org_id
1111: AND wlpn.lpn_id = p_lpn;
1112:
1113: EXCEPTION

Line 1195: wms_license_plate_numbers w

1191: l_from_lpn,
1192: l_loc_id,
1193: l_lpn_context
1194: FROM
1195: wms_license_plate_numbers w
1196: WHERE
1197: w.lpn_id = p_lpn
1198: AND w.locator_id is not null;
1199:

Line 1278: FROM wms_license_plate_numbers

1274: INTO l_so_cnt
1275: FROM dual
1276: WHERE exists
1277: (SELECT 1
1278: FROM wms_license_plate_numbers
1279: WHERE lpn_id=p_lpn
1280: AND organization_id=p_org_id
1281: AND lpn_context = 11 --bug 9712391 : changed to check for LPN's that are staged /Check only closed delivery lines
1282: );

Line 1470: from wms_license_plate_numbers

1466: AND organization_id = p_org_id;
1467:
1468: select count(*)
1469: into l_lpn_include_lpn
1470: from wms_license_plate_numbers
1471: where outermost_lpn_id = p_lpn
1472: and organization_id = p_org_id;
1473:
1474:

Line 3148: SELECT wlpn.lpn_id,organization_id FROM wms_license_plate_numbers wlpn

3144: --For SO Pick, TM handles it in post 11.5.10.
3145: --In case the LPN is going to the non-LPN controlled sub then TM would have already unpacked and updated the lpn context TO 'defined but not used'. Leave these LPN as it is.
3146:
3147: CURSOR c_update_xfer_lpns_context IS
3148: SELECT wlpn.lpn_id,organization_id FROM wms_license_plate_numbers wlpn
3149: WHERE wlpn.lpn_context <> wms_container_pub.lpn_context_pregenerated
3150: --to avoid LPNS that have been unpacked by TM for non-LPN ctrld sub
3151: AND wlpn.lpn_id IN
3152: (SELECT wdr.xfer_lpn_id

Line 3460: FROM wms_license_plate_numbers WHERE

3456:
3457: BEGIN
3458: SELECT lpn_context
3459: INTO l_pick_lpn_context
3460: FROM wms_license_plate_numbers WHERE
3461: lpn_id = l_rec.lpn_id
3462: AND organization_id = l_rec.organization_id;
3463:
3464:

Line 3566: FROM wms_license_plate_numbers WHERE

3562:
3563: BEGIN
3564: SELECT lpn_context,license_plate_number
3565: INTO l_lpn_context, l_xfer_lpn
3566: FROM wms_license_plate_numbers WHERE
3567: lpn_id = l_rec.xfer_lpn_id
3568: AND organization_id = l_rec.organization_id;
3569:
3570: IF (l_debug = 1) THEN

Line 4165: UPDATE wms_license_plate_numbers

4161: --
4162:
4163: /* updated as part of the bug 4411819
4164: --using wms_container_pvt.Modify_LPN() API instead
4165: UPDATE wms_license_plate_numbers
4166: SET lpn_context = l_lpn_context -- this still has
4167: --the original value of lpn context
4168: WHERE lpn_id = l_rec.xfer_lpn_id;
4169: */