APPS.WMS_RFID_DEVICE_PUB dependencies on RCV_SHIPMENT_HEADERS

Line 1713: FROM rcv_shipment_headers

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

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

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