eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_CRM_UTILITIES_PKG dependencies on GL_ROW_MULTIPLIERS

Line 963: gl_row_multipliers rm,

959: sys_daily_rate_cannot_delete.r_rate,
960: sys_daily_rate_cannot_delete.r_rate_source_code
961: FROM gl_daily_rates dr,
962: gl_daily_conversion_types gldct,
963: gl_row_multipliers rm,
964: gl_daily_conversion_types ct,
965: gl_daily_rates_interface ri
966: WHERE ri.mode_flag = 'D'
967: AND ct.user_conversion_type = ri.user_conversion_type || ''

Line 1046: gl_row_multipliers rm,

1042: sys_daily_rate_cannot_override.r_rate,
1043: sys_daily_rate_cannot_override.r_rate_source_code
1044: FROM gl_daily_rates dr,
1045: gl_daily_conversion_types gldct,
1046: gl_row_multipliers rm,
1047: gl_daily_conversion_types ct,
1048: gl_daily_rates_interface ri
1049: WHERE ct.user_conversion_type = ri.user_conversion_type || ''
1050: AND rm.multiplier BETWEEN 1 AND (TRUNC(ri.to_conversion_date)

Line 1165: FROM gl_row_multipliers rm,

1161: SELECT ri.from_currency, ri.to_currency, --direct rate
1162: ct.conversion_type,
1163: TRUNC(ri.from_conversion_date) + rm.multiplier
1164: - 1
1165: FROM gl_row_multipliers rm,
1166: gl_daily_conversion_types ct,
1167: gl_daily_rates_interface ri
1168: WHERE ri.mode_flag = 'D'
1169: AND ri.batch_number = l_batch_number

Line 1184: FROM gl_row_multipliers rm,

1180: SELECT ri.to_currency, ri.from_currency, --inverse rate
1181: ct.conversion_type,
1182: TRUNC(ri.from_conversion_date) + rm.multiplier
1183: - 1
1184: FROM gl_row_multipliers rm,
1185: gl_daily_conversion_types ct,
1186: gl_daily_rates_interface ri
1187: WHERE ri.mode_flag = 'D'
1188: AND ri.batch_number = l_batch_number

Line 1222: FROM gl_row_multipliers rm,

1218: SELECT ri.from_currency, ri.to_currency, --direct rates
1219: ct.conversion_type,
1220: TRUNC(ri.from_conversion_date)
1221: + rm.multiplier - 1
1222: FROM gl_row_multipliers rm,
1223: gl_daily_conversion_types ct,
1224: gl_daily_rates_interface ri
1225: WHERE ri.batch_number = l_batch_number
1226: AND ( ri.mode_flag IN('I', 'T')

Line 1242: FROM gl_row_multipliers rm,

1238: SELECT ri.to_currency, ri.from_currency, --inverse rates
1239: ct.conversion_type,
1240: TRUNC(ri.from_conversion_date)
1241: + rm.multiplier - 1
1242: FROM gl_row_multipliers rm,
1243: gl_daily_conversion_types ct,
1244: gl_daily_rates_interface ri
1245: WHERE ri.batch_number = l_batch_number
1246: AND ( ri.mode_flag IN('I', 'T')

Line 1292: FROM gl_row_multipliers rm,

1288: ri.attribute8, ri.attribute9, ri.attribute10,
1289: ri.attribute11, ri.attribute12, ri.attribute13,
1290: ri.attribute14, ri.attribute15,
1291: DECODE(ri.mode_flag, 'T', 'TREASURY', 'N', 'TREASURY', 'USER')
1292: FROM gl_row_multipliers rm,
1293: gl_daily_conversion_types ct,
1294: gl_daily_rates_interface ri
1295: WHERE ri.mode_flag IN('I', 'T', 'N')
1296: AND ct.user_conversion_type = ri.user_conversion_type || ''

Line 1325: FROM gl_row_multipliers rm,

1321: ri.attribute8, ri.attribute9, ri.attribute10,
1322: ri.attribute11, ri.attribute12, ri.attribute13,
1323: ri.attribute14, ri.attribute15,
1324: DECODE(ri.mode_flag, 'T', 'TREASURY', 'N', 'TREASURY', 'USER')
1325: FROM gl_row_multipliers rm,
1326: gl_daily_conversion_types ct,
1327: gl_daily_rates_interface ri
1328: WHERE ri.mode_flag IN('I', 'T', 'N')
1329: AND ct.user_conversion_type = ri.user_conversion_type || ''

Line 1573: gl_row_multipliers glrm

1569: usr_daily_rate_cannot_delete.r_rate_source_code
1570: FROM gl_daily_rates gldr,
1571: gl_daily_conversion_types gldct,
1572: gl_cross_rate_temp glcrt,
1573: gl_row_multipliers glrm
1574: WHERE gldr.conversion_type = gldct.conversion_type
1575: AND ( (gldr.rate_source_code IS NULL)
1576: OR ( (gldr.rate_source_code IS NOT NULL)
1577: AND (gldr.rate_source_code IN

Line 1646: gl_row_multipliers glrm

1642: usr_daily_rate_cannot_override.r_rate_source_code
1643: FROM gl_daily_rates gldr,
1644: gl_daily_conversion_types gldct,
1645: gl_cross_rate_temp glcrt,
1646: gl_row_multipliers glrm
1647: WHERE gldr.conversion_type = gldct.conversion_type
1648: AND ( (gldr.rate_source_code IS NULL)
1649: OR ( (gldr.rate_source_code IS NOT NULL)
1650: AND (gldr.rate_source_code IN

Line 1731: FROM gl_row_multipliers glrm,

1727: SELECT glcrt.from_currency, glcrt.to_currency, --direct rates
1728: glcrt.conversion_type,
1729: TRUNC(glcrt.from_conversion_date)
1730: + glrm.multiplier - 1
1731: FROM gl_row_multipliers glrm,
1732: gl_cross_rate_temp glcrt,
1733: gl_daily_rates gldr
1734: WHERE glcrt.mode_flag = 'D'
1735: AND glcrt.used_for_ab_translation = 'Y'

Line 1753: FROM gl_row_multipliers glrm,

1749: SELECT glcrt.to_currency, glcrt.from_currency, -- inverse rates
1750: glcrt.conversion_type,
1751: TRUNC(glcrt.from_conversion_date)
1752: + glrm.multiplier - 1
1753: FROM gl_row_multipliers glrm,
1754: gl_cross_rate_temp glcrt,
1755: gl_daily_rates gldr
1756: WHERE glcrt.mode_flag = 'D'
1757: AND glcrt.used_for_ab_translation = 'Y'

Line 1793: FROM gl_row_multipliers glrm,

1789: SELECT glcrt.from_currency, glcrt.to_currency,
1790: glcrt.conversion_type,
1791: TRUNC(glcrt.from_conversion_date)
1792: + glrm.multiplier - 1
1793: FROM gl_row_multipliers glrm,
1794: gl_cross_rate_temp glcrt,
1795: gl_daily_rates gldr
1796: WHERE ( glcrt.mode_flag in ('I', 'T')
1797: OR ( glcrt.mode_flag = 'D'

Line 1818: FROM gl_row_multipliers glrm,

1814: SELECT glcrt.to_currency, glcrt.from_currency,
1815: glcrt.conversion_type,
1816: TRUNC(glcrt.from_conversion_date)
1817: + glrm.multiplier - 1
1818: FROM gl_row_multipliers glrm,
1819: gl_cross_rate_temp glcrt,
1820: gl_daily_rates gldr
1821: WHERE ( glcrt.mode_flag in ('I', 'T')
1822: OR ( glcrt.mode_flag = 'D'

Line 1880: FROM gl_row_multipliers glrm,

1876: glcrt.conversion_type,
1877: glcrt.inverse_conversion_rate * gldr.conversion_rate,
1878: DECODE(glcrt.used_for_ab_translation, 'Y', 'O', 'C'),
1879: SYSDATE, 1, SYSDATE, 1, 1, 'SYSTEM'
1880: FROM gl_row_multipliers glrm,
1881: gl_cross_rate_temp glcrt,
1882: gl_daily_rates gldr
1883: WHERE glcrt.mode_flag in ('I', 'T', 'N')
1884: AND gldr.from_currency = glcrt.pivot_currency

Line 1924: FROM gl_row_multipliers glrm,

1920: glcrt.conversion_type,
1921: glcrt.conversion_rate * gldr.conversion_rate,
1922: DECODE(glcrt.used_for_ab_translation, 'Y', 'O', 'C'),
1923: SYSDATE, 1, SYSDATE, 1, 1, 'SYSTEM'
1924: FROM gl_row_multipliers glrm,
1925: gl_cross_rate_temp glcrt,
1926: gl_daily_rates gldr
1927: WHERE glcrt.mode_flag in ('I', 'T', 'N')
1928: AND gldr.to_currency = glcrt.pivot_currency