DBA Data[Home] [Help]

APPS.OE_INV_IFACE_PVT dependencies on OE_SYS_PARAMETERS

Line 254: SELECT DECODE(OE_SYS_PARAMETERS.value('TRX_DATE_FOR_INV_IFACE'),

250: -- New system parameter is - Transaction Date for Inventory Interface Non Ship Process
251: -- It will have the default value of Ordered Date (derived from order header as above)
252: -- Other possible values are Sysdate, Schedule Ship Date from the Order line
253:
254: SELECT DECODE(OE_SYS_PARAMETERS.value('TRX_DATE_FOR_INV_IFACE'),
255: 'C',SYSDATE,
256: 'S',nvl(l_line_rec.schedule_ship_date,SYSDATE),
257: l_ordered_date)
258: INTO l_trx_date_for_inv_iface