DBA Data[Home] [Help]

APPS.ISC_EDW_BACKLOGS_F_C dependencies on EDW_CURRENCY

Line 371: decode( EDW_CURRENCY.Get_Rate (gl.currency_code,h.booked_date),

367: '' FROM_UOM_CODE,
368: '' TO_UOM_CODE,
369: '' INVENTORY_ITEM_ID,
370: '' ITEM_NAME,
371: decode( EDW_CURRENCY.Get_Rate (gl.currency_code,h.booked_date),
372: -1,'RATE NOT AVAILABLE',
373: -2,'INVALID CURRENCY') STATUS
374: FROM EDW_LOCAL_INSTANCE inst,
375: EDW_LOCAL_SYSTEM_PARAMETERS edw_param,

Line 388: AND EDW_CURRENCY.Get_Rate (gl.currency_code,h.booked_date) < 0

384: AND l.header_id = h.header_id
385: AND fspa.set_of_books_id = gl.set_of_books_id
386: AND h.booked_flag = 'Y'
387: AND h.booked_date IS NOT NULL
388: AND EDW_CURRENCY.Get_Rate (gl.currency_code,h.booked_date) < 0
389: UNION
390: SELECT /* Reports Base to Transaction Conversion Currency Issue */
391: g_seq_id_line ID,
392: ftp.pk1 PK1,