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_SUBMIT_PROG dependencies on RG_LOOKUPS

Line 835: FROM rg_lookups l, rg_reports r

831: -- Rounding Option
832: BEGIN
833: SELECT l.meaning
834: INTO lv_rounding_option
835: FROM rg_lookups l, rg_reports r
836: WHERE r.report_id = pn_balance_sheet_id
837: AND l.lookup_type = 'ROUNDING_OPTION'
838: AND l.lookup_code = r.rounding_option;
839: EXCEPTION

Line 890: FROM rg_reports rp, rg_lookups lk

886: --MINIMUM_DISPLAY_LEVEL
887: BEGIN
888: SELECT lk.lookup_code
889: INTO ln_minimum_display_level
890: FROM rg_reports rp, rg_lookups lk
891: WHERE rp.report_id = pn_balance_sheet_id
892: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
893: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
894: EXCEPTION

Line 968: FROM rg_lookups l, rg_reports r

964: -- Rounding Option
965: BEGIN
966: SELECT l.meaning
967: INTO lv_rounding_option
968: FROM rg_lookups l, rg_reports r
969: WHERE r.report_id = pn_profit_statement_id
970: AND l.lookup_type = 'ROUNDING_OPTION'
971: AND l.lookup_code = r.rounding_option;
972: EXCEPTION

Line 1023: FROM rg_reports rp, rg_lookups lk

1019: --MINIMUM_DISPLAY_LEVEL
1020: BEGIN
1021: SELECT lk.lookup_code
1022: INTO ln_minimum_display_level
1023: FROM rg_reports rp, rg_lookups lk
1024: WHERE rp.report_id = pn_profit_statement_id
1025: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
1026: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
1027: EXCEPTION

Line 1102: FROM rg_lookups l, rg_reports r

1098: -- Rounding Option
1099: BEGIN
1100: SELECT l.meaning
1101: INTO lv_rounding_option
1102: FROM rg_lookups l, rg_reports r
1103: WHERE r.report_id = pn_owners_equity_id
1104: AND l.lookup_type = 'ROUNDING_OPTION'
1105: AND l.lookup_code = r.rounding_option;
1106: EXCEPTION

Line 1157: FROM rg_reports rp, rg_lookups lk

1153: --MINIMUM_DISPLAY_LEVEL
1154: BEGIN
1155: SELECT lk.lookup_code
1156: INTO ln_minimum_display_level
1157: FROM rg_reports rp, rg_lookups lk
1158: WHERE rp.report_id = pn_owners_equity_id
1159: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
1160: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
1161: EXCEPTION

Line 1237: FROM rg_lookups l, rg_reports r

1233: -- Rounding Option
1234: BEGIN
1235: SELECT l.meaning
1236: INTO lv_rounding_option
1237: FROM rg_lookups l, rg_reports r
1238: WHERE r.report_id = pn_csf_report_id
1239: AND l.lookup_type = 'ROUNDING_OPTION'
1240: AND l.lookup_code = r.rounding_option;
1241: EXCEPTION

Line 1292: FROM rg_reports rp, rg_lookups lk

1288: --MINIMUM_DISPLAY_LEVEL
1289: BEGIN
1290: SELECT lk.lookup_code
1291: INTO ln_minimum_display_level
1292: FROM rg_reports rp, rg_lookups lk
1293: WHERE rp.report_id = pn_csf_report_id
1294: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
1295: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
1296: EXCEPTION

Line 1833: FROM rg_lookups l, rg_reports r

1829: -- Rounding Option
1830: BEGIN
1831: SELECT l.meaning
1832: INTO lv_rounding_option
1833: FROM rg_lookups l, rg_reports r
1834: WHERE r.report_id = pn_balance_sheet_id
1835: AND l.lookup_type = 'ROUNDING_OPTION'
1836: AND l.lookup_code = r.rounding_option;
1837: EXCEPTION

Line 1888: FROM rg_reports rp, rg_lookups lk

1884: --MINIMUM_DISPLAY_LEVEL
1885: BEGIN
1886: SELECT lk.lookup_code
1887: INTO ln_minimum_display_level
1888: FROM rg_reports rp, rg_lookups lk
1889: WHERE rp.report_id = pn_balance_sheet_id
1890: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
1891: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
1892: EXCEPTION

Line 1966: FROM rg_lookups l, rg_reports r

1962: -- Rounding Option
1963: BEGIN
1964: SELECT l.meaning
1965: INTO lv_rounding_option
1966: FROM rg_lookups l, rg_reports r
1967: WHERE r.report_id = pn_profit_statement_id
1968: AND l.lookup_type = 'ROUNDING_OPTION'
1969: AND l.lookup_code = r.rounding_option;
1970: EXCEPTION

Line 2021: FROM rg_reports rp, rg_lookups lk

2017: --MINIMUM_DISPLAY_LEVEL
2018: BEGIN
2019: SELECT lk.lookup_code
2020: INTO ln_minimum_display_level
2021: FROM rg_reports rp, rg_lookups lk
2022: WHERE rp.report_id = pn_profit_statement_id
2023: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
2024: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
2025: EXCEPTION

Line 2100: FROM rg_lookups l, rg_reports r

2096: -- Rounding Option
2097: BEGIN
2098: SELECT l.meaning
2099: INTO lv_rounding_option
2100: FROM rg_lookups l, rg_reports r
2101: WHERE r.report_id = pn_owners_equity_id
2102: AND l.lookup_type = 'ROUNDING_OPTION'
2103: AND l.lookup_code = r.rounding_option;
2104: EXCEPTION

Line 2155: FROM rg_reports rp, rg_lookups lk

2151: --MINIMUM_DISPLAY_LEVEL
2152: BEGIN
2153: SELECT lk.lookup_code
2154: INTO ln_minimum_display_level
2155: FROM rg_reports rp, rg_lookups lk
2156: WHERE rp.report_id = pn_owners_equity_id
2157: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
2158: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
2159: EXCEPTION

Line 2235: FROM rg_lookups l, rg_reports r

2231: -- Rounding Option
2232: BEGIN
2233: SELECT l.meaning
2234: INTO lv_rounding_option
2235: FROM rg_lookups l, rg_reports r
2236: WHERE r.report_id = pn_csf_report_id
2237: AND l.lookup_type = 'ROUNDING_OPTION'
2238: AND l.lookup_code = r.rounding_option;
2239: EXCEPTION

Line 2290: FROM rg_reports rp, rg_lookups lk

2286: --MINIMUM_DISPLAY_LEVEL
2287: BEGIN
2288: SELECT lk.lookup_code
2289: INTO ln_minimum_display_level
2290: FROM rg_reports rp, rg_lookups lk
2291: WHERE rp.report_id = pn_csf_report_id
2292: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
2293: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
2294: EXCEPTION