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 1213: 'RCV_SHIPMENT_LINES',

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

Line 1623: FROM rcv_shipment_lines

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

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

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

Line 1636: FROM rcv_shipment_lines

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

Line 1639: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id

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