APPS.RCV_RECEIPTS_QUERY_SV dependencies on RCV_SHIPMENT_LINES

Line 218: ** from rcv_shipment_lines. Faking the call to make it look

214: ELSE
215:
216: /*
217: ** If ASN, ASBN then we need to return the available qty
218: ** from rcv_shipment_lines. Faking the call to make it look
219: ** like an internal transfer so the code changes are
220: ** minimal and making use of existing API
221: */
222: /* Bug# 1548597 */

Line 507: FROM rcv_shipment_lines rsl,

503: x_kanban_card_number, --
504: x_project_number, --
505: x_task_number, --
506: l_code_combination_id --
507: FROM rcv_shipment_lines rsl,
508: hr_locations hlo,
509: po_lookup_codes polc,
510: po_requisition_lines PRL, --
511: po_req_distributions PRD, --

Line 674: FROM rcv_shipment_lines

670:
671: BEGIN
672: SELECT routing_header_id
673: INTO x_ms_routing_id
674: FROM rcv_shipment_lines
675: WHERE shipment_line_id = x_shipment_line_id;
676: EXCEPTION
677: WHEN NO_DATA_FOUND THEN NULL;
678: END;

Line 778: * Get locator_id from rcv_shipment_lines for intransit

774: x_deliver_to_locator_id);
775:
776:
777: /* Bug 3537022.
778: * Get locator_id from rcv_shipment_lines for intransit
779: * shipments.
780: */
781: x_progress := 80;
782:

Line 786: from rcv_shipment_lines

782:
783: if (x_receipt_source_code = 'INVENTORY') then
784: select locator_id
785: into x_deliver_to_locator_id
786: from rcv_shipment_lines
787: where shipment_line_id = x_shipment_line_id;
788: end if;
789:
790: x_progress := 90;