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 469: gl_daily_conversion_types dct

465: dri.conversion_rate,
466: NVL(dri.inverse_conversion_rate, 1/conversion_rate) inverse_conversion_rate,
467: dri.mode_flag
468: FROM gl_daily_rates_interface dri,
469: gl_daily_conversion_types dct
470: WHERE mode_flag IN ('I', 'D', 'T', 'N')
471: AND dct.user_conversion_type = dri.user_conversion_type
472: AND dri.batch_number = l_batch_number;
473:

Line 605: gl_daily_conversion_types ct,

601: -1, 'EMU_TO_CURRENCY',
602: 0, 'EMU_TO_CURRENCY',
603: ''))))))))))))))))))
604: FROM gl_daily_rates_interface ri2,
605: gl_daily_conversion_types ct,
606: fnd_currencies from_curr,
607: fnd_currencies to_curr
608: WHERE ri2.ROWID = ri.ROWID
609: AND ct.user_conversion_type(+) = ri2.user_conversion_type

Line 747: gl_daily_conversion_types ct,

743: -1, 'EMU_TO_CURRENCY',
744: 0, 'EMU_TO_CURRENCY',
745: ''))))))))))))))))))
746: FROM gl_daily_rates_interface ri2,
747: gl_daily_conversion_types ct,
748: fnd_currencies from_curr,
749: fnd_currencies to_curr
750: WHERE ri2.ROWID = ri.ROWID
751: AND ct.user_conversion_type(+) = ri2.user_conversion_type

Line 799: gl_daily_conversion_types ct

795: Decode(mode_flag,'T','F','N','F','I','X','D','X',mode_flag)
796: WHERE (mode_flag IN('T', 'N','I','D') AND batch_number = l_batch_number AND ERROR_CODE IS NOT NULL)
797: OR (mode_flag = 'N'
798: AND (EXISTS (SELECT 1 FROM gl_daily_rates dr,
799: gl_daily_conversion_types ct
800: WHERE dr.from_currency = ri.from_currency
801: AND dr.to_currency = ri.to_currency
802: AND dr.conversion_type = ct.conversion_type
803: AND ct.user_conversion_type = ri.user_conversion_type

Line 807: gl_daily_conversion_types ct

803: AND ct.user_conversion_type = ri.user_conversion_type
804: AND dr.conversion_date BETWEEN ri.from_conversion_date
805: AND ri.to_conversion_date)
806: OR EXISTS (SELECT 1 FROM gl_daily_rates dr,
807: gl_daily_conversion_types ct
808: WHERE dr.from_currency = ri.to_currency
809: AND dr.to_currency = ri.from_currency
810: AND dr.conversion_type = ct.conversion_type
811: AND ct.user_conversion_type = ri.user_conversion_type

Line 962: gl_daily_conversion_types gldct,

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

Line 964: gl_daily_conversion_types ct,

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

Line 1045: gl_daily_conversion_types gldct,

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

Line 1047: gl_daily_conversion_types ct,

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

Line 1111: FROM gl_daily_conversion_types ct,

1107: -- R12 Change in the following update
1108: UPDATE gl_daily_rates_interface ri
1109: SET used_for_ab_translation =
1110: ( SELECT nvl(max('Y'), 'N')
1111: FROM gl_daily_conversion_types ct,
1112: gl_ledgers led,
1113: gl_ledger_relationships rel
1114: WHERE ct.user_conversion_type = ri.user_conversion_type
1115: AND rel.source_ledger_id = led.ledger_id

Line 1166: gl_daily_conversion_types ct,

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
1170: AND ri.used_for_ab_translation = 'Y'

Line 1185: gl_daily_conversion_types ct,

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
1189: AND ri.used_for_ab_translation = 'Y'

Line 1223: gl_daily_conversion_types ct,

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')
1227: OR ( ri.mode_flag = 'D'

Line 1243: gl_daily_conversion_types ct,

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')
1247: OR ( ri.mode_flag = 'D'

Line 1293: gl_daily_conversion_types ct,

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

Line 1326: gl_daily_conversion_types ct,

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

Line 1404: FROM gl_daily_conversion_types gct,

1400: FROM gl_daily_rates_interface
1401: WHERE mode_flag IN('I', 'D', 'T', 'N')
1402: AND user_conversion_type IN(
1403: SELECT user_conversion_type
1404: FROM gl_daily_conversion_types gct,
1405: gl_cross_rate_rules gcrs
1406: WHERE gct.conversion_type = gcrs.conversion_type)
1407: AND batch_number = l_batch_number
1408: AND rownum < 2;

Line 1428: FROM gl_daily_conversion_types gct,

1424: WHERE mode_flag IN('I', 'D', 'T', 'N')
1425: AND batch_number = l_batch_number
1426: AND user_conversion_type NOT IN(
1427: SELECT user_conversion_type
1428: FROM gl_daily_conversion_types gct,
1429: gl_cross_rate_rules gcrs
1430: WHERE gct.conversion_type = gcrs.conversion_type);
1431:
1432: gl_message.func_ent('Cross Rates Calculation');

Line 1471: gl_daily_conversion_types gldct,

1467: gldri.conversion_rate),
1468: DECODE(gldri.mode_flag, 'D', 'D', 'I'),
1469: gldri.used_for_ab_translation
1470: FROM gl_daily_rates_interface gldri,
1471: gl_daily_conversion_types gldct,
1472: gl_cross_rate_rules glcrs,
1473: gl_cross_rate_rule_dtls glcrsd
1474: WHERE gldri.mode_flag IN('I', 'D', 'T', 'N')
1475: AND gldri.user_conversion_type = gldct.user_conversion_type

Line 1513: FROM gl_daily_conversion_types ct,

1509:
1510: UPDATE gl_cross_rate_temp ri
1511: SET used_for_ab_translation =
1512: ( SELECT nvl(max('Y'), 'N')
1513: FROM gl_daily_conversion_types ct,
1514: gl_ledgers led,
1515: gl_ledger_relationships rel
1516: WHERE ct.conversion_type = ri.conversion_type
1517: AND rel.source_ledger_id = led.ledger_id

Line 1571: gl_daily_conversion_types gldct,

1567: usr_daily_rate_cannot_delete.r_conversion_date,
1568: usr_daily_rate_cannot_delete.r_rate,
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)

Line 1644: gl_daily_conversion_types gldct,

1640: usr_daily_rate_cannot_override.r_conversion_date,
1641: usr_daily_rate_cannot_override.r_rate,
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)