APPS.POS_ASN_CREATE_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 663: l_lpn_context wms_license_plate_numbers.lpn_context%type;

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

Line 688: from wms_license_plate_numbers

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

Line 1471: wms_license_plate_numbers wlpn, po_line_locations_all pll

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