DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on RCV_SHIPMENT_LINES

Line 152: rcv_shipment_lines rsl,

148: bulk collect INTO l_source_header, l_line_number, l_temp_id, l_task_type_id
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

Line 3057: || ', rcv_shipment_lines rsl'

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';
3061: ELSIF wms_plan_tasks_pvt.g_from_shipment_number IS NOT NULL

Line 3065: || ', rcv_shipment_lines rsl';

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
3069: l_inbound_from := l_inbound_from