APPS.INV_RCV_INTEGRATION_PVT dependencies on RCV_SHIPMENT_HEADERS

Line 4330: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh

4326: BEGIN
4327: SELECT rsl.po_line_location_id,rsl.po_distribution_id,
4328: Decode(rsh.asn_type,'ASN','Y','N'),Decode(rsh.receipt_source_code,'INTERNAL ORDER','Y','N')
4329: INTO l_po_line_location_id,l_po_distribution_id,l_is_asn,l_is_req
4330: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
4331: WHERE rsl.shipment_line_id = p_shipment_line_id
4332: AND rsl.shipment_header_id = rsh.shipment_header_id;
4333: EXCEPTION
4334: WHEN OTHERS THEN

Line 7957: from rcv_shipment_headers

7953: -- WHERE shipment_line_id = l_rti_rec.shipment_line_id;
7954: --
7955: select decode(ASN_TYPE,'ASN','Y','N')
7956: into l_asn_line_flag
7957: from rcv_shipment_headers
7958: WHERE shipment_header_id = l_rti_rec.shipment_header_id;
7959: EXCEPTION
7960: WHEN OTHERS THEN
7961: l_asn_line_flag := 'N';

Line 10543: , rcv_shipment_headers rsh

10539: , l_po_header_id
10540: , l_req_line_id
10541: , l_oe_order_header_id
10542: FROM rcv_transactions rt
10543: , rcv_shipment_headers rsh
10544: WHERE rt.transaction_id = p_txn_source_id
10545: AND rt.shipment_header_id = rsh.shipment_header_id
10546: AND rt.organization_id = p_to_org_id
10547: AND exists (SELECT '1' FROM rcv_shipment_lines rsl

Line 10575: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn

10571: Decode(rsh.receipt_source_code,'INTERNAL
10572: ORDER','REQ','INVENTORY','INVENTORY','VENDOR','PO','CUSTOMER','RMA')
10573: INTO l_receipt_source_code
10574: , l_source_document_code
10575: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn
10576: WHERE RSH.SHIPMENT_HEADER_ID = WLPN.SOURCE_HEADER_ID
10577: AND WLPN.SOURCE_HEADER_ID IS NOT NULL
10578: AND wlpn.lpn_id = p_lpn_id
10579: AND exists (SELECT '1' FROM rcv_shipment_lines rsl

Line 10590: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn

10586: Decode(rsh.receipt_source_code,'INTERNAL
10587: ORDER','REQ','INVENTORY','INVENTORY','VENDOR','PO','CUSTOMER','RMA')
10588: INTO l_receipt_source_code
10589: , l_source_document_code
10590: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn
10591: WHERE RSH.SHIPMENT_NUM = WLPN.SOURCE_NAME
10592: AND WLPN.SOURCE_NAME IS NOT NULL
10593: AND wlpn.lpn_id = p_lpn_id
10594: AND exists (SELECT '1' FROM rcv_shipment_lines rsl

Line 13704: RCV_SHIPMENT_HEADERS RSH

13700: into l_source_header_id ,
13701: l_asn_type,
13702: l_lpn_context
13703: from WMS_LICENSE_PLATE_NUMBERS WLPN,
13704: RCV_SHIPMENT_HEADERS RSH
13705: where WLPN.lpn_id = l_lpn_rec.lpn_id
13706: AND (
13707: ((rsh.receipt_source_code IN ('INVENTORY','INTERNAL ORDER')
13708: AND rsh.organization_id = wlpn.organization_id) --BUG 4730474

Line 13748: FROM rcv_shipment_headers

13744: IF (l_lpn_rec.shipment_num IS NOT NULL) THEN
13745: BEGIN
13746: SELECT shipment_header_id
13747: INTO l_lpn_rec.shipment_header_id
13748: FROM rcv_shipment_headers
13749: WHERE shipment_num = l_lpn_rec.shipment_num;
13750: EXCEPTION
13751: WHEN OTHERS THEN
13752: NULL;

Line 18221: from rcv_shipment_headers

18217: -- FROM rcv_shipment_lines
18218: -- WHERE shipment_line_id = l_shipment_line_id;
18219: select decode(ASN_TYPE,'ASN','Y','N')
18220: into l_asn_line_flag
18221: from rcv_shipment_headers
18222: WHERE shipment_header_id = l_shipment_header_id;
18223: ELSE
18224: l_asn_line_flag := 'N';
18225: END IF;