APPS.RCV_ROI_HEADER dependencies on RCV_SHIPMENT_LINES

Line 1525: FROM rcv_shipment_lines

1521: AND p_header_record.header_record.asn_type IN('ASN', 'ASBN') THEN
1522: IF p_header_record.header_record.receipt_header_id IS NOT NULL THEN
1523: SELECT SUM(quantity_received)
1524: INTO x_count
1525: FROM rcv_shipment_lines
1526: WHERE rcv_shipment_lines.shipment_header_id = p_header_record.header_record.receipt_header_id;
1527: ELSE
1528: /*
1529: * BUGNO: 1708017

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

1522: IF p_header_record.header_record.receipt_header_id IS NOT NULL THEN
1523: SELECT SUM(quantity_received)
1524: INTO x_count
1525: FROM rcv_shipment_lines
1526: WHERE rcv_shipment_lines.shipment_header_id = p_header_record.header_record.receipt_header_id;
1527: ELSE
1528: /*
1529: * BUGNO: 1708017
1530: * The where clause used to have organization_id =

Line 1538: FROM rcv_shipment_lines

1534: * be from organization_id. So changed it to ship_to_org_id.
1535: */
1536: SELECT SUM(quantity_received)
1537: INTO x_count
1538: FROM rcv_shipment_lines
1539: WHERE EXISTS(SELECT 'x'
1540: FROM rcv_shipment_headers
1541: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id
1542: AND NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)

Line 1541: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id

1537: INTO x_count
1538: FROM rcv_shipment_lines
1539: WHERE EXISTS(SELECT 'x'
1540: FROM rcv_shipment_headers
1541: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id
1542: AND NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1543: AND vendor_id = p_header_record.header_record.vendor_id
1544: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
1545: AND shipment_num = p_header_record.header_record.shipment_num

Line 1893: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface

1889:
1890: DELETE FROM rcv_transactions_interface
1891: WHERE header_interface_id = p_header_record.header_record.header_interface_id;
1892:
1893: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface
1894:
1895: -- Make sure we don't inset cancelled lines and lines that are waiting to
1896: -- be cancelled in rti
1897: -- The transaction processor will then cancel the lines

Line 1976: FROM rcv_shipment_lines rsl,

1972: rsl.shipment_line_id,
1973: rsl.destination_type_code,
1974: p_header_record.header_record.processing_request_id,
1975: poh.org_id
1976: FROM rcv_shipment_lines rsl,
1977: po_headers_all poh
1978: WHERE rsl.shipment_header_id = p_header_record.header_record.receipt_header_id
1979: AND rsl.shipment_line_status_code <> 'CANCELLED'
1980: AND rsl.po_header_id = poh.po_header_id