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.JA_CN_FSG_XML_BANK_PKG dependencies on RG_LOOKUPS

Line 983: from RG_REPORT_AXES rga, RG_LOOKUPS LK

979: AND rp.report_id = pn_balance_sheet_id;
980: end if;
981:
982: select MEANING into lv_currency_unit
983: from RG_REPORT_AXES rga, RG_LOOKUPS LK
984: where LK.LOOKUP_CODE = rga.display_units
985: and LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
986: AND AXIS_SET_ID = ln_clolumn_set_id
987: and rownum = 1

Line 992: FROM RG_LOOKUPS LK

988: ORDER BY AXIS_SEQ;
989: if nvl(lv_currency_unit,'-10')='-10' then
990: SELECT LK.MEANING
991: INTO lv_currency_unit
992: FROM RG_LOOKUPS LK
993: WHERE LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
994: and LOOKUP_CODE = 0;
995: end if;
996: EXCEPTION

Line 1004: FROM rg_lookups l, rg_reports r

1000: -- Rounding Option
1001: BEGIN
1002: SELECT l.meaning
1003: INTO lv_rounding_option
1004: FROM rg_lookups l, rg_reports r
1005: WHERE r.report_id = pn_balance_sheet_id
1006: AND l.lookup_type = 'ROUNDING_OPTION'
1007: AND l.lookup_code = r.rounding_option;
1008: EXCEPTION

Line 1058: FROM rg_reports rp, rg_lookups lk

1054: --MINIMUM_DISPLAY_LEVEL
1055: BEGIN
1056: SELECT lk.lookup_code
1057: INTO ln_minimum_display_level
1058: FROM rg_reports rp, rg_lookups lk
1059: WHERE rp.report_id = pn_balance_sheet_id
1060: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
1061: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
1062: EXCEPTION

Line 1137: from RG_REPORT_AXES rga, RG_LOOKUPS LK

1133: AND rp.report_id = pn_profit_statement_id;
1134: end if;
1135:
1136: select MEANING into lv_currency_unit
1137: from RG_REPORT_AXES rga, RG_LOOKUPS LK
1138: where LK.LOOKUP_CODE = rga.display_units
1139: and LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
1140: AND AXIS_SET_ID = ln_clolumn_set_id
1141: and rownum = 1

Line 1146: FROM RG_LOOKUPS LK

1142: ORDER BY AXIS_SEQ;
1143: if nvl(lv_currency_unit,'-10')='-10' then
1144: SELECT LK.MEANING
1145: INTO lv_currency_unit
1146: FROM RG_LOOKUPS LK
1147: WHERE LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
1148: and LOOKUP_CODE = 0;
1149: end if;
1150: EXCEPTION

Line 1158: FROM rg_lookups l, rg_reports r

1154: -- Rounding Option
1155: BEGIN
1156: SELECT l.meaning
1157: INTO lv_rounding_option
1158: FROM rg_lookups l, rg_reports r
1159: WHERE r.report_id = pn_profit_statement_id
1160: AND l.lookup_type = 'ROUNDING_OPTION'
1161: AND l.lookup_code = r.rounding_option;
1162: EXCEPTION

Line 1211: FROM rg_reports rp, rg_lookups lk

1207: --MINIMUM_DISPLAY_LEVEL
1208: BEGIN
1209: SELECT lk.lookup_code
1210: INTO ln_minimum_display_level
1211: FROM rg_reports rp, rg_lookups lk
1212: WHERE rp.report_id = pn_profit_statement_id
1213: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
1214: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
1215: EXCEPTION

Line 1292: from RG_REPORT_AXES rga, RG_LOOKUPS LK

1288: AND rp.report_id = pn_csf_report_id;
1289: end if;
1290:
1291: select MEANING into lv_currency_unit
1292: from RG_REPORT_AXES rga, RG_LOOKUPS LK
1293: where LK.LOOKUP_CODE = rga.display_units
1294: and LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
1295: AND AXIS_SET_ID = ln_clolumn_set_id
1296: and rownum = 1

Line 1301: FROM RG_LOOKUPS LK

1297: ORDER BY AXIS_SEQ;
1298: if nvl(lv_currency_unit,'-10')='-10' then
1299: SELECT LK.MEANING
1300: INTO lv_currency_unit
1301: FROM RG_LOOKUPS LK
1302: WHERE LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
1303: and LOOKUP_CODE = 0;
1304: end if;
1305: EXCEPTION

Line 1313: FROM rg_lookups l, rg_reports r

1309: -- Rounding Option
1310: BEGIN
1311: SELECT l.meaning
1312: INTO lv_rounding_option
1313: FROM rg_lookups l, rg_reports r
1314: WHERE r.report_id = pn_csf_report_id
1315: AND l.lookup_type = 'ROUNDING_OPTION'
1316: AND l.lookup_code = r.rounding_option;
1317: EXCEPTION

Line 1366: FROM rg_reports rp, rg_lookups lk

1362: --MINIMUM_DISPLAY_LEVEL
1363: BEGIN
1364: SELECT lk.lookup_code
1365: INTO ln_minimum_display_level
1366: FROM rg_reports rp, rg_lookups lk
1367: WHERE rp.report_id = pn_csf_report_id
1368: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
1369: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
1370: EXCEPTION

Line 1447: from RG_REPORT_AXES rga, RG_LOOKUPS LK

1443: AND rp.report_id = pn_owners_equity_id;
1444: end if;
1445:
1446: select MEANING into lv_currency_unit
1447: from RG_REPORT_AXES rga, RG_LOOKUPS LK
1448: where LK.LOOKUP_CODE = rga.display_units
1449: and LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
1450: AND AXIS_SET_ID = ln_clolumn_set_id
1451: and rownum = 1

Line 1456: FROM RG_LOOKUPS LK

1452: ORDER BY AXIS_SEQ;
1453: if nvl(lv_currency_unit,'-10')='-10' then
1454: SELECT LK.MEANING
1455: INTO lv_currency_unit
1456: FROM RG_LOOKUPS LK
1457: WHERE LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
1458: and LOOKUP_CODE = 0;
1459: end if;
1460: EXCEPTION

Line 1468: FROM rg_lookups l, rg_reports r

1464: -- Rounding Option
1465: BEGIN
1466: SELECT l.meaning
1467: INTO lv_rounding_option
1468: FROM rg_lookups l, rg_reports r
1469: WHERE r.report_id = pn_owners_equity_id
1470: AND l.lookup_type = 'ROUNDING_OPTION'
1471: AND l.lookup_code = r.rounding_option;
1472: EXCEPTION

Line 1521: FROM rg_reports rp, rg_lookups lk

1517: --MINIMUM_DISPLAY_LEVEL
1518: BEGIN
1519: SELECT lk.lookup_code
1520: INTO ln_minimum_display_level
1521: FROM rg_reports rp, rg_lookups lk
1522: WHERE rp.report_id = pn_owners_equity_id
1523: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
1524: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
1525: EXCEPTION