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.XLA_TB_AP_REPORT_PVT SQL Statements

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

Line: 14


SELECT
      gcck.concatenated_segments           ACCOUNT
     ,$gl_balance_cols$                    GL_BALANCE
     ,tbg.code_combination_id              CODE_COMBINATION_ID
     ,tbg.balancing_segment_value          BALANCING_SEGMENT_VALUE
     ,tbg.natural_account_segment_value    NATURAL_ACCOUNT_SEGMENT_VALUE
     ,tbg.cost_center_segment_value        COST_CENTER_SEGMENT_VALUE
     ,tbg.management_segment_value         MANAGEMENT_SEGMENT_VALUE
     ,tbg.intercompany_segment_value       INTERCOMPANY_SEGMENT_VALUE
     ,tbg.ledger_id                        LEDGER_ID
     ,tbg.ledger_name                      LEDGER_NAME
     ,tbg.ledger_short_name                LEDGER_SHORT_NAME
     ,tbg.ledger_currency_code             LEDGER_CURRENCY_CODE
     ,tbg.third_party_name                 THIRD_PARTY_NAME
     ,tbg.third_party_number               THIRD_PARTY_NUMBER
     ,tbg.third_party_type_code            THIRD_PARTY_TYPE_CODE
     ,tbg.third_party_type                 THIRD_PARTY_TYPE
     ,tbg.third_party_site_name            THIRD_PARTY_SITE_NAME
     ,tbg.source_application_id            SOURCE_TRX_APPLICATION_ID
     ,tbg.source_entity_id                 SOURCE_ENTITY_ID
     ,app.application_name                 SOURCE_TRX_APPLICATION_NAME
     ,ett.name                             SOURCE_TRX_TYPE
     ,tbg.transaction_number               SOURCE_TRX_NUMBER
     ,to_char(tbg.gl_date,''YYYY-MM-DD'')  SOURCE_TRX_GL_DATE
     ,tbg.trx_currency_code                SOURCE_TRX_CURR
     ,tbg.entered_unrounded_orig_amount    SRC_ENTERED_UNROUNDED_ORIG_AMT
     ,tbg.entered_unrounded_rem_amount     SRC_ENTERED_UNROUNDED_REM_AMT
     ,tbg.entered_rounded_orig_amount      SRC_ENTERED_ROUNDED_ORIG_AMT
     ,tbg.entered_rounded_rem_amount       SRC_ENTERED_ROUNDED_REM_AMT
     ,tbg.acctd_unrounded_orig_amount      SRC_ACCTD_UNROUNDED_ORIG_AMT
     ,tbg.acctd_unrounded_rem_amount       SRC_ACCTD_UNROUNDED_REM_AMT
     ,tbg.acctd_rounded_orig_amount        SRC_ACCTD_ROUNDED_ORIG_AMT
     ,tbg.acctd_rounded_rem_amount         SRC_ACCTD_ROUNDED_REM_AMT
     ,tbg.user_trx_identifier_name_1       USER_TRX_IDENTIFIER_NAME_1
     ,tbg.user_trx_identifier_name_2       USER_TRX_IDENTIFIER_NAME_2
     ,tbg.user_trx_identifier_name_3       USER_TRX_IDENTIFIER_NAME_3
     ,tbg.user_trx_identifier_name_4       USER_TRX_IDENTIFIER_NAME_4
     ,tbg.user_trx_identifier_name_5       USER_TRX_IDENTIFIER_NAME_5
     ,tbg.user_trx_identifier_name_6       USER_TRX_IDENTIFIER_NAME_6
     ,tbg.user_trx_identifier_name_7       USER_TRX_IDENTIFIER_NAME_7
     ,tbg.user_trx_identifier_name_8       USER_TRX_IDENTIFIER_NAME_8
     ,tbg.user_trx_identifier_name_9       USER_TRX_IDENTIFIER_NAME_9
     ,tbg.user_trx_identifier_name_10      USER_TRX_IDENTIFIER_NAME_10
     ,tbg.user_trx_identifier_value_1      USER_TRX_IDENTIFIER_VALUE_1
     ,tbg.user_trx_identifier_value_2      USER_TRX_IDENTIFIER_VALUE_2
     ,tbg.user_trx_identifier_value_3      USER_TRX_IDENTIFIER_VALUE_3
     ,tbg.user_trx_identifier_value_4      USER_TRX_IDENTIFIER_VALUE_4
     ,tbg.user_trx_identifier_value_5      USER_TRX_IDENTIFIER_VALUE_5
     ,tbg.user_trx_identifier_value_6      USER_TRX_IDENTIFIER_VALUE_6
     ,tbg.user_trx_identifier_value_7      USER_TRX_IDENTIFIER_VALUE_7
     ,tbg.user_trx_identifier_value_8      USER_TRX_IDENTIFIER_VALUE_8
     ,tbg.user_trx_identifier_value_9      USER_TRX_IDENTIFIER_VALUE_9
     ,tbg.user_trx_identifier_value_10     USER_TRX_IDENTIFIER_VALUE_10
$seg_desc_cols$
FROM   xla_trial_balances_gt            tbg
     ,fnd_application_vl                app
     ,xla_entity_types_vl               ett
     ,gl_code_combinations_kfv          gcck
     ,gl_balances                       gb
     $seg_desc_from$
