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_REPORTS

Line 152: FROM RG_REPORTS

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

Line 810: FROM rg_report_axis_sets rs, rg_reports rp

806: --(1) Submit Balance Sheet Report and get this program request ID.
807: --ROW_SET_ID
808: SELECT rs.axis_set_id
809: INTO ln_row_set_id
810: FROM rg_report_axis_sets rs, rg_reports rp
811: WHERE rp.report_id = pn_balance_sheet_id
812: AND rp.row_set_id = rs.axis_set_id;
813: --COLUMN_SET_ID
814: SELECT cs.axis_set_id

Line 816: FROM rg_report_axis_sets cs, rg_reports rp

812: AND rp.row_set_id = rs.axis_set_id;
813: --COLUMN_SET_ID
814: SELECT cs.axis_set_id
815: INTO ln_clolumn_set_id
816: FROM rg_report_axis_sets cs, rg_reports rp
817: WHERE rp.report_id = pn_balance_sheet_id
818: AND rp.column_set_id = cs.axis_set_id;
819: --Unit of Measure ID/currency
820: BEGIN

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

819: --Unit of Measure ID/currency
820: BEGIN
821: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
822: INTO lv_unit_of_measure_id
823: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
824: WHERE ldg.ledger_id = acc.default_ledger_id
825: AND acc.access_set_id = pn_data_access_set_id
826: AND rp.report_id = pn_balance_sheet_id;
827: EXCEPTION

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 847: FROM rg_reports

843: -- Segment Override
844: BEGIN
845: SELECT segment_override
846: INTO lv_segment_override
847: FROM rg_reports
848: WHERE report_id = pn_balance_sheet_id;
849: EXCEPTION
850: WHEN NO_DATA_FOUND THEN
851: NULL;

Line 857: FROM rg_report_content_sets cs, rg_reports rp

853: --CONTENT_SET_ID
854: BEGIN
855: SELECT cs.content_set_id
856: INTO ln_content_set_id
857: FROM rg_report_content_sets cs, rg_reports rp
858: WHERE rp.report_id = pn_balance_sheet_id
859: AND rp.content_set_id = cs.content_set_id(+);
860: EXCEPTION
861: WHEN NO_DATA_FOUND THEN

Line 868: FROM rg_row_orders ro, rg_reports rp

864: --ROW_ORDER_ID
865: BEGIN
866: SELECT ro.row_order_id
867: INTO ln_row_order_id
868: FROM rg_row_orders ro, rg_reports rp
869: WHERE rp.report_id = pn_balance_sheet_id
870: AND rp.row_order_id = ro.row_order_id(+);
871: EXCEPTION
872: WHEN NO_DATA_FOUND THEN

Line 879: FROM rg_report_display_sets ds, rg_reports rp

875: --REPORT_DISPLAY_SET_ID
876: BEGIN
877: SELECT ds.report_display_set_id
878: INTO ln_report_display_set_id
879: FROM rg_report_display_sets ds, rg_reports rp
880: WHERE rp.report_id = pn_balance_sheet_id
881: AND rp.report_display_set_id = ds.report_display_set_id(+);
882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN

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

898: --PARAMETER_SET_ID
899: BEGIN
900: SELECT rp.parameter_set_id
901: INTO ln_parameter_set_id
902: FROM rg_reports rp
903: WHERE rp.report_id = pn_balance_sheet_id;
904: EXCEPTION
905: WHEN NO_DATA_FOUND THEN
906: NULL;

Line 943: FROM rg_report_axis_sets rs, rg_reports rp

939: --(2) Submit Profit Statement Report and get this program request ID.
940: --ROW_SET_ID
941: SELECT rs.axis_set_id
942: INTO ln_row_set_id
943: FROM rg_report_axis_sets rs, rg_reports rp
944: WHERE rp.report_id = pn_profit_statement_id
945: AND rp.row_set_id = rs.axis_set_id;
946: --COLUMN_SET_ID
947: SELECT cs.axis_set_id

Line 949: FROM rg_report_axis_sets cs, rg_reports rp

