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_REPORTS

Line 153: FROM RG_REPORTS

149: output_option,
150: name,
151: segment_override
152: INTO report_rec
153: FROM RG_REPORTS
154: WHERE REPORT_ID = X_REPORT_ID;
155:
156: --
157: -- If content set is used by this report then

Line 753: from rg_reports rp

749: l_coa_id
750: ) into l_delimiter from dual;
751: select segment_override
752: into l_override
753: from rg_reports rp
754: where rp.report_id = P_REPORT_ID;
755:
756: SELECT fs.application_column_name
757: into l_bsv_segment

Line 807: from rg_reports rp

803: l_fsg_currency varchar2(10);
804: begin
805: select unit_of_measure_id
806: into l_fsg_currency
807: from rg_reports rp
808: where rp.report_id = P_REPORT_ID;
809: if l_fsg_currency is null then
810: begin
811: select CURRENCY_CODE

Line 960: FROM rg_report_axis_sets rs, rg_reports rp

956: --(1) Balance Sheet Report and get this program request ID.
957: --ROW_SET_ID
958: SELECT rs.axis_set_id
959: INTO ln_row_set_id
960: FROM rg_report_axis_sets rs, rg_reports rp
961: WHERE rp.report_id = pn_balance_sheet_id
962: AND rp.row_set_id = rs.axis_set_id;
963: --COLUMN_SET_ID
964: SELECT cs.axis_set_id

Line 966: FROM rg_report_axis_sets cs, rg_reports rp

962: AND rp.row_set_id = rs.axis_set_id;
963: --COLUMN_SET_ID
964: SELECT cs.axis_set_id
965: INTO ln_clolumn_set_id
966: FROM rg_report_axis_sets cs, rg_reports rp
967: WHERE rp.report_id = pn_balance_sheet_id
968: AND rp.column_set_id = cs.axis_set_id;
969: --Unit of Measure ID/currency
970: BEGIN

Line 976: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc

972: lv_unit_of_measure_id:= Get_FSG_Currency(pn_ledger_id,pn_balance_sheet_id) ;
973: If lv_unit_of_measure_id is null then
974: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
975: INTO lv_unit_of_measure_id
976: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
977: WHERE ldg.ledger_id = acc.default_ledger_id
978: AND acc.access_set_id = pn_data_access_set_id
979: AND rp.report_id = pn_balance_sheet_id;
980: end if;

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 1025: FROM rg_report_content_sets cs, rg_reports rp

1021: --CONTENT_SET_ID
1022: BEGIN
1023: SELECT cs.content_set_id
1024: INTO ln_content_set_id
1025: FROM rg_report_content_sets cs, rg_reports rp
1026: WHERE rp.report_id = pn_balance_sheet_id
1027: AND rp.content_set_id = cs.content_set_id(+);
1028: EXCEPTION
1029: WHEN NO_DATA_FOUND THEN

Line 1036: FROM rg_row_orders ro, rg_reports rp

1032: --ROW_ORDER_ID
1033: BEGIN
1034: SELECT ro.row_order_id
1035: INTO ln_row_order_id
1036: FROM rg_row_orders ro, rg_reports rp
1037: WHERE rp.report_id = pn_balance_sheet_id
1038: AND rp.row_order_id = ro.row_order_id(+);
1039: EXCEPTION
1040: WHEN NO_DATA_FOUND THEN

Line 1047: FROM rg_report_display_sets ds, rg_reports rp

1043: --REPORT_DISPLAY_SET_ID
1044: BEGIN
1045: SELECT ds.report_display_set_id
1046: INTO ln_report_display_set_id
1047: FROM rg_report_display_sets ds, rg_reports rp
1048: WHERE rp.report_id = pn_balance_sheet_id
1049: AND rp.report_display_set_id = ds.report_display_set_id(+);
1050: EXCEPTION
1051: WHEN NO_DATA_FOUND THEN

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 1070: FROM rg_reports rp

1066: --PARAMETER_SET_ID
1067: BEGIN
1068: SELECT rp.parameter_set_id
1069: INTO ln_parameter_set_id
1070: FROM rg_reports rp
1071: WHERE rp.report_id = pn_balance_sheet_id;
1072: EXCEPTION
1073: WHEN NO_DATA_FOUND THEN
1074: NULL;

Line 1114: FROM rg_report_axis_sets rs, rg_reports rp

1110: --(2) Profit Statement Report and get this program request ID.
1111: --ROW_SET_ID
1112: SELECT rs.axis_set_id
1113: INTO ln_row_set_id
1114: FROM rg_report_axis_sets rs, rg_reports rp
1115: WHERE rp.report_id = pn_profit_statement_id
1116: AND rp.row_set_id = rs.axis_set_id;
1117: --COLUMN_SET_ID
1118: SELECT cs.axis_set_id

Line 1120: FROM rg_report_axis_sets cs, rg_reports rp

