APPS.WMS_RFID_DEVICE_PUB dependencies on RCV_SHIPMENT_HEADERS

Line 1712: FROM rcv_shipment_headers

1708: END IF;
1709:
1710: SELECT shipment_num,vendor_id
1711: INTO l_shipment_num,l_vendor_id
1712: FROM rcv_shipment_headers
1713: WHERE shipment_header_id = l_shipment_header_id;
1714:
1715: IF (l_debug = 1) THEN
1716: trace('process_rfid_receiving_txn: ASN/Inernal req l_source_type'|| l_source_type);

Line 3283: rcv_shipment_headers rsh ,wms_license_plate_numbers wlpn where wlpn.lpn_id = l_lpn_id

3279: --receiving
3280: l_progress := '40';
3281: BEGIN
3282: select rsh.shipment_header_id into l_shipment_header_id from
3283: rcv_shipment_headers rsh ,wms_license_plate_numbers wlpn where wlpn.lpn_id = l_lpn_id
3284: and wlpn.lpn_context IN (6,7) --for ASN 7, blocked for ASN in patch set J
3285: and (rsh.shipment_num = Nvl(wlpn.source_name,'@#$@')
3286: or rsh.shipment_header_id = Nvl(wlpn.source_header_id, -1));
3287: