APPS.JA_CN_FSG_XML_BANK_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 140

    SELECT row_set_id,
           column_set_id,
           unit_of_measure_id,
           content_set_id,
           row_order_id,
           rounding_option,
           parameter_set_id,
           minimum_display_level,
           report_display_set_id,
           output_option,
           name,
           segment_override
      INTO report_rec
      FROM RG_REPORTS
     WHERE REPORT_ID = X_REPORT_ID;

Line: 161

      SELECT report_run_type
        INTO rep_run_type
        FROM rg_report_content_sets
       WHERE content_set_id = X_content_set_id;

Line: 277

        UPDATE FND_CONCURRENT_REQUESTS
           SET OUTPUT_FILE_TYPE = 'XML'
         WHERE REQUEST_ID = req_id;

Line: 315

        UPDATE FND_CONCURRENT_REQUESTS
           SET OUTPUT_FILE_TYPE = 'XML'
         WHERE REQUEST_ID = req_id;

Line: 337

      SELECT lookup_code
        INTO lv_fsg_req_status_code
        FROM fnd_lookup_values
       WHERE lookup_type = 'CP_STATUS_CODE'
         AND view_application_id = 0
         AND security_group_id = 0
         AND meaning = lv_fsg_req_status
         AND enabled_flag = 'Y'
         AND language = USERENV('LANG');

Line: 630

      SELECT APP.APPLICATION_ID
        INTO l_template_appl
        FROM FND_APPLICATION_VL      APP,
             FND_CONCURRENT_PROGRAMS FCP,
             FND_CONCURRENT_REQUESTS R
       WHERE FCP.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
         AND R.REQUEST_ID = l_fsg_request_id
         AND APP.APPLICATION_ID = FCP.APPLICATION_ID;

Line: 731

      select application_column_name, default_value
        from FND_ID_FLEX_SEGMENTS_VL
       where id_flex_code = 'GL#'
         and id_flex_num = (select chart_of_accounts_id
                              from gl_ledgers
                             where ledger_id =P_LEDGER_ID);

Line: 743

    select chart_of_accounts_id
      into l_coa_id
      from gl_ledgers
     where ledger_id = P_LEDGER_ID;

Line: 747

    select fnd_flex_ext.get_delimiter('SQLGL',
                                  'GL#',
                                  l_coa_id
                                  ) into l_delimiter from dual;

Line: 751

     select segment_override
       into l_override
       from rg_reports rp
      where rp.report_id = P_REPORT_ID;

Line: 756

     SELECT fs.application_column_name
       into l_bsv_segment
       FROM FND_ID_FLEX_SEGMENTS_VL fs, fnd_segment_attribute_values av
      WHERE fs.application_column_name = av.application_column_name
        AND av.id_flex_code = 'GL#'
        AND fs.id_flex_code = av.id_flex_code
        AND av.id_flex_num = l_coa_id
        AND fs.application_id = 101
        AND fs.id_flex_num = av.id_flex_num
        AND av.segment_attribute_type in ('GL_BALANCING')
        AND av.attribute_value = 'Y';

Line: 805

     select unit_of_measure_id
       into l_fsg_currency
       from rg_reports rp
      where rp.report_id = P_REPORT_ID;

Line: 811

         select CURRENCY_CODE
           INTO l_fsg_currency
           from gl_ledgers
          where LEDGER_ID = P_LEDGER_ID
            and ledger_category_code = 'SECONDARY';

Line: 958

    SELECT rs.axis_set_id
      INTO ln_row_set_id
      FROM rg_report_axis_sets rs, rg_reports rp
     WHERE rp.report_id = pn_balance_sheet_id
       AND rp.row_set_id = rs.axis_set_id;

Line: 964

    SELECT cs.axis_set_id
      INTO ln_clolumn_set_id
      FROM rg_report_axis_sets cs, rg_reports rp
     WHERE rp.report_id = pn_balance_sheet_id
       AND rp.column_set_id = cs.axis_set_id;

