APPS.RCV_ROI_HEADER dependencies on RCV_SHIPMENT_LINES

Line 1499: FROM rcv_shipment_lines

1495: AND p_header_record.header_record.asn_type IN('ASN', 'ASBN') THEN
1496: IF p_header_record.header_record.receipt_header_id IS NOT NULL THEN
1497: SELECT SUM(quantity_received)
1498: INTO x_count
1499: FROM rcv_shipment_lines
1500: WHERE rcv_shipment_lines.shipment_header_id = p_header_record.header_record.receipt_header_id;
1501: ELSE
1502: /*
1503: * BUGNO: 1708017

Line 1500: WHERE rcv_shipment_lines.shipment_header_id = p_header_record.header_record.receipt_header_id;

1496: IF p_header_record.header_record.receipt_header_id IS NOT NULL THEN
1497: SELECT SUM(quantity_received)
1498: INTO x_count
1499: FROM rcv_shipment_lines
1500: WHERE rcv_shipment_lines.shipment_header_id = p_header_record.header_record.receipt_header_id;
1501: ELSE
1502: /*
1503: * BUGNO: 1708017
1504: * The where clause used to have organization_id =

Line 1512: FROM rcv_shipment_lines

1508: * be from organization_id. So changed it to ship_to_org_id.
1509: */
1510: SELECT SUM(quantity_received)
1511: INTO x_count
1512: FROM rcv_shipment_lines
1513: WHERE EXISTS(SELECT 'x'
1514: FROM rcv_shipment_headers
1515: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id
1516: AND NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)

Line 1515: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id

1511: INTO x_count
1512: FROM rcv_shipment_lines
1513: WHERE EXISTS(SELECT 'x'
1514: FROM rcv_shipment_headers
1515: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id
1516: AND NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1517: AND vendor_id = p_header_record.header_record.vendor_id
1518: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
1519: AND shipment_num = p_header_record.header_record.shipment_num

Line 1867: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface

1863:
1864: DELETE FROM rcv_transactions_interface
1865: WHERE header_interface_id = p_header_record.header_record.header_interface_id;
1866:
1867: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface
1868:
1869: -- Make sure we don't inset cancelled lines and lines that are waiting to
1870: -- be cancelled in rti
1871: -- The transaction processor will then cancel the lines

Line 1950: FROM rcv_shipment_lines rsl,

1946: rsl.shipment_line_id,
1947: rsl.destination_type_code,
1948: p_header_record.header_record.processing_request_id,
1949: poh.org_id
1950: FROM rcv_shipment_lines rsl,
1951: po_headers_all poh
1952: WHERE rsl.shipment_header_id = p_header_record.header_record.receipt_header_id
1953: AND rsl.shipment_line_status_code <> 'CANCELLED'
1954: AND rsl.po_header_id = poh.po_header_id