945: AND rp.row_set_id = rs.axis_set_id;
946: --COLUMN_SET_ID
947: SELECT cs.axis_set_id
948: INTO ln_clolumn_set_id
949: FROM rg_report_axis_sets cs, rg_reports rp
950: WHERE rp.report_id = pn_profit_statement_id
951: AND rp.column_set_id = cs.axis_set_id;
952: --Unit of Measure ID/currency
953: BEGIN

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

952: --Unit of Measure ID/currency
953: BEGIN
954: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
955: INTO lv_unit_of_measure_id
956: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
957: WHERE ldg.ledger_id = acc.default_ledger_id
958: AND acc.access_set_id = pn_profit_statement_id
959: AND rp.report_id = pn_balance_sheet_id;
960: 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 980: FROM rg_reports

976: -- Segment Override
977: BEGIN
978: SELECT segment_override
979: INTO lv_segment_override
980: FROM rg_reports
981: WHERE report_id = pn_profit_statement_id;
982: EXCEPTION
983: WHEN NO_DATA_FOUND THEN
984: NULL;

Line 990: FROM rg_report_content_sets cs, rg_reports rp

986: --CONTENT_SET_ID
987: BEGIN
988: SELECT cs.content_set_id
989: INTO ln_content_set_id
990: FROM rg_report_content_sets cs, rg_reports rp
991: WHERE rp.report_id = pn_profit_statement_id
992: AND rp.content_set_id = cs.content_set_id(+);
993: EXCEPTION
994: WHEN NO_DATA_FOUND THEN

Line 1001: FROM rg_row_orders ro, rg_reports rp

997: --ROW_ORDER_ID
998: BEGIN
999: SELECT ro.row_order_id
1000: INTO ln_row_order_id
1001: FROM rg_row_orders ro, rg_reports rp
1002: WHERE rp.report_id = pn_profit_statement_id
1003: AND rp.row_order_id = ro.row_order_id(+);
1004: EXCEPTION
1005: WHEN NO_DATA_FOUND THEN

Line 1012: FROM rg_report_display_sets ds, rg_reports rp

1008: --REPORT_DISPLAY_SET_ID
1009: BEGIN
1010: SELECT ds.report_display_set_id
1011: INTO ln_report_display_set_id
1012: FROM rg_report_display_sets ds, rg_reports rp
1013: WHERE rp.report_id = pn_profit_statement_id
1014: AND rp.report_display_set_id = ds.report_display_set_id(+);
1015: EXCEPTION
1016: WHEN NO_DATA_FOUND THEN

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

1031: --PARAMETER_SET_ID
1032: BEGIN
1033: SELECT rp.parameter_set_id
1034: INTO ln_parameter_set_id
1035: FROM rg_reports rp
1036: WHERE rp.report_id = pn_profit_statement_id;
1037: EXCEPTION
1038: WHEN NO_DATA_FOUND THEN
1039: NULL;

Line 1077: FROM rg_report_axis_sets rs, rg_reports rp

1073: --(3) Submit Profit Statement Report and get this program request ID.
1074: --ROW_SET_ID
1075: SELECT rs.axis_set_id
1076: INTO ln_row_set_id
1077: FROM rg_report_axis_sets rs, rg_reports rp
1078: WHERE rp.report_id = pn_owners_equity_id
1079: AND rp.row_set_id = rs.axis_set_id;
1080: --COLUMN_SET_ID
1081: SELECT cs.axis_set_id

Line 1083: FROM rg_report_axis_sets cs, rg_reports rp

1079: AND rp.row_set_id = rs.axis_set_id;
1080: --COLUMN_SET_ID
1081: SELECT cs.axis_set_id
1082: INTO ln_clolumn_set_id
1083: FROM rg_report_axis_sets cs, rg_reports rp
1084: WHERE rp.report_id = pn_owners_equity_id
1085: AND rp.column_set_id = cs.axis_set_id;
1086: --Unit of Measure ID/currency
1087: BEGIN

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

