APPS.RCV_CORE_S dependencies on RCV_SHIPMENT_LINES

Line 91: FROM rcv_shipment_lines

87: dest_subinv,
88: dest_org_id,
89: dest_type_code,
90: x_ship_head_id
91: FROM rcv_shipment_lines
92: WHERE shipment_line_id = x_ship_line_id;
93:
94: x_progress := '040';
95:

Line 1215: 'RCV_SHIPMENT_LINES',

1211: END IF;
1212:
1213: x_progress := 20;
1214: x_ret_note_cnt := note_info('RVCRC',
1215: 'RCV_SHIPMENT_LINES',
1216: 'SHIPMENT_LINE_ID',
1217: x_line_id
1218: );
1219:

Line 1625: FROM rcv_shipment_lines

1621: AND x_header_record.header_record.asn_type IN('ASN', 'ASBN') THEN
1622: IF x_header_record.header_record.receipt_header_id IS NOT NULL THEN
1623: SELECT SUM(quantity_received)
1624: INTO x_count
1625: FROM rcv_shipment_lines
1626: WHERE rcv_shipment_lines.shipment_header_id = x_header_record.header_record.receipt_header_id;
1627: ELSE
1628: /*
1629: * BUGNO: 1708017

Line 1626: WHERE rcv_shipment_lines.shipment_header_id = x_header_record.header_record.receipt_header_id;

1622: IF x_header_record.header_record.receipt_header_id IS NOT NULL THEN
1623: SELECT SUM(quantity_received)
1624: INTO x_count
1625: FROM rcv_shipment_lines
1626: WHERE rcv_shipment_lines.shipment_header_id = x_header_record.header_record.receipt_header_id;
1627: ELSE
1628: /*
1629: * BUGNO: 1708017
1630: * The where clause used to have organization_id =

Line 1638: FROM rcv_shipment_lines

1634: * be from organization_id. So changed it to ship_to_org_id.
1635: */
1636: SELECT SUM(quantity_received)
1637: INTO x_count
1638: FROM rcv_shipment_lines
1639: WHERE EXISTS(SELECT 'x'
1640: FROM rcv_shipment_headers
1641: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id
1642: AND NVL(vendor_site_id, -9999) = NVL(x_header_record.header_record.vendor_site_id, -9999)

Line 1641: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id

1637: INTO x_count
1638: FROM rcv_shipment_lines
1639: WHERE EXISTS(SELECT 'x'
1640: FROM rcv_shipment_headers
1641: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id
1642: AND NVL(vendor_site_id, -9999) = NVL(x_header_record.header_record.vendor_site_id, -9999)
1643: AND vendor_id = x_header_record.header_record.vendor_id
1644: AND ship_to_org_id = x_header_record.header_record.ship_to_organization_id
1645: AND shipment_num = x_header_record.header_record.shipment_num