DBA Data[Home] [Help]

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 6020: l_from_generic := l_from_generic || ', rcv_shipment_headers rsh';

6016: l_from_generic := l_from_generic || ', oe_order_lines_all ool';
6017: ELSIF p_from_requisition_header_id IS NOT NULL
6018: OR p_to_requisition_header_id IS NOT NULL
6019: THEN
6020: l_from_generic := l_from_generic || ', rcv_shipment_headers rsh';
6021: l_from_generic := l_from_generic || ', rcv_shipment_lines rsl';
6022: l_from_generic :=
6023: l_from_generic || ', po_requisition_headers_all prh';
6024: l_from_generic := l_from_generic || ', po_requisition_lines_all prl';

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

6024: l_from_generic := l_from_generic || ', po_requisition_lines_all prl';
6025: ELSIF p_from_shipment_number IS NOT NULL
6026: OR p_to_shipment_number IS NOT NULL
6027: THEN
6028: l_from_generic := l_from_generic || ', rcv_shipment_headers rsh';
6029: l_from_generic := l_from_generic || ', rcv_shipment_lines rsl';
6030: END IF;
6031:
6032: IF i = 1