Line: 974

        SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
          INTO lv_unit_of_measure_id
          FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
         WHERE ldg.ledger_id = acc.default_ledger_id
           AND acc.access_set_id = pn_data_access_set_id
           AND rp.report_id = pn_balance_sheet_id;

Line: 982

      select MEANING into lv_currency_unit
        from RG_REPORT_AXES rga, RG_LOOKUPS LK
       where LK.LOOKUP_CODE = rga.display_units
         and LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
         AND AXIS_SET_ID = ln_clolumn_set_id
         and rownum = 1
       ORDER BY AXIS_SEQ;

Line: 990

         SELECT LK.MEANING
           INTO lv_currency_unit
           FROM RG_LOOKUPS LK
          WHERE LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
            and LOOKUP_CODE = 0;

Line: 1002

      SELECT l.meaning
        INTO lv_rounding_option
        FROM rg_lookups l, rg_reports r
       WHERE r.report_id = pn_balance_sheet_id
         AND l.lookup_type = 'ROUNDING_OPTION'
         AND l.lookup_code = r.rounding_option;

Line: 1023

      SELECT cs.content_set_id
        INTO ln_content_set_id
        FROM rg_report_content_sets cs, rg_reports rp
       WHERE rp.report_id = pn_balance_sheet_id
         AND rp.content_set_id = cs.content_set_id(+);

Line: 1034

      SELECT ro.row_order_id
        INTO ln_row_order_id
        FROM rg_row_orders ro, rg_reports rp
       WHERE rp.report_id = pn_balance_sheet_id
         AND rp.row_order_id = ro.row_order_id(+);

Line: 1045

      SELECT ds.report_display_set_id
        INTO ln_report_display_set_id
        FROM rg_report_display_sets ds, rg_reports rp
       WHERE rp.report_id = pn_balance_sheet_id
         AND rp.report_display_set_id = ds.report_display_set_id(+);

Line: 1056

      SELECT lk.lookup_code
        INTO ln_minimum_display_level
        FROM rg_reports rp, rg_lookups lk
       WHERE rp.report_id = pn_balance_sheet_id
         AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
         AND lk.lookup_type = 'GL_DISPLAY_LEVEL';

Line: 1068

      SELECT rp.parameter_set_id
        INTO ln_parameter_set_id
        FROM rg_reports rp
       WHERE rp.report_id = pn_balance_sheet_id;

Line: 1112

      SELECT rs.axis_set_id
        INTO ln_row_set_id
        FROM rg_report_axis_sets rs, rg_reports rp
       WHERE rp.report_id = pn_profit_statement_id
         AND rp.row_set_id = rs.axis_set_id;

Line: 1118

      SELECT cs.axis_set_id
        INTO ln_clolumn_set_id
        FROM rg_report_axis_sets cs, rg_reports rp
       WHERE rp.report_id = pn_profit_statement_id
         AND rp.column_set_id = cs.axis_set_id;

Line: 1128

        SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
          INTO lv_unit_of_measure_id
          FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
         WHERE ldg.ledger_id = acc.default_ledger_id
           AND acc.access_set_id =   pn_data_access_set_id
           AND rp.report_id = pn_profit_statement_id;

Line: 1136

        select MEANING into lv_currency_unit
          from RG_REPORT_AXES rga, RG_LOOKUPS LK
         where LK.LOOKUP_CODE = rga.display_units
           and LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
           AND AXIS_SET_ID = ln_clolumn_set_id
           and rownum = 1
         ORDER BY AXIS_SEQ;

Line: 1144

           SELECT LK.MEANING
             INTO lv_currency_unit
             FROM RG_LOOKUPS LK
            WHERE LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
              and LOOKUP_CODE = 0;