1086: --Unit of Measure ID/currency
1087: BEGIN
1088: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
1089: INTO lv_unit_of_measure_id
1090: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
1091: WHERE ldg.ledger_id = acc.default_ledger_id
1092: AND acc.access_set_id = pn_owners_equity_id
1093: AND rp.report_id = pn_balance_sheet_id;
1094: 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 1114: FROM rg_reports

1110: -- Segment Override
1111: BEGIN
1112: SELECT segment_override
1113: INTO lv_segment_override
1114: FROM rg_reports
1115: WHERE report_id = pn_owners_equity_id;
1116: EXCEPTION
1117: WHEN NO_DATA_FOUND THEN
1118: NULL;

Line 1124: FROM rg_report_content_sets cs, rg_reports rp

1120: --CONTENT_SET_ID
1121: BEGIN
1122: SELECT cs.content_set_id
1123: INTO ln_content_set_id
1124: FROM rg_report_content_sets cs, rg_reports rp
1125: WHERE rp.report_id = pn_owners_equity_id
1126: AND rp.content_set_id = cs.content_set_id(+);
1127: EXCEPTION
1128: WHEN NO_DATA_FOUND THEN

Line 1135: FROM rg_row_orders ro, rg_reports rp

1131: --ROW_ORDER_ID
1132: BEGIN
1133: SELECT ro.row_order_id
1134: INTO ln_row_order_id
1135: FROM rg_row_orders ro, rg_reports rp
1136: WHERE rp.report_id = pn_owners_equity_id
1137: AND rp.row_order_id = ro.row_order_id(+);
1138: EXCEPTION
1139: WHEN NO_DATA_FOUND THEN

Line 1146: FROM rg_report_display_sets ds, rg_reports rp

1142: --REPORT_DISPLAY_SET_ID
1143: BEGIN
1144: SELECT ds.report_display_set_id
1145: INTO ln_report_display_set_id
1146: FROM rg_report_display_sets ds, rg_reports rp
1147: WHERE rp.report_id = pn_owners_equity_id
1148: AND rp.report_display_set_id = ds.report_display_set_id(+);
1149: EXCEPTION
1150: WHEN NO_DATA_FOUND THEN

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

1165: --PARAMETER_SET_ID
1166: BEGIN
1167: SELECT rp.parameter_set_id
1168: INTO ln_parameter_set_id
1169: FROM rg_reports rp
1170: WHERE rp.report_id = pn_owners_equity_id;
1171: EXCEPTION
1172: WHEN NO_DATA_FOUND THEN
1173: NULL;

Line 1212: FROM rg_report_axis_sets rs, rg_reports rp

1208: -- then get the Combination Program request ID.
1209: --ROW_SET_ID
1210: SELECT rs.axis_set_id
1211: INTO ln_row_set_id
1212: FROM rg_report_axis_sets rs, rg_reports rp
1213: WHERE rp.report_id = pn_csf_report_id
1214: AND rp.row_set_id = rs.axis_set_id;
1215: --COLUMN_SET_ID
1216: SELECT cs.axis_set_id

Line 1218: FROM rg_report_axis_sets cs, rg_reports rp

1214: AND rp.row_set_id = rs.axis_set_id;
1215: --COLUMN_SET_ID
1216: SELECT cs.axis_set_id
1217: INTO ln_clolumn_set_id
1218: FROM rg_report_axis_sets cs, rg_reports rp
1219: WHERE rp.report_id = pn_csf_report_id
1220: AND rp.column_set_id = cs.axis_set_id;
1221: --Unit of Measure ID/currency
1222: BEGIN

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

1221: --Unit of Measure ID/currency
1222: BEGIN
1223: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
1224: INTO lv_unit_of_measure_id
1225: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
1226: WHERE ldg.ledger_id = acc.default_ledger_id
1227: AND acc.access_set_id = pn_csf_report_id
1228: AND rp.report_id = pn_balance_sheet_id;
1229: 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 1249: FROM rg_reports

1245: -- Segment Override
1246: BEGIN
1247: SELECT segment_override
1248: INTO lv_segment_override
1249: FROM rg_reports
1250: WHERE report_id = pn_csf_report_id;
1251: EXCEPTION
1252: WHEN NO_DATA_FOUND THEN
1253: NULL;

