DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on RCV_SHIPMENT_HEADERS

Line 129: rcv_shipment_headers rsh,

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
133: AND rsl.requisition_line_id = prl.requisition_line_id(+)

Line 2975: || ', rcv_shipment_headers rsh'

2971: || ', oe_order_lines_all ool';
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';

Line 2983: || ', rcv_shipment_headers rsh'

2979: || ', po_requisition_lines_all prl';
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