Line: 1156

        SELECT l.meaning
          INTO lv_rounding_option
          FROM rg_lookups l, rg_reports r
         WHERE r.report_id = pn_profit_statement_id
           AND l.lookup_type = 'ROUNDING_OPTION'
           AND l.lookup_code = r.rounding_option;

Line: 1176

        SELECT cs.content_set_id
          INTO ln_content_set_id
          FROM rg_report_content_sets cs, rg_reports rp
         WHERE rp.report_id = pn_profit_statement_id
           AND rp.content_set_id = cs.content_set_id(+);

Line: 1187

        SELECT ro.row_order_id
          INTO ln_row_order_id
          FROM rg_row_orders ro, rg_reports rp
         WHERE rp.report_id = pn_profit_statement_id
           AND rp.row_order_id = ro.row_order_id(+);

Line: 1198

        SELECT ds.report_display_set_id
          INTO ln_report_display_set_id
          FROM rg_report_display_sets ds, rg_reports rp
         WHERE rp.report_id = pn_profit_statement_id
           AND rp.report_display_set_id = ds.report_display_set_id(+);

Line: 1209

        SELECT lk.lookup_code
          INTO ln_minimum_display_level
          FROM rg_reports rp, rg_lookups lk
         WHERE rp.report_id = pn_profit_statement_id
           AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
           AND lk.lookup_type = 'GL_DISPLAY_LEVEL';

Line: 1221

        SELECT rp.parameter_set_id
          INTO ln_parameter_set_id
          FROM rg_reports rp
         WHERE rp.report_id = pn_profit_statement_id;

Line: 1267

      SELECT rs.axis_set_id
        INTO ln_row_set_id
        FROM rg_report_axis_sets rs, rg_reports rp
       WHERE rp.report_id = pn_csf_report_id
         AND rp.row_set_id = rs.axis_set_id;

Line: 1273

      SELECT cs.axis_set_id
        INTO ln_clolumn_set_id
        FROM rg_report_axis_sets cs, rg_reports rp
       WHERE rp.report_id = pn_csf_report_id
         AND rp.column_set_id = cs.axis_set_id;

Line: 1283

        SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
          INTO lv_unit_of_measure_id
          FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
         WHERE ldg.ledger_id = acc.default_ledger_id
           AND acc.access_set_id =  pn_data_access_set_id
           AND rp.report_id = pn_csf_report_id;

Line: 1291

        select MEANING into lv_currency_unit
          from RG_REPORT_AXES rga, RG_LOOKUPS LK
         where LK.LOOKUP_CODE = rga.display_units
           and LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
           AND AXIS_SET_ID = ln_clolumn_set_id
           and rownum = 1
         ORDER BY AXIS_SEQ;

Line: 1299

           SELECT LK.MEANING
             INTO lv_currency_unit
             FROM RG_LOOKUPS LK
            WHERE LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
              and LOOKUP_CODE = 0;

Line: 1311

        SELECT l.meaning
          INTO lv_rounding_option
          FROM rg_lookups l, rg_reports r
         WHERE r.report_id = pn_csf_report_id
           AND l.lookup_type = 'ROUNDING_OPTION'
           AND l.lookup_code = r.rounding_option;

Line: 1331

        SELECT cs.content_set_id
          INTO ln_content_set_id
          FROM rg_report_content_sets cs, rg_reports rp
         WHERE rp.report_id = pn_csf_report_id
           AND rp.content_set_id = cs.content_set_id(+);

Line: 1342

        SELECT ro.row_order_id
          INTO ln_row_order_id
          FROM rg_row_orders ro, rg_reports rp
         WHERE rp.report_id = pn_csf_report_id
           AND rp.row_order_id = ro.row_order_id(+);

Line: 1353

        SELECT ds.report_display_set_id
          INTO ln_report_display_set_id
          FROM rg_report_display_sets ds, rg_reports rp
         WHERE rp.report_id = pn_csf_report_id
           AND rp.report_display_set_id = ds.report_display_set_id(+);

