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.

[Home] [Help]

APPS.GL_CRM_UTILITIES_PKG dependencies on GL_ROW_MULTIPLIERS

Line 785: gl_row_multipliers rm,

781: sys_daily_rate_cannot_delete.r_rate,
782: sys_daily_rate_cannot_delete.r_rate_source_code
783: FROM gl_daily_rates dr,
784: gl_daily_conversion_types gldct,
785: gl_row_multipliers rm,
786: gl_daily_conversion_types ct,
787: gl_daily_rates_interface ri
788: WHERE ri.mode_flag = 'D'
789: AND ct.user_conversion_type = ri.user_conversion_type || ''

Line 867: gl_row_multipliers rm,

863: sys_daily_rate_cannot_override.r_rate,
864: sys_daily_rate_cannot_override.r_rate_source_code
865: FROM gl_daily_rates dr,
866: gl_daily_conversion_types gldct,
867: gl_row_multipliers rm,
868: gl_daily_conversion_types ct,
869: gl_daily_rates_interface ri
870: WHERE ct.user_conversion_type = ri.user_conversion_type || ''
871: AND rm.multiplier BETWEEN 1 AND (TRUNC(ri.to_conversion_date)

Line 984: FROM gl_row_multipliers rm,

980: SELECT ri.from_currency, ri.to_currency, --direct rate
981: ct.conversion_type,
982: TRUNC(ri.from_conversion_date) + rm.multiplier
983: - 1
984: FROM gl_row_multipliers rm,
985: gl_daily_conversion_types ct,
986: gl_daily_rates_interface ri
987: WHERE ri.mode_flag = 'D'
988: AND ri.used_for_ab_translation = 'Y'

Line 1002: FROM gl_row_multipliers rm,

998: SELECT ri.to_currency, ri.from_currency, --inverse rate
999: ct.conversion_type,
1000: TRUNC(ri.from_conversion_date) + rm.multiplier
1001: - 1
1002: FROM gl_row_multipliers rm,
1003: gl_daily_conversion_types ct,
1004: gl_daily_rates_interface ri
1005: WHERE ri.mode_flag = 'D'
1006: AND ri.used_for_ab_translation = 'Y'

Line 1039: FROM gl_row_multipliers rm,

1035: SELECT ri.from_currency, ri.to_currency, --direct rates
1036: ct.conversion_type,
1037: TRUNC(ri.from_conversion_date)
1038: + rm.multiplier - 1
1039: FROM gl_row_multipliers rm,
1040: gl_daily_conversion_types ct,
1041: gl_daily_rates_interface ri
1042: WHERE ( ri.mode_flag IN('I', 'T')
1043: OR ( ri.mode_flag = 'D'

Line 1058: FROM gl_row_multipliers rm,

1054: SELECT ri.to_currency, ri.from_currency, --inverse rates
1055: ct.conversion_type,
1056: TRUNC(ri.from_conversion_date)
1057: + rm.multiplier - 1
1058: FROM gl_row_multipliers rm,
1059: gl_daily_conversion_types ct,
1060: gl_daily_rates_interface ri
1061: WHERE ( ri.mode_flag IN('I', 'T')
1062: OR ( ri.mode_flag = 'D'

Line 1107: FROM gl_row_multipliers rm,

1103: ri.attribute8, ri.attribute9, ri.attribute10,
1104: ri.attribute11, ri.attribute12, ri.attribute13,
1105: ri.attribute14, ri.attribute15,
1106: DECODE(ri.mode_flag, 'T', 'TREASURY', 'N', 'TREASURY', 'USER')
1107: FROM gl_row_multipliers rm,
1108: gl_daily_conversion_types ct,
1109: gl_daily_rates_interface ri
1110: WHERE ri.mode_flag IN('I', 'T', 'N')
1111: AND ct.user_conversion_type = ri.user_conversion_type || ''

Line 1139: FROM gl_row_multipliers rm,

1135: ri.attribute8, ri.attribute9, ri.attribute10,
1136: ri.attribute11, ri.attribute12, ri.attribute13,
1137: ri.attribute14, ri.attribute15,
1138: DECODE(ri.mode_flag, 'T', 'TREASURY', 'N', 'TREASURY', 'USER')
1139: FROM gl_row_multipliers rm,
1140: gl_daily_conversion_types ct,
1141: gl_daily_rates_interface ri
1142: WHERE ri.mode_flag IN('I', 'T', 'N')
1143: AND ct.user_conversion_type = ri.user_conversion_type || ''

Line 1364: gl_row_multipliers glrm

1360: usr_daily_rate_cannot_delete.r_rate_source_code
1361: FROM gl_daily_rates gldr,
1362: gl_daily_conversion_types gldct,
1363: gl_cross_rate_temp glcrt,
1364: gl_row_multipliers glrm
1365: WHERE gldr.conversion_type = gldct.conversion_type
1366: AND ( (gldr.rate_source_code IS NULL)
1367: OR ( (gldr.rate_source_code IS NOT NULL)
1368: AND (gldr.rate_source_code IN

Line 1437: gl_row_multipliers glrm

1433: usr_daily_rate_cannot_override.r_rate_source_code
1434: FROM gl_daily_rates gldr,
1435: gl_daily_conversion_types gldct,
1436: gl_cross_rate_temp glcrt,
1437: gl_row_multipliers glrm
1438: WHERE gldr.conversion_type = gldct.conversion_type
1439: AND ( (gldr.rate_source_code IS NULL)
1440: OR ( (gldr.rate_source_code IS NOT NULL)
1441: AND (gldr.rate_source_code IN

Line 1522: FROM gl_row_multipliers glrm,

1518: SELECT glcrt.from_currency, glcrt.to_currency, --direct rates
1519: glcrt.conversion_type,
1520: TRUNC(glcrt.from_conversion_date)
1521: + glrm.multiplier - 1
1522: FROM gl_row_multipliers glrm,
1523: gl_cross_rate_temp glcrt,
1524: gl_daily_rates gldr
1525: WHERE glcrt.mode_flag = 'D'
1526: AND glcrt.used_for_ab_translation = 'Y'

Line 1544: FROM gl_row_multipliers glrm,

1540: SELECT glcrt.to_currency, glcrt.from_currency, -- inverse rates
1541: glcrt.conversion_type,
1542: TRUNC(glcrt.from_conversion_date)
1543: + glrm.multiplier - 1
1544: FROM gl_row_multipliers glrm,
1545: gl_cross_rate_temp glcrt,
1546: gl_daily_rates gldr
1547: WHERE glcrt.mode_flag = 'D'
1548: AND glcrt.used_for_ab_translation = 'Y'

Line 1584: FROM gl_row_multipliers glrm,

1580: SELECT glcrt.from_currency, glcrt.to_currency,
1581: glcrt.conversion_type,
1582: TRUNC(glcrt.from_conversion_date)
1583: + glrm.multiplier - 1
1584: FROM gl_row_multipliers glrm,
1585: gl_cross_rate_temp glcrt,
1586: gl_daily_rates gldr
1587: WHERE ( glcrt.mode_flag in ('I', 'T')
1588: OR ( glcrt.mode_flag = 'D'

Line 1609: FROM gl_row_multipliers glrm,

1605: SELECT glcrt.to_currency, glcrt.from_currency,
1606: glcrt.conversion_type,
1607: TRUNC(glcrt.from_conversion_date)
1608: + glrm.multiplier - 1
1609: FROM gl_row_multipliers glrm,
1610: gl_cross_rate_temp glcrt,
1611: gl_daily_rates gldr
1612: WHERE ( glcrt.mode_flag in ('I', 'T')
1613: OR ( glcrt.mode_flag = 'D'

Line 1671: FROM gl_row_multipliers glrm,

1667: glcrt.conversion_type,
1668: glcrt.inverse_conversion_rate * gldr.conversion_rate,
1669: DECODE(glcrt.used_for_ab_translation, 'Y', 'O', 'C'),
1670: SYSDATE, 1, SYSDATE, 1, 1, 'SYSTEM'
1671: FROM gl_row_multipliers glrm,
1672: gl_cross_rate_temp glcrt,
1673: gl_daily_rates gldr
1674: WHERE glcrt.mode_flag in ('I', 'T', 'N')
1675: AND gldr.from_currency = glcrt.pivot_currency

Line 1715: FROM gl_row_multipliers glrm,

1711: glcrt.conversion_type,
1712: glcrt.conversion_rate * gldr.conversion_rate,
1713: DECODE(glcrt.used_for_ab_translation, 'Y', 'O', 'C'),
1714: SYSDATE, 1, SYSDATE, 1, 1, 'SYSTEM'
1715: FROM gl_row_multipliers glrm,
1716: gl_cross_rate_temp glcrt,
1717: gl_daily_rates gldr
1718: WHERE glcrt.mode_flag in ('I', 'T', 'N')
1719: AND gldr.to_currency = glcrt.pivot_currency