WHERE  tbg.source_entity_code          = ett.entity_code
  AND tbg.source_application_id       = ett.application_id
  AND tbg.source_application_id       = app.application_id
  AND tbg.code_combination_id         = gcck.code_combination_id
 $gl_balance_join$
$seg_desc_join$
 ';

Line: 83


SELECT
      gcck.concatenated_segments           ACCOUNT
     ,$gl_balance_cols$                    GL_BALANCE
     ,tbg.code_combination_id              CODE_COMBINATION_ID
     ,tbg.balancing_segment_value          BALANCING_SEGMENT_VALUE
     ,tbg.natural_account_segment_value    NATURAL_ACCOUNT_SEGMENT_VALUE
     ,tbg.cost_center_segment_value        COST_CENTER_SEGMENT_VALUE
     ,tbg.management_segment_value         MANAGEMENT_SEGMENT_VALUE
     ,tbg.intercompany_segment_value       INTERCOMPANY_SEGMENT_VALUE
     ,tbg.ledger_id                        LEDGER_ID
     ,tbg.ledger_name                      LEDGER_NAME
     ,tbg.ledger_short_name                LEDGER_SHORT_NAME
     ,tbg.ledger_currency_code             LEDGER_CURRENCY_CODE
     ,tbg.third_party_name                 THIRD_PARTY_NAME
     ,tbg.third_party_number               THIRD_PARTY_NUMBER
     ,tbg.third_party_type_code            THIRD_PARTY_TYPE_CODE
     ,tbg.third_party_type                 THIRD_PARTY_TYPE
     ,tbg.third_party_site_name            THIRD_PARTY_SITE_NAME
     ,tbg.source_application_id            SOURCE_TRX_APPLICATION_ID
     ,tbg.source_entity_id                 SOURCE_ENTITY_ID
     ,app.application_name                 SOURCE_TRX_APPLICATION_NAME
     ,''$write_off$''                      SOURCE_TRX_TYPE
     ,tbg.transaction_number               SOURCE_TRX_NUMBER
     ,to_char(tbg.gl_date,''YYYY-MM-DD'')  SOURCE_TRX_GL_DATE
     ,tbg.trx_currency_code                SOURCE_TRX_CURR
     ,tbg.entered_unrounded_orig_amount    SRC_ENTERED_UNROUNDED_ORIG_AMT
     ,tbg.entered_unrounded_rem_amount     SRC_ENTERED_UNROUNDED_REM_AMT
     ,tbg.entered_rounded_orig_amount      SRC_ENTERED_ROUNDED_ORIG_AMT
     ,tbg.entered_rounded_rem_amount       SRC_ENTERED_ROUNDED_REM_AMT
     ,tbg.acctd_unrounded_orig_amount      SRC_ACCTD_UNROUNDED_ORIG_AMT
     ,tbg.acctd_unrounded_rem_amount       SRC_ACCTD_UNROUNDED_REM_AMT
     ,tbg.acctd_rounded_orig_amount        SRC_ACCTD_ROUNDED_ORIG_AMT
     ,tbg.acctd_rounded_rem_amount         SRC_ACCTD_ROUNDED_REM_AMT
     ,tbg.user_trx_identifier_name_1       USER_TRX_IDENTIFIER_NAME_1
     ,tbg.user_trx_identifier_name_2       USER_TRX_IDENTIFIER_NAME_2
     ,tbg.user_trx_identifier_name_3       USER_TRX_IDENTIFIER_NAME_3
     ,tbg.user_trx_identifier_name_4       USER_TRX_IDENTIFIER_NAME_4
     ,tbg.user_trx_identifier_name_5       USER_TRX_IDENTIFIER_NAME_5
     ,tbg.user_trx_identifier_name_6       USER_TRX_IDENTIFIER_NAME_6
     ,tbg.user_trx_identifier_name_7       USER_TRX_IDENTIFIER_NAME_7
     ,tbg.user_trx_identifier_name_8       USER_TRX_IDENTIFIER_NAME_8
     ,tbg.user_trx_identifier_name_9       USER_TRX_IDENTIFIER_NAME_9
     ,tbg.user_trx_identifier_name_10      USER_TRX_IDENTIFIER_NAME_10
     ,tbg.user_trx_identifier_value_1      USER_TRX_IDENTIFIER_VALUE_1
     ,tbg.user_trx_identifier_value_2      USER_TRX_IDENTIFIER_VALUE_2
     ,tbg.user_trx_identifier_value_3      USER_TRX_IDENTIFIER_VALUE_3
     ,tbg.user_trx_identifier_value_4      USER_TRX_IDENTIFIER_VALUE_4
     ,tbg.user_trx_identifier_value_5      USER_TRX_IDENTIFIER_VALUE_5
     ,tbg.user_trx_identifier_value_6      USER_TRX_IDENTIFIER_VALUE_6
     ,tbg.user_trx_identifier_value_7      USER_TRX_IDENTIFIER_VALUE_7
     ,tbg.user_trx_identifier_value_8      USER_TRX_IDENTIFIER_VALUE_8
     ,tbg.user_trx_identifier_value_9      USER_TRX_IDENTIFIER_VALUE_9
     ,tbg.user_trx_identifier_value_10     USER_TRX_IDENTIFIER_VALUE_10
     $seg_desc_cols$
 FROM xla_trial_balances_gt    tbg
     ,fnd_application_vl       app
     ,gl_code_combinations_kfv gcck
     ,gl_balances              gb
     $seg_desc_from$
