DBA Data[Home] [Help]

APPS.RCV_ROI_HEADER_COMMON dependencies on RCV_SHIPMENT_LINES

Line 329: FROM rcv_shipment_lines rsl

325:
326: IF (x_shipment_header_id IS NOT NULL) THEN
327: SELECT MAX(rsl.to_organization_id)
328: INTO x_to_organization_id /* Bug#3909973 - (2) */
329: FROM rcv_shipment_lines rsl
330: WHERE rsl.shipment_header_id = x_shipment_header_id
331: AND (x_document_num is null or x_document_num = rsl.line_num);
332: END IF;
333: END IF;

Line 890: FROM rcv_shipment_lines

886: 0, 'Y',
887: 'N'
888: )
889: INTO x_new_receipt
890: FROM rcv_shipment_lines
891: WHERE quantity_received > 0
892: AND shipment_header_id IN
893: (SELECT shipment_header_id
894: FROM rcv_shipment_headers