APPS.POS_ASN_CREATE_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 662: l_lpn_context wms_license_plate_numbers.lpn_context%type;

658: l_msg_data varchar2(2000);
659: l_ans boolean;
660: l_org_id number;
661: l_lpn_id number;
662: l_lpn_context wms_license_plate_numbers.lpn_context%type;
663: l_error_msg varchar2(2000);
664: BEGIN
665:
666: select

Line 687: from wms_license_plate_numbers

683:
684: --the inv api does not check for context value
685: if(l_ans = true) then
686: select lpn_context into l_lpn_context
687: from wms_license_plate_numbers
688: where lpn_id = l_lpn_id;
689:
690: --can only reuse the LPNs that have a context of 5
691: if(l_lpn_context is not null AND l_lpn_context <> 5) then

Line 1470: wms_license_plate_numbers wlpn, po_line_locations_all pll

1466:
1467: select count(*)
1468: into l_rows
1469: from rcv_shipment_lines rsl, po_headers_all poh, po_releases_all por,
1470: wms_license_plate_numbers wlpn, po_line_locations_all pll
1471: where rsl.po_header_id = poh.po_header_id
1472: and rsl.po_release_id = por.po_release_id(+)
1473: and rsl.ASN_LPN_ID = wlpn.LPN_ID
1474: and rsl.po_line_location_id = pll.line_location_id