Line 1259: FROM rg_report_content_sets cs, rg_reports rp

1255: --CONTENT_SET_ID
1256: BEGIN
1257: SELECT cs.content_set_id
1258: INTO ln_content_set_id
1259: FROM rg_report_content_sets cs, rg_reports rp
1260: WHERE rp.report_id = pn_csf_report_id
1261: AND rp.content_set_id = cs.content_set_id(+);
1262: EXCEPTION
1263: WHEN NO_DATA_FOUND THEN

Line 1270: FROM rg_row_orders ro, rg_reports rp

1266: --ROW_ORDER_ID
1267: BEGIN
1268: SELECT ro.row_order_id
1269: INTO ln_row_order_id
1270: FROM rg_row_orders ro, rg_reports rp
1271: WHERE rp.report_id = pn_csf_report_id
1272: AND rp.row_order_id = ro.row_order_id(+);
1273: EXCEPTION
1274: WHEN NO_DATA_FOUND THEN

Line 1281: FROM rg_report_display_sets ds, rg_reports rp

1277: --REPORT_DISPLAY_SET_ID
1278: BEGIN
1279: SELECT ds.report_display_set_id
1280: INTO ln_report_display_set_id
1281: FROM rg_report_display_sets ds, rg_reports rp
1282: WHERE rp.report_id = pn_csf_report_id
1283: AND rp.report_display_set_id = ds.report_display_set_id(+);
1284: EXCEPTION
1285: WHEN NO_DATA_FOUND THEN

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

1300: --PARAMETER_SET_ID
1301: BEGIN
1302: SELECT rp.parameter_set_id
1303: INTO ln_parameter_set_id
1304: FROM rg_reports rp
1305: WHERE rp.report_id = pn_csf_report_id;
1306: EXCEPTION
1307: WHEN NO_DATA_FOUND THEN
1308: NULL;

Line 1808: FROM rg_report_axis_sets rs, rg_reports rp

1804: --(1) Submit Balance Sheet Report and get this program request ID.
1805: --ROW_SET_ID
1806: SELECT rs.axis_set_id
1807: INTO ln_row_set_id
1808: FROM rg_report_axis_sets rs, rg_reports rp
1809: WHERE rp.report_id = pn_balance_sheet_id
1810: AND rp.row_set_id = rs.axis_set_id;
1811: --COLUMN_SET_ID
1812: SELECT cs.axis_set_id

Line 1814: FROM rg_report_axis_sets cs, rg_reports rp

1810: AND rp.row_set_id = rs.axis_set_id;
1811: --COLUMN_SET_ID
1812: SELECT cs.axis_set_id
1813: INTO ln_clolumn_set_id
1814: FROM rg_report_axis_sets cs, rg_reports rp
1815: WHERE rp.report_id = pn_balance_sheet_id
1816: AND rp.column_set_id = cs.axis_set_id;
1817: --Unit of Measure ID/currency
1818: BEGIN

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

1817: --Unit of Measure ID/currency
1818: BEGIN
1819: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
1820: INTO lv_unit_of_measure_id
1821: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
1822: WHERE ldg.ledger_id = acc.default_ledger_id
1823: AND acc.access_set_id = pn_data_access_set_id
1824: AND rp.report_id = pn_balance_sheet_id;
1825: 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 1845: FROM rg_reports

1841: -- Segment Override
1842: BEGIN
1843: SELECT segment_override
1844: INTO lv_segment_override
1845: FROM rg_reports
1846: WHERE report_id = pn_balance_sheet_id;
1847: EXCEPTION
1848: WHEN NO_DATA_FOUND THEN
1849: NULL;

Line 1855: FROM rg_report_content_sets cs, rg_reports rp

1851: --CONTENT_SET_ID
1852: BEGIN
1853: SELECT cs.content_set_id
1854: INTO ln_content_set_id
1855: FROM rg_report_content_sets cs, rg_reports rp
1856: WHERE rp.report_id = pn_balance_sheet_id
1857: AND rp.content_set_id = cs.content_set_id(+);
1858: EXCEPTION
1859: WHEN NO_DATA_FOUND THEN

