APPS.INV_RCV_INTEGRATION_PVT dependencies on RCV_SHIPMENT_HEADERS

Line 4403: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh

4399: BEGIN
4400: SELECT rsl.po_line_location_id,rsl.po_distribution_id,
4401: Decode(rsh.asn_type,'ASN','Y', 'ASBN','Y','N'),Decode(rsh.receipt_source_code,'INTERNAL ORDER','Y','N')
4402: INTO l_po_line_location_id,l_po_distribution_id,l_is_asn,l_is_req
4403: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
4404: WHERE rsl.shipment_line_id = p_shipment_line_id
4405: AND rsl.shipment_header_id = rsh.shipment_header_id;
4406: EXCEPTION
4407: WHEN OTHERS THEN

Line 8268: from rcv_shipment_headers

8264: --
8265: --Bug 13891514 Adding ASBN as well because the validations/processing is same for ASN/ASBN
8266: select decode(ASN_TYPE,'ASN','Y', 'ASBN','Y','N')
8267: into l_asn_line_flag
8268: from rcv_shipment_headers
8269: WHERE shipment_header_id = l_rti_rec.shipment_header_id;
8270: EXCEPTION
8271: WHEN OTHERS THEN
8272: l_asn_line_flag := 'N';

Line 11020: , rcv_shipment_headers rsh

11016: , l_po_header_id
11017: , l_req_line_id
11018: , l_oe_order_header_id
11019: FROM rcv_transactions rt
11020: , rcv_shipment_headers rsh
11021: WHERE rt.transaction_id = p_txn_source_id
11022: AND rt.shipment_header_id = rsh.shipment_header_id
11023: AND rt.organization_id = p_to_org_id
11024: AND exists (SELECT '1' FROM rcv_shipment_lines rsl

Line 11052: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn

11048: Decode(rsh.receipt_source_code,'INTERNAL
11049: ORDER','REQ','INVENTORY','INVENTORY','VENDOR','PO','CUSTOMER','RMA')
11050: INTO l_receipt_source_code
11051: , l_source_document_code
11052: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn
11053: WHERE RSH.SHIPMENT_HEADER_ID = WLPN.SOURCE_HEADER_ID
11054: AND WLPN.SOURCE_HEADER_ID IS NOT NULL
11055: AND wlpn.lpn_id = p_lpn_id
11056: AND exists (SELECT '1' FROM rcv_shipment_lines rsl

Line 11067: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn

11063: Decode(rsh.receipt_source_code,'INTERNAL
11064: ORDER','REQ','INVENTORY','INVENTORY','VENDOR','PO','CUSTOMER','RMA')
11065: INTO l_receipt_source_code
11066: , l_source_document_code
11067: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn
11068: WHERE RSH.SHIPMENT_NUM = WLPN.SOURCE_NAME
11069: AND WLPN.SOURCE_NAME IS NOT NULL
11070: AND wlpn.lpn_id = p_lpn_id
11071: AND exists (SELECT '1' FROM rcv_shipment_lines rsl

Line 14395: RCV_SHIPMENT_HEADERS RSH

14391: into l_source_header_id ,
14392: l_asn_type,
14393: l_lpn_context
14394: from WMS_LICENSE_PLATE_NUMBERS WLPN,
14395: RCV_SHIPMENT_HEADERS RSH
14396: where WLPN.lpn_id = l_lpn_rec.lpn_id
14397: AND (
14398: ((rsh.receipt_source_code IN ('INVENTORY','INTERNAL ORDER')
14399: AND rsh.organization_id = wlpn.organization_id) --BUG 4730474

Line 14439: FROM rcv_shipment_headers

14435: IF (l_lpn_rec.shipment_num IS NOT NULL) THEN
14436: BEGIN
14437: SELECT shipment_header_id
14438: INTO l_lpn_rec.shipment_header_id
14439: FROM rcv_shipment_headers
14440: WHERE shipment_num = l_lpn_rec.shipment_num;
14441: EXCEPTION
14442: WHEN OTHERS THEN
14443: NULL;

Line 19238: from rcv_shipment_headers

19234: -- WHERE shipment_line_id = l_shipment_line_id;
19235: --Bug 13891514 Adding ASBN as well because the validations/processing is same for ASN/ASBN
19236: select decode(ASN_TYPE,'ASN','Y', 'ASBN','Y','N')
19237: into l_asn_line_flag
19238: from rcv_shipment_headers
19239: WHERE shipment_header_id = l_shipment_header_id;
19240: ELSE
19241: l_asn_line_flag := 'N';
19242: END IF;