WHERE tbg.record_type_code            = ''SOURCE''
  AND tbg.source_application_id       = app.application_id
  AND tbg.code_combination_id         = gcck.code_combination_id
  AND tbg.acctd_rounded_rem_amount    <> 0
  AND tbg.acctd_unrounded_rem_amount  = 0
$gl_balance_join$
$seg_desc_join$
 ';

Line: 152


SELECT
      tbg.third_party_name                 THIRD_PARTY_NAME
     ,tbg.third_party_number               THIRD_PARTY_NUMBER
     ,tbg.third_party_type_code            THIRD_PARTY_TYPE_CODE
     ,tbg.third_party_type                 THIRD_PARTY_TYPE
     ,tbg.third_party_site_name            THIRD_PARTY_SITE_NAME
     ,tbg.applied_to_entity_id             APPLIED_TO_ENTITY_ID
     ,tbg.source_application_id            APPLIED_TRX_APPLICATION_ID
     ,app.application_name                 APPLIED_TRX_APPLICATION_NAME
     ,ett.name                             APPLIED_TRX_TYPE
     ,tbg.transaction_number               APPLIED_TRX_NUMBER
     ,tbg.gl_date                          APPLIED_TRX_GL_DATE
     ,tbg.trx_currency_code                APPLIED_TRX_CURR
     ,tbg.entered_unrounded_orig_amount    APPLIED_ENTERED_UNROUNDED_AMT
     ,tbg.entered_rounded_orig_amount      APPLIED_ENTERED_ROUNDED_AMT
     ,tbg.acctd_unrounded_orig_amount      APPLIED_ACCTD_UNROUNDED_AMT
     ,tbg.acctd_rounded_orig_amount        APPLIED_ACCTD_ROUNDED_AMT
     ,tbg.user_trx_identifier_name_1       APPLIED_TRX_IDENTIFIER_NAME_1
     ,tbg.user_trx_identifier_name_2       APPLIED_TRX_IDENTIFIER_NAME_2
     ,tbg.user_trx_identifier_name_3       APPLIED_TRX_IDENTIFIER_NAME_3
     ,tbg.user_trx_identifier_name_4       APPLIED_TRX_IDENTIFIER_NAME_4
     ,tbg.user_trx_identifier_name_5       APPLIED_TRX_IDENTIFIER_NAME_5
     ,tbg.user_trx_identifier_name_6       APPLIED_TRX_IDENTIFIER_NAME_6
     ,tbg.user_trx_identifier_name_7       APPLIED_TRX_IDENTIFIER_NAME_7
     ,tbg.user_trx_identifier_name_8       APPLIED_TRX_IDENTIFIER_NAME_8
     ,tbg.user_trx_identifier_name_9       APPLIED_TRX_IDENTIFIER_NAME_9
     ,tbg.user_trx_identifier_name_10      APPLIED_TRX_IDENTIFIER_NAME_10
     ,tbg.user_trx_identifier_value_1      APPLIED_TRX_IDENTIFIER_VAL_1
     ,tbg.user_trx_identifier_value_2      APPLIED_TRX_IDENTIFIER_VAL_2
     ,tbg.user_trx_identifier_value_3      APPLIED_TRX_IDENTIFIER_VAL_3
     ,tbg.user_trx_identifier_value_4      APPLIED_TRX_IDENTIFIER_VAL_4
     ,tbg.user_trx_identifier_value_5      APPLIED_TRX_IDENTIFIER_VAL_5
     ,tbg.user_trx_identifier_value_6      APPLIED_TRX_IDENTIFIER_VAL_6
     ,tbg.user_trx_identifier_value_7      APPLIED_TRX_IDENTIFIER_VAL_7
     ,tbg.user_trx_identifier_value_8      APPLIED_TRX_IDENTIFIER_VAL_8
     ,tbg.user_trx_identifier_value_9      APPLIED_TRX_IDENTIFIER_VAL_9
     ,tbg.user_trx_identifier_value_10     APPLIED_TRX_IDENTIFIER_VAL_10
FROM  xla_trial_balances_gt     tbg
     ,fnd_application_vl       app
     ,xla_entity_types_vl      ett
WHERE tbg.source_entity_code          = ett.entity_code
  AND tbg.source_application_id       = ett.application_id
  AND tbg.source_application_id       = app.application_id
  AND tbg.record_type_code            = ''APPLIED''
  AND tbg.applied_to_entity_id        = :SOURCE_ENTITY_ID
';*/

