DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on RCV_SHIPMENT_LINES

Line 128: rcv_shipment_lines rsl,

124: bulk collect INTO l_source_header, l_line_number, l_temp_id, l_task_type_id
125: -- MOAC changed po_requisition_headers and po_requisition_lines to _ALL tables
126: FROM po_requisition_headers_all prh,
127: po_requisition_lines_all prl,
128: rcv_shipment_lines rsl,
129: rcv_shipment_headers rsh,
130: wms_waveplan_tasks_temp wwtt
131: WHERE rsl.shipment_line_id = wwtt.reference_id
132: AND prh.requisition_header_id(+) = prl.requisition_header_id

Line 2976: || ', rcv_shipment_lines rsl'

2972: ELSIF wms_plan_tasks_pvt.g_from_requisition_header_id IS NOT NULL
2973: OR wms_plan_tasks_pvt.g_to_requisition_header_id IS NOT NULL THEN
2974: l_inbound_from := l_inbound_from
2975: || ', rcv_shipment_headers rsh'
2976: || ', rcv_shipment_lines rsl'
2977: -- MOAC changed po_requisition_headers and po_requisition_lines to _ALL tables
2978: || ', po_requisition_headers_all prh'
2979: || ', po_requisition_lines_all prl';
2980: ELSIF wms_plan_tasks_pvt.g_from_shipment_number IS NOT NULL

Line 2984: || ', rcv_shipment_lines rsl';

2980: ELSIF wms_plan_tasks_pvt.g_from_shipment_number IS NOT NULL
2981: OR wms_plan_tasks_pvt.g_to_shipment_number IS NOT NULL THEN
2982: l_inbound_from := l_inbound_from
2983: || ', rcv_shipment_headers rsh'
2984: || ', rcv_shipment_lines rsl';
2985: END IF;
2986:
2987: IF p_is_completed_rec = 0 THEN --not completed
2988: l_inbound_from := l_inbound_from