1116: AND rp.row_set_id = rs.axis_set_id;
1117: --COLUMN_SET_ID
1118: SELECT cs.axis_set_id
1119: INTO ln_clolumn_set_id
1120: FROM rg_report_axis_sets cs, rg_reports rp
1121: WHERE rp.report_id = pn_profit_statement_id
1122: AND rp.column_set_id = cs.axis_set_id;
1123: --Unit of Measure ID/currency
1124: BEGIN

Line 1130: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc

1126: lv_unit_of_measure_id:= Get_FSG_Currency(pn_ledger_id,pn_profit_statement_id) ;
1127: If lv_unit_of_measure_id is null then
1128: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
1129: INTO lv_unit_of_measure_id
1130: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
1131: WHERE ldg.ledger_id = acc.default_ledger_id
1132: AND acc.access_set_id = pn_data_access_set_id
1133: AND rp.report_id = pn_profit_statement_id;
1134: end if;

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 1178: FROM rg_report_content_sets cs, rg_reports rp

1174: --CONTENT_SET_ID
1175: BEGIN
1176: SELECT cs.content_set_id
1177: INTO ln_content_set_id
1178: FROM rg_report_content_sets cs, rg_reports rp
1179: WHERE rp.report_id = pn_profit_statement_id
1180: AND rp.content_set_id = cs.content_set_id(+);
1181: EXCEPTION
1182: WHEN NO_DATA_FOUND THEN

Line 1189: FROM rg_row_orders ro, rg_reports rp

1185: --ROW_ORDER_ID
1186: BEGIN
1187: SELECT ro.row_order_id
1188: INTO ln_row_order_id
1189: FROM rg_row_orders ro, rg_reports rp
1190: WHERE rp.report_id = pn_profit_statement_id
1191: AND rp.row_order_id = ro.row_order_id(+);
1192: EXCEPTION
1193: WHEN NO_DATA_FOUND THEN

Line 1200: FROM rg_report_display_sets ds, rg_reports rp

1196: --REPORT_DISPLAY_SET_ID
1197: BEGIN
1198: SELECT ds.report_display_set_id
1199: INTO ln_report_display_set_id
1200: FROM rg_report_display_sets ds, rg_reports rp
1201: WHERE rp.report_id = pn_profit_statement_id
1202: AND rp.report_display_set_id = ds.report_display_set_id(+);
1203: EXCEPTION
1204: WHEN NO_DATA_FOUND THEN

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 1223: FROM rg_reports rp

1219: --PARAMETER_SET_ID
1220: BEGIN
1221: SELECT rp.parameter_set_id
1222: INTO ln_parameter_set_id
1223: FROM rg_reports rp
1224: WHERE rp.report_id = pn_profit_statement_id;
1225: EXCEPTION
1226: WHEN NO_DATA_FOUND THEN
1227: NULL;

Line 1269: FROM rg_report_axis_sets rs, rg_reports rp

1265: -- (3) Statement of Cash flows Report and get this program request ID.
1266: --ROW_SET_ID
1267: SELECT rs.axis_set_id
1268: INTO ln_row_set_id
1269: FROM rg_report_axis_sets rs, rg_reports rp
1270: WHERE rp.report_id = pn_csf_report_id
1271: AND rp.row_set_id = rs.axis_set_id;
1272: --COLUMN_SET_ID
1273: SELECT cs.axis_set_id

Line 1275: FROM rg_report_axis_sets cs, rg_reports rp

1271: AND rp.row_set_id = rs.axis_set_id;
1272: --COLUMN_SET_ID
1273: SELECT cs.axis_set_id
1274: INTO ln_clolumn_set_id
1275: FROM rg_report_axis_sets cs, rg_reports rp
1276: WHERE rp.report_id = pn_csf_report_id
1277: AND rp.column_set_id = cs.axis_set_id;
1278: --Unit of Measure ID/currency
1279: BEGIN

Line 1285: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc

1281: lv_unit_of_measure_id:= Get_FSG_Currency(pn_ledger_id,pn_csf_report_id) ;
1282: If lv_unit_of_measure_id is null then
1283: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
1284: INTO lv_unit_of_measure_id
1285: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
1286: WHERE ldg.ledger_id = acc.default_ledger_id
1287: AND acc.access_set_id = pn_data_access_set_id
1288: AND rp.report_id = pn_csf_report_id;
1289: end if;

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 1333: FROM rg_report_content_sets cs, rg_reports rp

1329: --CONTENT_SET_ID
1330: BEGIN
1331: SELECT cs.content_set_id
1332: INTO ln_content_set_id
1333: FROM rg_report_content_sets cs, rg_reports rp
1334: WHERE rp.report_id = pn_csf_report_id
1335: AND rp.content_set_id = cs.content_set_id(+);
1336: EXCEPTION
1337: WHEN NO_DATA_FOUND THEN

