263: -- New system parameter is - Transaction Date for Inventory Interface Non Ship Process
264: -- It will have the default value of Ordered Date (derived from order header as above)
265: -- Other possible values are Sysdate, Schedule Ship Date from the Order line
266:
267: SELECT DECODE(OE_SYS_PARAMETERS.value('TRX_DATE_FOR_INV_IFACE'),
268: 'C',SYSDATE,
269: 'S',nvl(l_line_rec.schedule_ship_date,SYSDATE),
270: l_ordered_date)
271: INTO l_trx_date_for_inv_iface