Line: 1364

        SELECT lk.lookup_code
          INTO ln_minimum_display_level
          FROM rg_reports rp, rg_lookups lk
         WHERE rp.report_id = pn_csf_report_id
           AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
           AND lk.lookup_type = 'GL_DISPLAY_LEVEL';

Line: 1376

        SELECT rp.parameter_set_id
          INTO ln_parameter_set_id
          FROM rg_reports rp
         WHERE rp.report_id = pn_csf_report_id;

Line: 1422

      SELECT rs.axis_set_id
        INTO ln_row_set_id
        FROM rg_report_axis_sets rs, rg_reports rp
       WHERE rp.report_id = pn_owners_equity_id
         AND rp.row_set_id = rs.axis_set_id;

Line: 1428

      SELECT cs.axis_set_id
        INTO ln_clolumn_set_id
        FROM rg_report_axis_sets cs, rg_reports rp
       WHERE rp.report_id = pn_owners_equity_id
         AND rp.column_set_id = cs.axis_set_id;

Line: 1438

        SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
          INTO lv_unit_of_measure_id
          FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
         WHERE ldg.ledger_id = acc.default_ledger_id
           AND acc.access_set_id =  pn_data_access_set_id
           AND rp.report_id = pn_owners_equity_id;

Line: 1446

        select MEANING into lv_currency_unit
          from RG_REPORT_AXES rga, RG_LOOKUPS LK
         where LK.LOOKUP_CODE = rga.display_units
           and LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
           AND AXIS_SET_ID = ln_clolumn_set_id
           and rownum = 1
         ORDER BY AXIS_SEQ;

Line: 1454

           SELECT LK.MEANING
             INTO lv_currency_unit
             FROM RG_LOOKUPS LK
            WHERE LK.LOOKUP_TYPE = 'DISPLAY_UNITS'
              and LOOKUP_CODE = 0;

Line: 1466

        SELECT l.meaning
          INTO lv_rounding_option
          FROM rg_lookups l, rg_reports r
         WHERE r.report_id = pn_owners_equity_id
           AND l.lookup_type = 'ROUNDING_OPTION'
           AND l.lookup_code = r.rounding_option;

Line: 1486

        SELECT cs.content_set_id
          INTO ln_content_set_id
          FROM rg_report_content_sets cs, rg_reports rp
         WHERE rp.report_id = pn_owners_equity_id
           AND rp.content_set_id = cs.content_set_id(+);

Line: 1497

        SELECT ro.row_order_id
          INTO ln_row_order_id
          FROM rg_row_orders ro, rg_reports rp
         WHERE rp.report_id = pn_owners_equity_id
           AND rp.row_order_id = ro.row_order_id(+);

Line: 1508

        SELECT ds.report_display_set_id
          INTO ln_report_display_set_id
          FROM rg_report_display_sets ds, rg_reports rp
         WHERE rp.report_id = pn_owners_equity_id
           AND rp.report_display_set_id = ds.report_display_set_id(+);

Line: 1519

        SELECT lk.lookup_code
          INTO ln_minimum_display_level
          FROM rg_reports rp, rg_lookups lk
         WHERE rp.report_id = pn_owners_equity_id
           AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
           AND lk.lookup_type = 'GL_DISPLAY_LEVEL';

Line: 1531

        SELECT rp.parameter_set_id
          INTO ln_parameter_set_id
          FROM rg_reports rp
         WHERE rp.report_id = pn_owners_equity_id;

Line: 1600

          SELECT lookup_code
            INTO lv_convert_req_status_code
            FROM fnd_lookup_values
           WHERE lookup_type = 'CP_STATUS_CODE'
             AND view_application_id = 0
             AND security_group_id = 0
             AND meaning = lv_convert_req_status
             AND enabled_flag = 'Y'
             AND language = USERENV('LANG');