Line 1344: FROM rg_row_orders ro, rg_reports rp

1340: --ROW_ORDER_ID
1341: BEGIN
1342: SELECT ro.row_order_id
1343: INTO ln_row_order_id
1344: FROM rg_row_orders ro, rg_reports rp
1345: WHERE rp.report_id = pn_csf_report_id
1346: AND rp.row_order_id = ro.row_order_id(+);
1347: EXCEPTION
1348: WHEN NO_DATA_FOUND THEN

Line 1355: FROM rg_report_display_sets ds, rg_reports rp

1351: --REPORT_DISPLAY_SET_ID
1352: BEGIN
1353: SELECT ds.report_display_set_id
1354: INTO ln_report_display_set_id
1355: FROM rg_report_display_sets ds, rg_reports rp
1356: WHERE rp.report_id = pn_csf_report_id
1357: AND rp.report_display_set_id = ds.report_display_set_id(+);
1358: EXCEPTION
1359: WHEN NO_DATA_FOUND THEN

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 1378: FROM rg_reports rp

1374: --PARAMETER_SET_ID
1375: BEGIN
1376: SELECT rp.parameter_set_id
1377: INTO ln_parameter_set_id
1378: FROM rg_reports rp
1379: WHERE rp.report_id = pn_csf_report_id;
1380: EXCEPTION
1381: WHEN NO_DATA_FOUND THEN
1382: NULL;

Line 1424: FROM rg_report_axis_sets rs, rg_reports rp

1420: --(4) Owners Equity Report and get this program request ID.
1421: --ROW_SET_ID
1422: SELECT rs.axis_set_id
1423: INTO ln_row_set_id
1424: FROM rg_report_axis_sets rs, rg_reports rp
1425: WHERE rp.report_id = pn_owners_equity_id
1426: AND rp.row_set_id = rs.axis_set_id;
1427: --COLUMN_SET_ID
1428: SELECT cs.axis_set_id

Line 1430: FROM rg_report_axis_sets cs, rg_reports rp

1426: AND rp.row_set_id = rs.axis_set_id;
1427: --COLUMN_SET_ID
1428: SELECT cs.axis_set_id
1429: INTO ln_clolumn_set_id
1430: FROM rg_report_axis_sets cs, rg_reports rp
1431: WHERE rp.report_id = pn_owners_equity_id
1432: AND rp.column_set_id = cs.axis_set_id;
1433: --Unit of Measure ID/currency
1434: BEGIN

Line 1440: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc

1436: lv_unit_of_measure_id:= Get_FSG_Currency(pn_ledger_id,pn_owners_equity_id) ;
1437: If lv_unit_of_measure_id is null then
1438: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
1439: INTO lv_unit_of_measure_id
1440: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
1441: WHERE ldg.ledger_id = acc.default_ledger_id
1442: AND acc.access_set_id = pn_data_access_set_id
1443: AND rp.report_id = pn_owners_equity_id;
1444: end if;

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 1488: FROM rg_report_content_sets cs, rg_reports rp

1484: --CONTENT_SET_ID
1485: BEGIN
1486: SELECT cs.content_set_id
1487: INTO ln_content_set_id
1488: FROM rg_report_content_sets cs, rg_reports rp
1489: WHERE rp.report_id = pn_owners_equity_id
1490: AND rp.content_set_id = cs.content_set_id(+);
1491: EXCEPTION
1492: WHEN NO_DATA_FOUND THEN

Line 1499: FROM rg_row_orders ro, rg_reports rp

1495: --ROW_ORDER_ID
1496: BEGIN
1497: SELECT ro.row_order_id
1498: INTO ln_row_order_id
1499: FROM rg_row_orders ro, rg_reports rp
1500: WHERE rp.report_id = pn_owners_equity_id
1501: AND rp.row_order_id = ro.row_order_id(+);
1502: EXCEPTION
1503: WHEN NO_DATA_FOUND THEN

Line 1510: FROM rg_report_display_sets ds, rg_reports rp

1506: --REPORT_DISPLAY_SET_ID
1507: BEGIN
1508: SELECT ds.report_display_set_id
1509: INTO ln_report_display_set_id
1510: FROM rg_report_display_sets ds, rg_reports rp
1511: WHERE rp.report_id = pn_owners_equity_id
1512: AND rp.report_display_set_id = ds.report_display_set_id(+);
1513: EXCEPTION
1514: WHEN NO_DATA_FOUND THEN

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

Line 1533: FROM rg_reports rp

1529: --PARAMETER_SET_ID
1530: BEGIN
1531: SELECT rp.parameter_set_id
1532: INTO ln_parameter_set_id
1533: FROM rg_reports rp
1534: WHERE rp.report_id = pn_owners_equity_id;
1535: EXCEPTION
1536: WHEN NO_DATA_FOUND THEN
1537: NULL;