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_DAILY_CONVERSION_TYPES

Line 455: gl_daily_conversion_types dct

451: dri.conversion_rate,
452: NVL(dri.inverse_conversion_rate, 1/conversion_rate) inverse_conversion_rate,
453: dri.mode_flag
454: FROM gl_daily_rates_interface dri,
455: gl_daily_conversion_types dct
456: WHERE mode_flag IN ('I', 'D', 'T', 'N')
457: AND dct.user_conversion_type = dri.user_conversion_type;
458:
459: BEGIN

Line 588: gl_daily_conversion_types ct,

584: -1, 'EMU_TO_CURRENCY',
585: 0, 'EMU_TO_CURRENCY',
586: ''))))))))))))))))))
587: FROM gl_daily_rates_interface ri2,
588: gl_daily_conversion_types ct,
589: fnd_currencies from_curr,
590: fnd_currencies to_curr
591: WHERE ri2.ROWID = ri.ROWID
592: AND ct.user_conversion_type(+) = ri2.user_conversion_type

Line 637: gl_daily_conversion_types ct

633: Decode(mode_flag,'T','F','N','F','I','X','D','X',mode_flag)
634: WHERE (mode_flag IN('T', 'N','I','D') AND ERROR_CODE IS NOT NULL)
635: OR (mode_flag = 'N'
636: AND (EXISTS (SELECT 1 FROM gl_daily_rates dr,
637: gl_daily_conversion_types ct
638: WHERE dr.from_currency = ri.from_currency
639: AND dr.to_currency = ri.to_currency
640: AND dr.conversion_type = ct.conversion_type
641: AND ct.user_conversion_type = ri.user_conversion_type

Line 645: gl_daily_conversion_types ct

641: AND ct.user_conversion_type = ri.user_conversion_type
642: AND dr.conversion_date BETWEEN ri.from_conversion_date
643: AND ri.to_conversion_date)
644: OR EXISTS (SELECT 1 FROM gl_daily_rates dr,
645: gl_daily_conversion_types ct
646: WHERE dr.from_currency = ri.to_currency
647: AND dr.to_currency = ri.from_currency
648: AND dr.conversion_type = ct.conversion_type
649: AND ct.user_conversion_type = ri.user_conversion_type

Line 784: gl_daily_conversion_types gldct,

780: sys_daily_rate_cannot_delete.r_conversion_date,
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'

Line 786: gl_daily_conversion_types ct,

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 || ''
790: AND rm.multiplier BETWEEN 1 AND (TRUNC(ri.to_conversion_date)

Line 866: gl_daily_conversion_types gldct,

862: sys_daily_rate_cannot_override.r_conversion_date,
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 || ''

Line 868: gl_daily_conversion_types ct,

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)
872: - TRUNC(ri.from_conversion_date)

Line 931: FROM gl_daily_conversion_types ct,

927: -- R12 Change in the following update
928: UPDATE gl_daily_rates_interface ri
929: SET used_for_ab_translation =
930: ( SELECT nvl(max('Y'), 'N')
931: FROM gl_daily_conversion_types ct,
932: gl_ledgers led,
933: gl_ledger_relationships rel
934: WHERE ct.user_conversion_type = ri.user_conversion_type
935: AND rel.source_ledger_id = led.ledger_id

Line 985: gl_daily_conversion_types ct,

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'
989: AND ct.user_conversion_type =

Line 1003: gl_daily_conversion_types ct,

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'
1007: AND ct.user_conversion_type =

Line 1040: gl_daily_conversion_types ct,

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'
1044: AND ri.used_for_ab_translation <> 'Y'))

Line 1059: gl_daily_conversion_types ct,

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'
1063: AND ri.used_for_ab_translation <> 'Y'))

Line 1108: gl_daily_conversion_types ct,

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 || ''
1112: AND rm.multiplier BETWEEN 1

Line 1140: gl_daily_conversion_types ct,

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 || ''
1144: AND rm.multiplier BETWEEN 1

Line 1199: FROM gl_daily_conversion_types gct,

1195: FROM gl_daily_rates_interface
1196: WHERE mode_flag IN('I', 'D', 'T', 'N')
1197: AND user_conversion_type IN(
1198: SELECT user_conversion_type
1199: FROM gl_daily_conversion_types gct,
1200: gl_cross_rate_rules gcrs
1201: WHERE gct.conversion_type = gcrs.conversion_type)
1202: AND rownum < 2;
1203:

Line 1221: FROM gl_daily_conversion_types gct,

1217: DELETE FROM gl_daily_rates_interface
1218: WHERE mode_flag IN('I', 'D', 'T', 'N')
1219: AND user_conversion_type NOT IN(
1220: SELECT user_conversion_type
1221: FROM gl_daily_conversion_types gct,
1222: gl_cross_rate_rules gcrs
1223: WHERE gct.conversion_type = gcrs.conversion_type);
1224:
1225: gl_message.func_ent('Cross Rates Calculation');

Line 1264: gl_daily_conversion_types gldct,

1260: gldri.conversion_rate),
1261: DECODE(gldri.mode_flag, 'D', 'D', 'I'),
1262: gldri.used_for_ab_translation
1263: FROM gl_daily_rates_interface gldri,
1264: gl_daily_conversion_types gldct,
1265: gl_cross_rate_rules glcrs,
1266: gl_cross_rate_rule_dtls glcrsd
1267: WHERE gldri.mode_flag IN('I', 'D', 'T', 'N')
1268: AND gldri.user_conversion_type = gldct.user_conversion_type

Line 1304: FROM gl_daily_conversion_types ct,

1300:
1301: UPDATE gl_cross_rate_temp ri
1302: SET used_for_ab_translation =
1303: ( SELECT nvl(max('Y'), 'N')
1304: FROM gl_daily_conversion_types ct,
1305: gl_ledgers led,
1306: gl_ledger_relationships rel
1307: WHERE ct.conversion_type = ri.conversion_type
1308: AND rel.source_ledger_id = led.ledger_id

Line 1362: gl_daily_conversion_types gldct,

1358: usr_daily_rate_cannot_delete.r_conversion_date,
1359: usr_daily_rate_cannot_delete.r_rate,
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)

Line 1435: gl_daily_conversion_types gldct,

1431: usr_daily_rate_cannot_override.r_conversion_date,
1432: usr_daily_rate_cannot_override.r_rate,
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)