Line: 201


               SELECT/*+ index(tbg XLA_TRIAL_BALANCES_GT_N1)*/
                      tbg.third_party_name                 THIRD_PARTY_NAME
                     ,tbg.third_party_number               THIRD_PARTY_NUMBER
                     ,tbg.third_party_type_code            THIRD_PARTY_TYPE_CODE
                     ,tbg.third_party_type                 THIRD_PARTY_TYPE
                     ,tbg.third_party_site_name            THIRD_PARTY_SITE_NAME
                     ,tbg.applied_to_entity_id             APPLIED_TO_ENTITY_ID
                     ,tbg.source_application_id            APPLIED_TRX_APPLICATION_ID
                     ,app.application_name                 APPLIED_TRX_APPLICATION_NAME
                     ,ett.name                             APPLIED_TRX_TYPE
                     ,tbg.transaction_number               APPLIED_TRX_NUMBER
                     ,tbg.gl_date                          APPLIED_TRX_GL_DATE

                     ,tbg.trx_currency_code                APPLIED_TRX_CURR
                     ,tbg.entered_unrounded_orig_amount    APPLIED_ENTERED_UNROUNDED_AMT
                     ,tbg.entered_rounded_orig_amount      APPLIED_ENTERED_ROUNDED_AMT
                     ,tbg.acctd_unrounded_orig_amount      APPLIED_ACCTD_UNROUNDED_AMT
                     ,tbg.acctd_rounded_orig_amount        APPLIED_ACCTD_ROUNDED_AMT
                     ,tbg.user_trx_identifier_name_1       APPLIED_TRX_IDENTIFIER_NAME_1
                     ,tbg.user_trx_identifier_name_2       APPLIED_TRX_IDENTIFIER_NAME_2
                     ,tbg.user_trx_identifier_name_3       APPLIED_TRX_IDENTIFIER_NAME_3
                     ,tbg.user_trx_identifier_name_4       APPLIED_TRX_IDENTIFIER_NAME_4
                     ,tbg.user_trx_identifier_name_5       APPLIED_TRX_IDENTIFIER_NAME_5
                     ,tbg.user_trx_identifier_name_6       APPLIED_TRX_IDENTIFIER_NAME_6
                     ,tbg.user_trx_identifier_name_7       APPLIED_TRX_IDENTIFIER_NAME_7
                     ,tbg.user_trx_identifier_name_8       APPLIED_TRX_IDENTIFIER_NAME_8
                     ,tbg.user_trx_identifier_name_9       APPLIED_TRX_IDENTIFIER_NAME_9
                     ,tbg.user_trx_identifier_name_10      APPLIED_TRX_IDENTIFIER_NAME_10
                     ,tbg.user_trx_identifier_value_1      APPLIED_TRX_IDENTIFIER_VAL_1
                     ,tbg.user_trx_identifier_value_2      APPLIED_TRX_IDENTIFIER_VAL_2
                     ,tbg.user_trx_identifier_value_3      APPLIED_TRX_IDENTIFIER_VAL_3
                     ,tbg.user_trx_identifier_value_4      APPLIED_TRX_IDENTIFIER_VAL_4
                     ,tbg.user_trx_identifier_value_5      APPLIED_TRX_IDENTIFIER_VAL_5
                     ,tbg.user_trx_identifier_value_6      APPLIED_TRX_IDENTIFIER_VAL_6
                     ,tbg.user_trx_identifier_value_7      APPLIED_TRX_IDENTIFIER_VAL_7
                     ,tbg.user_trx_identifier_value_8      APPLIED_TRX_IDENTIFIER_VAL_8
                     ,tbg.user_trx_identifier_value_9      APPLIED_TRX_IDENTIFIER_VAL_9
                     ,tbg.user_trx_identifier_value_10     APPLIED_TRX_IDENTIFIER_VAL_10
                 FROM xla_trial_balances_gt    tbg
                     ,fnd_application_vl       app
                     ,xla_entity_types_vl      ett
                WHERE tbg.source_entity_code          = ett.entity_code
                  AND tbg.source_application_id       = ett.application_id
                  AND tbg.source_application_id       = app.application_id
                  AND tbg.record_type_code            = ''APPLIED''
                  AND tbg.code_combination_id         = :CODE_COMBINATION_ID
                  AND tbg.applied_to_entity_id        = :SOURCE_ENTITY_ID
';

Line: 252


