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 528: FROM rcv_shipment_lines rsl,

524: x_kanban_card_number, --
525: x_project_number, --
526: x_task_number, --
527: l_code_combination_id --
528: FROM rcv_shipment_lines rsl,
529: hr_locations hlo,
530: po_lookup_codes polc,
531: po_requisition_lines PRL, --
532: po_req_distributions PRD, --

Line 695: FROM rcv_shipment_lines

691:
692: BEGIN
693: SELECT routing_header_id
694: INTO x_ms_routing_id
695: FROM rcv_shipment_lines
696: WHERE shipment_line_id = x_shipment_line_id;
697: EXCEPTION
698: WHEN NO_DATA_FOUND THEN NULL;
699: END;

Line 780: * Get locator_id from rcv_shipment_lines for intransit

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

Line 788: from rcv_shipment_lines

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