DBA Data[Home] [Help]

APPS.ISC_EDW_BOOKINGS_F_C dependencies on EDW_CURRENCY

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

517: '' FROM_UOM_CODE,
518: '' TO_UOM_CODE,
519: '' INVENTORY_ITEM_ID,
520: '' ITEM_NAME,
521: decode( EDW_CURRENCY.Get_Rate (gl.currency_code,h.booked_date),
522: -1,
523: 'RATE NOT AVAILABLE',
524: -2,
525: 'INVALID CURRENCY') STATUS

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

535: AND l.header_id = h.header_id
536: AND fspa.set_of_books_id = gl.set_of_books_id
537: AND h.booked_flag = 'Y'
538: AND h.booked_date IS NOT NULL
539: AND EDW_CURRENCY.Get_Rate (gl.currency_code,h.booked_date) < 0
540: UNION
541: SELECT -- Reports Base to Transaction Conversion Currency Issue
542: g_seq_id_line_1 ID,
543: ftp.pk1 PK1,