SELECT
      gcck.concatenated_segments           ACCOUNT
     ,$gl_balance_cols$                    GL_BALANCE
     ,tb.code_combination_id               CODE_COMBINATION_ID
     ,tb.balancing_segment_value           BALANCING_SEGMENT_VALUE
     ,tb.natural_account_segment_value     NATURAL_ACCOUNT_SEGMENT_VALUE
     ,tb.cost_center_segment_value         COST_CENTER_SEGMENT_VALUE
     ,tb.management_segment_value          MANAGEMENT_SEGMENT_VALUE
     ,tb.intercompany_segment_value        INTERCOMPANY_SEGMENT_VALUE
     ,$ledger_cols$
     ,NULL                                 THIRD_PARTY_NAME
     ,NULL                                 THIRD_PARTY_NUMBER
     ,NULL                                 THIRD_PARTY_TYPE_CODE
     ,NULL                                 THIRD_PARTY_TYPE
     ,NULL                                 THIRD_PARTY_SITE_NAME
     ,tb.source_application_id             SOURCE_TRX_APPLICATION_ID
     ,tb.source_entity_id                  SOURCE_ENTITY_ID
     ,app.application_name                 SOURCE_TRX_APPLICATION_NAME
     ,''$initial_balance$''                SOURCE_TRX_TYPE
     ,NULL                                 SOURCE_TRX_NUMBER
     ,to_char(tb.gl_date,''YYYY-MM-DD'')   SOURCE_TRX_GL_DATE
     ,tb.trx_currency_code                 SOURCE_TRX_CURR
     ,$amount_cols$
     ,NULL                                 USER_TRX_IDENTIFIER_NAME_1
     ,NULL                                 USER_TRX_IDENTIFIER_NAME_2
     ,NULL                                 USER_TRX_IDENTIFIER_NAME_3
     ,NULL                                 USER_TRX_IDENTIFIER_NAME_4
     ,NULL                                 USER_TRX_IDENTIFIER_NAME_5
     ,NULL                                 USER_TRX_IDENTIFIER_NAME_6
     ,NULL                                 USER_TRX_IDENTIFIER_NAME_7
     ,NULL                                 USER_TRX_IDENTIFIER_NAME_8
     ,NULL                                 USER_TRX_IDENTIFIER_NAME_9
     ,NULL                                 USER_TRX_IDENTIFIER_NAME_10
     ,NULL                                 USER_TRX_IDENTIFIER_VALUE_1
     ,NULL                                 USER_TRX_IDENTIFIER_VALUE_2
     ,NULL                                 USER_TRX_IDENTIFIER_VALUE_3
     ,NULL                                 USER_TRX_IDENTIFIER_VALUE_4
     ,NULL                                 USER_TRX_IDENTIFIER_VALUE_5
     ,NULL                                 USER_TRX_IDENTIFIER_VALUE_6
     ,NULL                                 USER_TRX_IDENTIFIER_VALUE_7
     ,NULL                                 USER_TRX_IDENTIFIER_VALUE_8
     ,NULL                                 USER_TRX_IDENTIFIER_VALUE_9
     ,NULL                                 USER_TRX_IDENTIFIER_VALUE_10
$seg_desc_cols$
FROM  xla_trial_balances       tb
     ,fnd_application_vl       app
     ,gl_code_combinations_kfv gcck
     ,gl_balances              gb
$seg_desc_from$
WHERE tb.definition_code              = ''$definition_code$''
  AND tb.record_type_code             = ''SOURCE''
  AND tb.source_entity_id             = -1
  AND tb.source_application_id        = app.application_id
  AND tb.code_combination_id          = gcck.code_combination_id
  AND tb.gl_date       >=  NVL(''$p_start_date$'',tb.gl_date)
  AND tb.gl_date       <=  NVL(''$p_as_of_date$'',tb.gl_date + 1)
$gl_balance_join$
$seg_desc_join$
 ';

Line: 537


C_INSERT_GT_STATEMENT    CONSTANT VARCHAR2(32000) := '
INSERT INTO xla_trial_balances_gt
         (definition_code
          ,ledger_id
          ,ledger_name
          ,ledger_short_name
          ,ledger_currency_code
          ,record_type_code
          ,source_application_id
         ,source_entity_id
         ,source_entity_code
         ,transaction_number
         ,code_combination_id
         ,gl_date
         ,entered_unrounded_orig_amount
         ,entered_rounded_orig_amount
         ,acctd_unrounded_orig_amount
         ,acctd_rounded_orig_amount
         ,entered_unrounded_rem_amount
         ,entered_rounded_rem_amount
         ,acctd_unrounded_rem_amount
         ,acctd_rounded_rem_amount
         ,third_party_name
         ,third_party_number
         ,balancing_segment_value
         ,natural_account_segment_value
         ,cost_center_segment_value
         ,intercompany_segment_value
         ,management_segment_value
         ,applied_to_entity_id
         ,trx_currency_code
         ,user_trx_identifier_name_1
         ,user_trx_identifier_value_1
         ,user_trx_identifier_name_2
         ,user_trx_identifier_value_2
         ,user_trx_identifier_name_3
         ,user_trx_identifier_value_3
         ,user_trx_identifier_name_4
         ,user_trx_identifier_value_4
         ,user_trx_identifier_name_5
         ,user_trx_identifier_value_5
         ,user_trx_identifier_name_6
         ,user_trx_identifier_value_6
         ,user_trx_identifier_name_7
         ,user_trx_identifier_value_7
         ,user_trx_identifier_name_8
         ,user_trx_identifier_value_8
         ,user_trx_identifier_name_9
         ,user_trx_identifier_value_9
         ,user_trx_identifier_name_10
         ,user_trx_identifier_value_10) ';

Line: 589


