APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on RCV_SHIPMENT_HEADERS

Line 447: rcv_shipment_headers rsh,

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
451: AND rsl.requisition_line_id = prl.requisition_line_id(+)

Line 5232: l_from_generic := l_from_generic || ', rcv_shipment_headers rsh';

5228: l_from_generic := l_from_generic || ', oe_order_lines_all ool';
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';

Line 5240: l_from_generic := l_from_generic || ', rcv_shipment_headers rsh';

5236: l_from_generic := l_from_generic || ', po_requisition_lines_all prl';
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