440: l_line_number,
441: l_temp_id, l_task_type_id
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
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
5238: OR p_to_shipment_number IS NOT NULL
5239: THEN