Line 1866: FROM rg_row_orders ro, rg_reports rp

1862: --ROW_ORDER_ID
1863: BEGIN
1864: SELECT ro.row_order_id
1865: INTO ln_row_order_id
1866: FROM rg_row_orders ro, rg_reports rp
1867: WHERE rp.report_id = pn_balance_sheet_id
1868: AND rp.row_order_id = ro.row_order_id(+);
1869: EXCEPTION
1870: WHEN NO_DATA_FOUND THEN

Line 1877: FROM rg_report_display_sets ds, rg_reports rp

1873: --REPORT_DISPLAY_SET_ID
1874: BEGIN
1875: SELECT ds.report_display_set_id
1876: INTO ln_report_display_set_id
1877: FROM rg_report_display_sets ds, rg_reports rp
1878: WHERE rp.report_id = pn_balance_sheet_id
1879: AND rp.report_display_set_id = ds.report_display_set_id(+);
1880: EXCEPTION
1881: WHEN NO_DATA_FOUND THEN

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

1896: --PARAMETER_SET_ID
1897: BEGIN
1898: SELECT rp.parameter_set_id
1899: INTO ln_parameter_set_id
1900: FROM rg_reports rp
1901: WHERE rp.report_id = pn_balance_sheet_id;
1902: EXCEPTION
1903: WHEN NO_DATA_FOUND THEN
1904: NULL;

Line 1941: FROM rg_report_axis_sets rs, rg_reports rp

1937: --(2) Submit Profit Statement Report and get this program request ID.
1938: --ROW_SET_ID
1939: SELECT rs.axis_set_id
1940: INTO ln_row_set_id
1941: FROM rg_report_axis_sets rs, rg_reports rp
1942: WHERE rp.report_id = pn_profit_statement_id
1943: AND rp.row_set_id = rs.axis_set_id;
1944: --COLUMN_SET_ID
1945: SELECT cs.axis_set_id

Line 1947: FROM rg_report_axis_sets cs, rg_reports rp

1943: AND rp.row_set_id = rs.axis_set_id;
1944: --COLUMN_SET_ID
1945: SELECT cs.axis_set_id
1946: INTO ln_clolumn_set_id
1947: FROM rg_report_axis_sets cs, rg_reports rp
1948: WHERE rp.report_id = pn_profit_statement_id
1949: AND rp.column_set_id = cs.axis_set_id;
1950: --Unit of Measure ID/currency
1951: BEGIN

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

1950: --Unit of Measure ID/currency
1951: BEGIN
1952: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
1953: INTO lv_unit_of_measure_id
1954: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
1955: WHERE ldg.ledger_id = acc.default_ledger_id
1956: AND acc.access_set_id = pn_profit_statement_id
1957: AND rp.report_id = pn_balance_sheet_id;
1958: 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 1978: FROM rg_reports

1974: -- Segment Override
1975: BEGIN
1976: SELECT segment_override
1977: INTO lv_segment_override
1978: FROM rg_reports
1979: WHERE report_id = pn_profit_statement_id;
1980: EXCEPTION
1981: WHEN NO_DATA_FOUND THEN
1982: NULL;

Line 1988: FROM rg_report_content_sets cs, rg_reports rp

1984: --CONTENT_SET_ID
1985: BEGIN
1986: SELECT cs.content_set_id
1987: INTO ln_content_set_id
1988: FROM rg_report_content_sets cs, rg_reports rp
1989: WHERE rp.report_id = pn_profit_statement_id
1990: AND rp.content_set_id = cs.content_set_id(+);
1991: EXCEPTION
1992: WHEN NO_DATA_FOUND THEN

Line 1999: FROM rg_row_orders ro, rg_reports rp

1995: --ROW_ORDER_ID
1996: BEGIN
1997: SELECT ro.row_order_id
1998: INTO ln_row_order_id
1999: FROM rg_row_orders ro, rg_reports rp
2000: WHERE rp.report_id = pn_profit_statement_id
2001: AND rp.row_order_id = ro.row_order_id(+);
2002: EXCEPTION
2003: WHEN NO_DATA_FOUND THEN