C_INSERT_GT_SELECT    CONSTANT VARCHAR2(32000) := '
SELECT
tb.definition_code,
tb.ledger_id,
gl.name,
gl.short_name,
gl.currency_code,
''X'',
tb.source_application_id,
tb.entity_id,
xte.entity_code,
xte.transaction_number,
tb.code_combination_id,
tiv.invoice_date,
--added bug 7359012 original amounts would be displayed only for primary ledger.
decode(gl.ledger_category_code,''PRIMARY'',tiv.invoice_amount,0),
decode(gl.ledger_category_code,''PRIMARY'',tiv.invoice_amount,0),
decode(gl.ledger_category_code,''PRIMARY'',nvl(tiv.base_amount,tiv.invoice_amount),0),
decode(gl.ledger_category_code,''PRIMARY'',nvl(tiv.base_amount,tiv.invoice_amount),0),
--end bug 7359012
tb.entered_unrounded_rem_amount,
tb.entered_rounded_rem_amount,
tb.acctd_unrounded_rem_amount,
tb.acctd_rounded_rem_amount,
tiv.party_name,
tb.party_id,
tb.balancing_segment_value,
tb.natural_account_segment_value,
tb.cost_center_segment_value,
tb.intercompany_segment_value,
tb.management_segment_value,
tb.entity_id,
''USD'', --remod hardcoded tiv.invoice_currency_code
''Party Name''   USER_TRX_IDENTIFIER_NAME_1,
TIV.PARTY_NAME   USER_TRX_IDENTIFIER_VALUE_1,
''Party Site Name''   USER_TRX_IDENTIFIER_NAME_2,
TIV.PARTY_SITE_NAME   USER_TRX_IDENTIFIER_VALUE_2,
''Invoice Number''   USER_TRX_IDENTIFIER_NAME_3,
TIV.INVOICE_NUM   USER_TRX_IDENTIFIER_VALUE_3,
''Invoice Amount''   USER_TRX_IDENTIFIER_NAME_4,
to_char(TIV.INVOICE_AMOUNT)   USER_TRX_IDENTIFIER_VALUE_4,
--remod ''Invoice Currency''   USER_TRX_IDENTIFIER_NAME_5,
--remod TIV.INVOICE_CURRENCY_CODE   USER_TRX_IDENTIFIER_VALUE_5,
''Due Days''   USER_TRX_IDENTIFIER_NAME_5,
TIV.DUE_DAYS   USER_TRX_IDENTIFIER_VALUE_5,
''Invoice Ledger Amount''   USER_TRX_IDENTIFIER_NAME_6,
to_char(TIV.BASE_AMOUNT)   USER_TRX_IDENTIFIER_VALUE_6,
''Payment Status''         USER_TRX_IDENTIFIER_NAME_7,
tiv.PAYMENT_STATUS USER_TRX_IDENTIFIER_VALUE_7,
''Invoice Date''   USER_TRX_IDENTIFIER_NAME_8,
to_char(TIV.INVOICE_DATE,''YYYY-MM-DD"T"hh:mi:ss'')  USER_TRX_IDENTIFIER_VALUE_8,
''Cancelled Date''   USER_TRX_IDENTIFIER_NAME_9,
to_char(TIV.CANCELLED_DATE,''YYYY-MM-DD"T"hh:mi:ss'')   USER_TRX_IDENTIFIER_VALUE_9,
''Invoice Description'' USER_TRX_IDENTIFIER_NAME_10,
TIV.DESCRIPTION   USER_TRX_IDENTIFIER_VALUE_10
FROM
AP_SLA_INVOICES_TRANSACTION_V tiv,
xla_transaction_entities xte,
gl_ledgers gl,
-- inline view
(SELECT /*+ index(xtb XLA_TRIAL_BALANCES_N1) */ xtb.definition_code,
nvl(xtb.applied_to_entity_id,xtb.source_entity_id) entity_id,
xtb.code_combination_id ,
xtb.source_application_id,
SUM (Nvl(xtb.entered_unrounded_cr,0)) -  SUM (Nvl(xtb.entered_unrounded_dr,0)) entered_unrounded_rem_amount,
SUM (Nvl(xtb.entered_rounded_cr,0)) -  SUM (Nvl(xtb.entered_rounded_dr,0)) entered_rounded_rem_amount,
SUM (Nvl(xtb.acctd_unrounded_cr,0)) -  SUM (Nvl(xtb.acctd_unrounded_dr,0)) acctd_unrounded_rem_amount,
SUM (Nvl(xtb.acctd_rounded_cr,0)) -  SUM (Nvl(xtb.acctd_rounded_dr,0)) acctd_rounded_rem_amount,
xtb.ledger_id,
xtb.party_id,
xtb.balancing_segment_value,
xtb.natural_account_segment_value,
xtb.cost_center_segment_value,
xtb.intercompany_segment_value,
xtb.management_segment_value
FROM     xla_trial_balances xtb
where    xtb.definition_code = :1
         and xtb.source_application_id=200
         and xtb.gl_date between :2 and :3
         AND NVL(xtb.party_id,-99)    = NVL(:4,NVL(xtb.party_id,-99))

    GROUP BY  xtb.definition_code,
         nvl(xtb.applied_to_entity_id,xtb.source_entity_id) ,
         xtb.code_combination_id ,
         xtb.source_application_id,
         xtb.ledger_id,
         xtb.party_id,
         xtb.balancing_segment_value,
         xtb.natural_account_segment_value,
         xtb.cost_center_segment_value,
         xtb.intercompany_segment_value,
         xtb.management_segment_value
          HAVING SUM (Nvl(xtb.acctd_rounded_cr,0)) <> SUM (Nvl(xtb.acctd_rounded_dr,0))
) tb
$account_tab$
--end of inline view
where tb.entity_id=xte.entity_id
and tb.source_application_id=200
and xte.entity_code=''AP_INVOICES''
and xte.application_id=tb.source_application_id
-- and xte.ledger_id=tb.ledger_id  removed join to make report work for reporting/secondary ledger,Bug 7331692
and nvl(xte.source_id_int_1,-99)=tiv.invoice_id
and tb.ledger_id=gl.ledger_id
$account_range$
  ';

