DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on RCV_SHIPMENT_HEADERS

Line 153: rcv_shipment_headers rsh,

149: -- MOAC changed po_requisition_headers and po_requisition_lines to _ALL tables
150: FROM po_requisition_headers_all prh,
151: po_requisition_lines_all prl,
152: rcv_shipment_lines rsl,
153: rcv_shipment_headers rsh,
154: wms_waveplan_tasks_temp wwtt
155: WHERE rsl.shipment_line_id = wwtt.reference_id
156: AND prh.requisition_header_id(+) = prl.requisition_header_id
157: AND rsl.requisition_line_id = prl.requisition_line_id(+)

Line 3056: || ', rcv_shipment_headers rsh'

3052: || ', oe_order_lines_all ool';
3053: ELSIF wms_plan_tasks_pvt.g_from_requisition_header_id IS NOT NULL
3054: OR wms_plan_tasks_pvt.g_to_requisition_header_id IS NOT NULL THEN
3055: l_inbound_from := l_inbound_from
3056: || ', rcv_shipment_headers rsh'
3057: || ', rcv_shipment_lines rsl'
3058: -- MOAC changed po_requisition_headers and po_requisition_lines to _ALL tables
3059: || ', po_requisition_headers_all prh'
3060: || ', po_requisition_lines_all prl';

Line 3064: || ', rcv_shipment_headers rsh'

3060: || ', po_requisition_lines_all prl';
3061: ELSIF wms_plan_tasks_pvt.g_from_shipment_number IS NOT NULL
3062: OR wms_plan_tasks_pvt.g_to_shipment_number IS NOT NULL THEN
3063: l_inbound_from := l_inbound_from
3064: || ', rcv_shipment_headers rsh'
3065: || ', rcv_shipment_lines rsl';
3066: END IF;
3067:
3068: IF p_is_completed_rec = 0 THEN --not completed