APPS.JA_CN_UDRV_EXPORT SQL Statements

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

Line: 80

SELECT
  subsidiary_segment_code
, sources_code
, context_code
FROM
  ja_cn_sub_acc_mapping
WHERE chart_of_accounts_id = pn_coa_id
  AND sources_code in ('COA', 'PROJECT MODULE')
--choli add to fix bug 12392517
ORDER BY subsidiary_segment_code;

Line: 97

SELECT
  distinct decode(lv_sub_segment_code,
                    'SEGMENT1',jcjl.segment1, 'SEGMENT2',jcjl.segment2, 'SEGMENT3',jcjl.segment3,
                    'SEGMENT4',jcjl.segment4, 'SEGMENT5',jcjl.segment5, 'SEGMENT6',jcjl.segment6,
                    'SEGMENT7',jcjl.segment7, 'SEGMENT8',jcjl.segment8, 'SEGMENT9',jcjl.segment9,
                    'SEGMENT10',jcjl.segment10, 'SEGMENT11',jcjl.segment11, 'SEGMENT12',jcjl.segment12,
                    'SEGMENT13',jcjl.segment13, 'SEGMENT14',jcjl.segment14, 'SEGMENT15',jcjl.segment15,
                    'SEGMENT16',jcjl.segment16, 'SEGMENT17',jcjl.segment17, 'SEGMENT18',jcjl.segment18,
                    'SEGMENT19',jcjl.segment19, 'SEGMENT20',jcjl.segment20, 'SEGMENT21',jcjl.segment21,
                    'SEGMENT22',jcjl.segment22, 'SEGMENT23',jcjl.segment23, 'SEGMENT24',jcjl.segment24,
                    'SEGMENT25',jcjl.segment25, 'SEGMENT26',jcjl.segment26, 'SEGMENT27',jcjl.segment27,
                    'SEGMENT28',jcjl.segment28, 'SEGMENT29',jcjl.segment29, 'SEGMENT30',jcjl.segment30) value_number
, ffvt.description
FROM
  ja_cn_journal_lines jcjl
, gl_ledgers gl, gl_periods gp
, fnd_flex_values_tl ffvt
, fnd_flex_values ffv
, fnd_id_flex_segments fifs
, ja_cn_voucher_number jcvn
WHERE fifs.id_flex_num = pn_coa_id
  AND fifs.id_flex_code = 'GL#'
  AND fifs.application_column_name = lv_context_code
  AND fifs.flex_value_set_id = ffv.flex_value_set_id
  AND gl.ledger_id = pn_ledger_id
  AND gl.period_set_name = gp.period_set_name
  AND gp.period_name = jcjl.period_name
  --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
  --Add ja_cn_voucher_number table, voucher number and legal entity
  --are fetched from ja_cn_voucher_number
  --The new one is
  ----------------------------------------------------
  --AND jcvn.je_header_id = jl.je_header_id
  --AND jcvn.je_line_number = jl.je_line_num
  --AND jcvn.legal_entity_id = pn_le_id;

Line: 163

SELECT
  distinct decode(lv_sub_segment_code,
              'SEGMENT1',jcjl.segment1, 'SEGMENT2',jcjl.segment2, 'SEGMENT3',jcjl.segment3,
              'SEGMENT4',jcjl.segment4, 'SEGMENT5',jcjl.segment5, 'SEGMENT6',jcjl.segment6,
              'SEGMENT7',jcjl.segment7, 'SEGMENT8',jcjl.segment8, 'SEGMENT9',jcjl.segment9,
              'SEGMENT10',jcjl.segment10, 'SEGMENT11',jcjl.segment11, 'SEGMENT12',jcjl.segment12,
              'SEGMENT13',jcjl.segment13, 'SEGMENT14',jcjl.segment14, 'SEGMENT15',jcjl.segment15,
              'SEGMENT16',jcjl.segment16, 'SEGMENT17',jcjl.segment17, 'SEGMENT18',jcjl.segment18,
              'SEGMENT19',jcjl.segment19, 'SEGMENT20',jcjl.segment20, 'SEGMENT21',jcjl.segment21,
              'SEGMENT22',jcjl.segment22, 'SEGMENT23',jcjl.segment23, 'SEGMENT24',jcjl.segment24,
              'SEGMENT25',jcjl.segment25, 'SEGMENT26',jcjl.segment26, 'SEGMENT27',jcjl.segment27,
              'SEGMENT28',jcjl.segment28, 'SEGMENT29',jcjl.segment29, 'SEGMENT30',jcjl.segment30) value_number
, ppa.name,ppa.description
FROM
  ja_cn_journal_lines jcjl
, gl_ledgers gl
, gl_periods gp
, pa_projects_all ppa
, ja_cn_voucher_number jcvn
WHERE gl.ledger_id = pn_ledger_id
  --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
  --Add ja_cn_voucher_number table, voucher number and legal entity
  --are fetched from ja_cn_voucher_number
  --The new one is
  ----------------------------------------------------
  --AND jcvn.je_header_id = jl.je_header_id
  --AND jcvn.je_line_number = jl.je_line_num
  --AND jcvn.legal_entity_id = pn_le_id;

Line: 243

  SELECT count(*)
    INTO ln_journal_number
    FROM (SELECT DISTINCT * --Add by Jianchao Chi, 10-Jan-2011, for one hearder may has two same
            FROM ja_cn_journal_lines jl,                  --line numbers in ja_cn_journal_lines.
                 gl_ledgers           gl,
                 gl_periods           gp,
                 ja_cn_voucher_number jcvn
          --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
          --Add ja_cn_voucher_number table, voucher number and legal entity
          --are fetched from ja_cn_voucher_number
          --The new one is
          ----------------------------------------------------
          --AND jcvn.je_header_id = jl.je_header_id
          --AND jcvn.je_line_number = jl.je_line_num
          --AND jcvn.legal_entity_id = pn_le_id;

Line: 294

      SELECT substr(lv_sub_segment_code,8,1)
      INTO ln_record_number
      FROM dual;

Line: 300

        SELECT substr(lv_sub_segment_code,8,2)
        INTO ln_record_number
        FROM dual;