DBA Data[Home] [Help]

APPS.MRP_RESCHEDULE_PO dependencies on PO_LINE_LOCATIONS_ALL

Line 367: from po_line_locations_all poll

363: p_show_msg varchar2(3) := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');
364:
365: cursor po_cur(v_line_id number, v_header_id number, v_ship_num number) is
366: select nvl(poll.promised_date,poll.need_by_date),1
367: from po_line_locations_all poll
368: where poll.po_line_id = v_line_id
369: and poll.po_header_id = v_header_id
370: and poll.shipment_num = nvl(v_ship_num,poll.shipment_num);
371: v_old_need_by_dates po_tbl_date := po_tbl_date();