Line 2010: FROM rg_report_display_sets ds, rg_reports rp

2006: --REPORT_DISPLAY_SET_ID
2007: BEGIN
2008: SELECT ds.report_display_set_id
2009: INTO ln_report_display_set_id
2010: FROM rg_report_display_sets ds, rg_reports rp
2011: WHERE rp.report_id = pn_profit_statement_id
2012: AND rp.report_display_set_id = ds.report_display_set_id(+);
2013: EXCEPTION
2014: WHEN NO_DATA_FOUND THEN

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

2029: --PARAMETER_SET_ID
2030: BEGIN
2031: SELECT rp.parameter_set_id
2032: INTO ln_parameter_set_id
2033: FROM rg_reports rp
2034: WHERE rp.report_id = pn_profit_statement_id;
2035: EXCEPTION
2036: WHEN NO_DATA_FOUND THEN
2037: NULL;

Line 2075: FROM rg_report_axis_sets rs, rg_reports rp

2071: --(3) Submit Profit Statement Report and get this program request ID.
2072: --ROW_SET_ID
2073: SELECT rs.axis_set_id
2074: INTO ln_row_set_id
2075: FROM rg_report_axis_sets rs, rg_reports rp
2076: WHERE rp.report_id = pn_owners_equity_id
2077: AND rp.row_set_id = rs.axis_set_id;
2078: --COLUMN_SET_ID
2079: SELECT cs.axis_set_id

Line 2081: FROM rg_report_axis_sets cs, rg_reports rp

2077: AND rp.row_set_id = rs.axis_set_id;
2078: --COLUMN_SET_ID
2079: SELECT cs.axis_set_id
2080: INTO ln_clolumn_set_id
2081: FROM rg_report_axis_sets cs, rg_reports rp
2082: WHERE rp.report_id = pn_owners_equity_id
2083: AND rp.column_set_id = cs.axis_set_id;
2084: --Unit of Measure ID/currency
2085: BEGIN

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

2084: --Unit of Measure ID/currency
2085: BEGIN
2086: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
2087: INTO lv_unit_of_measure_id
2088: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
2089: WHERE ldg.ledger_id = acc.default_ledger_id
2090: AND acc.access_set_id = pn_owners_equity_id
2091: AND rp.report_id = pn_balance_sheet_id;
2092: 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 2112: FROM rg_reports

2108: -- Segment Override
2109: BEGIN
2110: SELECT segment_override
2111: INTO lv_segment_override
2112: FROM rg_reports
2113: WHERE report_id = pn_owners_equity_id;
2114: EXCEPTION
2115: WHEN NO_DATA_FOUND THEN
2116: NULL;

Line 2122: FROM rg_report_content_sets cs, rg_reports rp

2118: --CONTENT_SET_ID
2119: BEGIN
2120: SELECT cs.content_set_id
2121: INTO ln_content_set_id
2122: FROM rg_report_content_sets cs, rg_reports rp
2123: WHERE rp.report_id = pn_owners_equity_id
2124: AND rp.content_set_id = cs.content_set_id(+);
2125: EXCEPTION
2126: WHEN NO_DATA_FOUND THEN

Line 2133: FROM rg_row_orders ro, rg_reports rp

2129: --ROW_ORDER_ID
2130: BEGIN
2131: SELECT ro.row_order_id
2132: INTO ln_row_order_id
2133: FROM rg_row_orders ro, rg_reports rp
2134: WHERE rp.report_id = pn_owners_equity_id
2135: AND rp.row_order_id = ro.row_order_id(+);
2136: EXCEPTION
2137: WHEN NO_DATA_FOUND THEN

Line 2144: FROM rg_report_display_sets ds, rg_reports rp

2140: --REPORT_DISPLAY_SET_ID
2141: BEGIN
2142: SELECT ds.report_display_set_id
2143: INTO ln_report_display_set_id
2144: FROM rg_report_display_sets ds, rg_reports rp
2145: WHERE rp.report_id = pn_owners_equity_id
2146: AND rp.report_display_set_id = ds.report_display_set_id(+);
2147: EXCEPTION
2148: WHEN NO_DATA_FOUND THEN

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

