GL Turnover for Selected Segments

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Turnover for Selected Segments Report
Short Name: GLXSSEGR
DB package: GL_SEL_SEG_TURNOVER_RPT_PKG
SELECT gjl.effective_date          jrnl_effective_date
      ,gjh.doc_sequence_value      jrnl_doc_seq_num
      ,gjs.user_je_source_name     jrnl_source
      ,&gc_int_doc_num             internal_doc_num
      ,fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE')                acct
      ,gjl.entered_cr              jrnl_line_ent_cr
      ,gjl.entered_dr              jrnl_line_ent_dr
      ,gjl.accounted_cr            jrnl_line_cr
      ,gjl.accounted_dr            jrnl_line_dr
      ,gjh.currency_code           jrnl_currency_code
      ,gjc.user_je_category_name   jrnl_category
      ,gjb.name                    batch_name
      ,gjh.name                    jrnl_name
      ,gjl.je_line_num             jrnl_line_number
      ,gjl.description             jrnl_line_desc
FROM   gl_je_headers            gjh
      ,gl_je_lines              gjl
      ,gl_je_sources            gjs
      ,gl_je_categories         gjc
      ,gl_je_batches            gjb
      ,gl_code_combinations     gcc
      ,gl_period_statuses       gps
WHERE  gcc.code_combination_id   = gjl.code_combination_id
AND    gjl.je_header_id          = gjh.je_header_id
AND    gjh.je_source             = gjs.je_source_name
AND    gjh.je_category           = gjc.je_category_name
AND    gjh.je_batch_id           = gjb.je_batch_id
AND    fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_account', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE')             = :ACCT_VALUE
AND    &FLEX_OWNER               = :ADDITIONAL_SEGMENT_VALUE1
AND    NVL(&FLEX_SUBORD,-1)      = NVL(:ADDITIONAL_SEGMENT_VALUE2,-1)
AND    gjh.period_name           = gps.period_name
AND    gjh.ledger_id             = gps.ledger_id
AND    gjh.je_header_id          = gjl.je_header_id
AND    gjh.ledger_id             = :LEDGER_ID_PARAM
AND    gjh.actual_flag           = :BALANCE_TYPE_PARAM
AND    (gjl.accounted_dr         IS NOT NULL
     OR gjl.accounted_cr         IS NOT NULL)
AND    (gjl.accounted_dr         <> 0
     OR gjl.accounted_cr         <> 0)
AND    gps.application_id        = 101
AND    gjh.status                = 'P'
AND    gjb.average_journal_flag  = 'N'
AND    gcc.chart_of_accounts_id  = :COA_ID_PARAM
AND    :PRINT_JRNL_DETAIL_PARAM  = 'Y'
AND    gps.effective_period_num  BETWEEN &gc_per_eff_from_num
                                 AND     &gc_per_eff_to_num
AND    &GC_DAS_JE_WHERE
AND    &GC_CURRENCY_WHERE
AND    &GC_BALANCE_WHERE
AND    &FLEX_WHERE
Parameter NameSQL textValidation
GL_SRS_COA_UNVALIDATED
 
Number
Access Set ID
 
Number
Print Journal Detail
 
LOV Oracle
Print Internal Document Number
 
LOV Oracle
Account To
 
Account From
 
Subordinated Segment
 
LOV Oracle
Owner Segment
 
LOV Oracle
Period To
 
LOV Oracle
Period From
 
LOV Oracle
Budget or Encumbrance Name
 
LOV Oracle
Balance Type
 
LOV Oracle
Entered Currency
 
LOV Oracle
Currency Type
 
LOV Oracle
Ledger Currency
 
LOV Oracle
Ledger / Ledger Set
 
LOV Oracle