APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on RCV_SHIPMENT_LINES

Line 446: rcv_shipment_lines rsl,

442: -- MOAC po_requisition_headers and
443: -- po_requisition_lines switched to use _ALL tables
444: FROM po_requisition_headers_all prh,
445: po_requisition_lines_all prl,
446: rcv_shipment_lines rsl,
447: rcv_shipment_headers rsh,
448: wms_waveplan_tasks_temp wwtt
449: WHERE rsl.shipment_line_id = wwtt.reference_id
450: AND prh.requisition_header_id(+) = prl.requisition_header_id

Line 5233: l_from_generic := l_from_generic || ', rcv_shipment_lines rsl';

5229: ELSIF p_from_requisition_header_id IS NOT NULL
5230: OR p_to_requisition_header_id IS NOT NULL
5231: THEN
5232: l_from_generic := l_from_generic || ', rcv_shipment_headers rsh';
5233: l_from_generic := l_from_generic || ', rcv_shipment_lines rsl';
5234: l_from_generic :=
5235: l_from_generic || ', po_requisition_headers_all prh';
5236: l_from_generic := l_from_generic || ', po_requisition_lines_all prl';
5237: ELSIF p_from_shipment_number IS NOT NULL

Line 5241: l_from_generic := l_from_generic || ', rcv_shipment_lines rsl';

5237: ELSIF p_from_shipment_number IS NOT NULL
5238: OR p_to_shipment_number IS NOT NULL
5239: THEN
5240: l_from_generic := l_from_generic || ', rcv_shipment_headers rsh';
5241: l_from_generic := l_from_generic || ', rcv_shipment_lines rsl';
5242: END IF;
5243:
5244: IF i = 1
5245: THEN