APPS.PO_RESCHEDULE_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 294: DATE1: db dates in po_line_locations_all

290: po_session_gt map:
291: KEY : unique key for the current session processing
292: NUM1 : line_location_id
293: NUM2 : shipment_num
294: DATE1: db dates in po_line_locations_all
295: DATE2: new need by dates passed in
296: CHAR1: old need by dates passed in ,
297: using the char field since session_gt has only 2 date columns
298: CHAR2: indicates a valid record

Line 319: from po_line_locations_all pll

315: Nvl(pll.promised_date,pll.need_by_date),
316: X_need_by_dates(i),
317: To_Char(X_need_by_dates_old(i),'DD-MON-YYYY:hh:mi:ss'),
318: 'Y'
319: from po_line_locations_all pll
320: where pll.po_line_id = X_po_line_ids(i)
321: and pll.po_header_id = X_po_header_id
322: and (l_po_release_id is NULL OR
323: pll.po_release_id = l_po_release_id);

Line 333: DATE1: db dates in po_line_locations_all

329: po_session_gt map:
330: KEY : unique key for the current session processing
331: NUM1 : line_location_id
332: NUM2 : shipment_num
333: DATE1: db dates in po_line_locations_all
334: DATE2: new need by dates passed in
335: CHAR1: old need by dates passed in ,
336: using the char field since session_gt has only 2 date columns
337: CHAR2: indicates a valid record

Line 358: from po_line_locations_all pll

354: Nvl(pll.promised_date,pll.need_by_date),
355: X_need_by_dates(i),
356: To_Char(X_need_by_dates_old(i),'DD-MON-YYYY:hh:mi:ss'),
357: 'Y'
358: from po_line_locations_all pll
359: where pll.po_line_id = X_po_line_ids(i)
360: and pll.shipment_num = Nvl(X_shipment_nums(i), pll.shipment_num)
361: and pll.po_header_id = X_po_header_id
362: and (l_po_release_id is NULL OR