2163: --PARAMETER_SET_ID
2164: BEGIN
2165: SELECT rp.parameter_set_id
2166: INTO ln_parameter_set_id
2167: FROM rg_reports rp
2168: WHERE rp.report_id = pn_owners_equity_id;
2169: EXCEPTION
2170: WHEN NO_DATA_FOUND THEN
2171: NULL;

Line 2210: FROM rg_report_axis_sets rs, rg_reports rp

2206: -- then get the Combination Program request ID.
2207: --ROW_SET_ID
2208: SELECT rs.axis_set_id
2209: INTO ln_row_set_id
2210: FROM rg_report_axis_sets rs, rg_reports rp
2211: WHERE rp.report_id = pn_csf_report_id
2212: AND rp.row_set_id = rs.axis_set_id;
2213: --COLUMN_SET_ID
2214: SELECT cs.axis_set_id

Line 2216: FROM rg_report_axis_sets cs, rg_reports rp

2212: AND rp.row_set_id = rs.axis_set_id;
2213: --COLUMN_SET_ID
2214: SELECT cs.axis_set_id
2215: INTO ln_clolumn_set_id
2216: FROM rg_report_axis_sets cs, rg_reports rp
2217: WHERE rp.report_id = pn_csf_report_id
2218: AND rp.column_set_id = cs.axis_set_id;
2219: --Unit of Measure ID/currency
2220: BEGIN

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

2219: --Unit of Measure ID/currency
2220: BEGIN
2221: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
2222: INTO lv_unit_of_measure_id
2223: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
2224: WHERE ldg.ledger_id = acc.default_ledger_id
2225: AND acc.access_set_id = pn_csf_report_id
2226: AND rp.report_id = pn_balance_sheet_id;
2227: 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 2247: FROM rg_reports

2243: -- Segment Override
2244: BEGIN
2245: SELECT segment_override
2246: INTO lv_segment_override
2247: FROM rg_reports
2248: WHERE report_id = pn_csf_report_id;
2249: EXCEPTION
2250: WHEN NO_DATA_FOUND THEN
2251: NULL;

Line 2257: FROM rg_report_content_sets cs, rg_reports rp

2253: --CONTENT_SET_ID
2254: BEGIN
2255: SELECT cs.content_set_id
2256: INTO ln_content_set_id
2257: FROM rg_report_content_sets cs, rg_reports rp
2258: WHERE rp.report_id = pn_csf_report_id
2259: AND rp.content_set_id = cs.content_set_id(+);
2260: EXCEPTION
2261: WHEN NO_DATA_FOUND THEN

Line 2268: FROM rg_row_orders ro, rg_reports rp

2264: --ROW_ORDER_ID
2265: BEGIN
2266: SELECT ro.row_order_id
2267: INTO ln_row_order_id
2268: FROM rg_row_orders ro, rg_reports rp
2269: WHERE rp.report_id = pn_csf_report_id
2270: AND rp.row_order_id = ro.row_order_id(+);
2271: EXCEPTION
2272: WHEN NO_DATA_FOUND THEN

Line 2279: FROM rg_report_display_sets ds, rg_reports rp

2275: --REPORT_DISPLAY_SET_ID
2276: BEGIN
2277: SELECT ds.report_display_set_id
2278: INTO ln_report_display_set_id
2279: FROM rg_report_display_sets ds, rg_reports rp
2280: WHERE rp.report_id = pn_csf_report_id
2281: AND rp.report_display_set_id = ds.report_display_set_id(+);
2282: EXCEPTION
2283: WHEN NO_DATA_FOUND THEN

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

Line 2302: FROM rg_reports rp

2298: --PARAMETER_SET_ID
2299: BEGIN
2300: SELECT rp.parameter_set_id
2301: INTO ln_parameter_set_id
2302: FROM rg_reports rp
2303: WHERE rp.report_id = pn_csf_report_id;
2304: EXCEPTION
2305: WHEN NO_DATA_FOUND THEN
2306: NULL;