Line: 899


      SELECT gp.period_name
     INTO l_period_name
     FROM gl_ledgers       gl
         ,gl_periods       gp
    WHERE gl.ledger_id = p_ledger_id
      AND gp.period_set_name = gl.period_set_name
      AND gp.period_type     = gl.accounted_period_type
      AND NVL(TRUNC(l_as_of_date),TRUNC(sysdate)) BETWEEN gp.start_date AND gp.end_date
      AND NVL(gp.adjustment_period_flag,'N')='N';

Line: 955


  (p_select_sql           IN VARCHAR2
  ,p_ledger_id            IN NUMBER
  ,p_account_balance_code IN VARCHAR2
  ,p_balance_side_code    IN VARCHAR2
  ,p_upg_flag             IN VARCHAR2) RETURN VARCHAR2
IS

   l_log_module              VARCHAR2(240);

Line: 967


   l_select_sql              VARCHAR2(32000);

Line: 1110


   l_select_sql := p_select_sql;

Line: 1112


   l_select_sql := REPLACE(l_select_sql,'$gl_balance_cols$',l_balance_cols);

Line: 1113


   l_select_sql := REPLACE(l_select_sql,'$gl_balance_join$',l_balance_join);

Line: 1124


   RETURN l_select_sql;

Line: 1144


|    Replace party related string in C_INSERT_GT_SELECT.                   |
|                                                                       |
+======================================================================*/
FUNCTION replace_party_string
  (p_party_id             IN NUMBER
  ,p_party_type_code      IN VARCHAR2 -- 
  ,p_insert_sql           IN VARCHAR2) RETURN VARCHAR2

IS

   l_log_module           VARCHAR2(240);

Line: 1162


   l_insert_gt_sql        VARCHAR2(32000);

Line: 1179


   l_insert_gt_sql := p_insert_sql;

Line: 1184


   SELECT xlc.meaning
         ,xls.meaning
     INTO l_cust_meaning
         ,l_supp_meaning
     FROM xla_lookups xlc, xla_lookups xls
    WHERE xlc.lookup_type = 'XLA_PARTY_TYPE'
      AND xlc.lookup_code = 'C'
      AND xls.lookup_type = 'XLA_PARTY_TYPE'
      AND xls.lookup_code = 'S';

Line: 1204


      l_insert_gt_sql := REPLACE (l_insert_gt_sql
                                 ,'$party_col$'
                                 ,l_party_column_cust);

Line: 1208


      l_insert_gt_sql := REPLACE (l_insert_gt_sql
                                 ,'$party_tab$'
                                 ,C_PARTY_CUST_TABLE);

Line: 1212


      l_insert_gt_sql := REPLACE (l_insert_gt_sql
                                 ,'$party_where$'
                                 ,C_PARTY_CUST_WHERE);

Line: 1222


      l_insert_gt_sql := REPLACE (l_insert_gt_sql
                                 ,'$party_col$'
                                 ,l_party_column_supp);

Line: 1226


      l_insert_gt_sql := REPLACE (l_insert_gt_sql
                                 ,'$party_tab$'
                                 ,C_PARTY_SUPP_TABLE);

Line: 1230


      l_insert_gt_sql := REPLACE (l_insert_gt_sql
                                 ,'$party_where$'
                                 ,C_PARTY_SUPP_WHERE);

Line: 1244


   RETURN l_insert_gt_sql;

Line: 1437


      SELECT user_je_source_name
        INTO p_journal_source_dsp
        FROM gl_je_sources
       WHERE je_source_name = p_journal_source;

Line: 1455


      SELECT NAME
        INTO p_report_definition_dsp
        FROM xla_tb_definitions_vl
       WHERE definition_code = p_definition_code;

Line: 1473


      SELECT meaning
        INTO p_show_trx_detail_dsp
        FROM xla_lookups
       WHERE lookup_code = p_show_trx_detail_flag
         AND lookup_type = 'XLA_YES_NO';

Line: 1492


      SELECT meaning
        INTO p_incl_write_off_dsp
        FROM xla_lookups
       WHERE lookup_code = p_incl_write_off_flag
         AND lookup_type = 'XLA_YES_NO';

Line: 1538


         SELECT hzp.party_name
           INTO p_third_party_name
           FROM hz_parties hzp
               ,hz_cust_accounts hca
          WHERE hzp.party_id = hca.party_id
            AND hca.cust_account_id = l_party_id;

Line: 1556


         SELECT vendor_name
           INTO p_third_party_name
           FROM ap_suppliers
          WHERE vendor_id = l_party_id;

Line: 1576


      SELECT meaning
        INTO p_acct_balance_dsp
        FROM xla_lookups
       WHERE lookup_type = 'XLA_TB_ACCT_BALANCE'
         AND lookup_code = p_acct_balance;

Line: 1647


   l_insert_gt_sql        VARCHAR2(32000);

Line: 1648


   l_insert_gt_cust_sql   VARCHAR2(32000);

