DBA Data[Home] [Help]

APPS.MRP_RESCHEDULE_PO dependencies on PO_LINE_LOCATIONS_ALL

Line 283: from po_line_locations_all poll

279: p_show_msg varchar2(3) := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');
280:
281: cursor po_cur(v_line_id number, v_header_id number, v_ship_num number) is
282: select nvl(poll.promised_date,poll.need_by_date),1
283: from po_line_locations_all poll
284: where poll.po_line_id = v_line_id
285: and poll.po_header_id = v_header_id
286: and poll.shipment_num = nvl(v_ship_num,poll.shipment_num);
287: v_old_need_by_dates po_tbl_date := po_tbl_date();