Line: 1649


   l_insert_gt_supp_sql   VARCHAR2(32000);

Line: 1652


   l_select_string        VARCHAR2(4000);

Line: 1660


   SELECT event_class_code
         ,select_string
         ,from_string
         ,where_string
    FROM  xla_tb_user_trans_views
   WHERE  definition_code = p_definition_code;

Line: 1763


           ,l_select_string
           ,l_from_string
           ,l_where_string;

Line: 1772


   l_insert_gt_sql := C_INSERT_GT_STATEMENT || C_INSERT_GT_SELECT;

Line: 1782


      l_insert_gt_sql := REPLACE (
          l_insert_gt_sql
         ,'$account_range$'
         ,' AND cc.code_combination_id = tb.code_combination_id AND '||
          l_flex_range_where);

Line: 1788


      l_insert_gt_sql := REPLACE(l_insert_gt_sql
                              ,'$account_tab$'
                              ,' ,gl_code_combinations cc ');

Line: 1794


      l_insert_gt_sql := REPLACE(l_insert_gt_sql, '$account_range$', '');

Line: 1796


      l_insert_gt_sql := REPLACE(l_insert_gt_sql
                              ,'$account_tab$'
                              ,'');

Line: 1806


         (p_msg      => 'After replace ledger col, l_insert_gl_sql ----'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 1846


         (p_msg      => 'l_insert_gl_sql: ' || substr(l_insert_gt_sql,1,3500)
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 1850


         (p_msg      => 'l_insert_gl_sql: ' || substr(l_insert_gt_sql,3501,3500)
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 1854


         (p_msg      => 'l_insert_gl_sql: ' || substr(l_insert_gt_sql,7001,3500)
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 1860


      EXECUTE IMMEDIATE l_insert_gt_sql
        USING p_definition_code
         ,trunc(p_start_date)
          ,trunc(p_as_of_date)
           ,l_party_id;

Line: 1867


   print_logfile('# of rows inserted into GT table '
                || ' - ' || l_event_class_code
                || ' : ' || SQL%ROWCOUNT);

Line: 1874


         (p_msg      => '# of rows inserted: ' || SQL%ROWCOUNT
         ,p_level    => C_LEVEL_STATEMENT
         ,p_module   => l_log_module);

Line: 2172


| get_select_clause                                                     |
|                                                                       |
| Returns the sql for the event class                                   |
|                                                                       |
+======================================================================*/
FUNCTION get_upg_select_clause
RETURN VARCHAR2 IS

   l_upg_sql              VARCHAR2(32000);

Line: 2198


                   (p_select_sql           => l_upg_sql
                   ,p_ledger_id            => g_defn_info.ledger_id
                   ,p_account_balance_code => p_acct_balance -- Global Variable
                   ,p_balance_side_code    => g_defn_info.balance_side_code
                   ,p_upg_flag                => 'Y');

Line: 2237


   SELECT meaning
     INTO l_init_balance_dsp
     FROM xla_lookups
    WHERE lookup_type = 'XLA_TB_TRX_TYPE';

Line: 2275


END get_upg_select_clause;

Line: 2283


| get_select_clause                                                     |
|                                                                       |
| Returns the sql for the event class                                   |
|                                                                       |
+======================================================================*/

FUNCTION get_select_clause
  (p_defn_info             IN xla_tb_data_manager_pvt.r_definition_info
  ,p_show_trx_detail_flag  IN VARCHAR2
  ,p_incl_write_off_flag   IN VARCHAR2
  ,p_account_balance_code  IN VARCHAR2)

RETURN BOOLEAN IS

   l_log_module                     VARCHAR2(240);

Line: 2312


      l_log_module := C_DEFAULT_MODULE||'.get_select_clause';

Line: 2318


         (p_msg      => 'BEGIN of get_select_clause'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 2328


      SELECT meaning
        INTO l_write_off
        FROM xla_lookups
       WHERE lookup_type = 'XLA_ACCOUNTING_CLASS'
         AND lookup_code = 'WRITE_OFF';

Line: 2348


    l_app_source_sql := 'Select 1 from dual where 1=2';

Line: 2369


                     (p_select_sql           => l_source_sql
                     ,p_ledger_id            => p_defn_info.ledger_id
                     ,p_account_balance_code => p_account_balance_code
                     ,p_balance_side_code    => p_defn_info.balance_side_code
                     ,p_upg_flag             => 'N');

Line: 2385


      l_upg_sql    := get_upg_select_clause;

Line: 2403


         (p_msg      => 'END of get_select_clause'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 2417


        (p_location   => 'xla_tb_report_pvt.get_select_clause');

Line: 2419


END get_select_clause;

Line: 2584


      SELECT application_id
        INTO l_application_id
        FROM xla_subledgers
       WHERE je_source_name = l_journal_source;

Line: 2646


   print_logfile('>> get_select_clause');

Line: 2648


   l_return := get_select_clause
                (p_defn_info               => g_defn_info
                ,p_show_trx_detail_flag    => p_show_trx_detail_flag
                ,p_incl_write_off_flag     => p_incl_write_off_flag
                ,p_account_balance_code    => p_acct_balance);

Line: 2654


   print_logfile('<< get_select_clause');