AR Sales Journal by GL Account

➜ Back to Library

Description
Categories: BI Publisher, Financials Application: Receivables Source: Sales Journal by GL Account Report (XML) Short Name: ARSJGLARPT DB package: XLA_JELINES_RPT_PKG more less

Copy

          SELECT
               TABLE1.GL_DATE                                   GL_DATE
              ,TABLE1.CREATED_BY                                CREATED_BY
              ,TABLE1.CREATION_DATE                             CREATION_DATE
              ,TABLE1.LAST_UPDATE_DATE                          LAST_UPDATE_DATE
              ,TABLE1.GL_TRANSFER_DATE                          GL_TRANSFER_DATE
              ,TABLE1.REFERENCE_DATE                            REFERENCE_DATE
              ,TABLE1.COMPLETED_DATE                            COMPLETED_DATE
              ,TABLE1.EXTERNAL_REFERENCE                        EXTERNAL_REFERENCE
	      ,TABLE1.REFERENCE_1				REFERENCE_1
	      ,TABLE1.REFERENCE_4				REFERENCE_4
              ,TABLE1.PERIOD_YEAR                               PERIOD_YEAR
              ,TABLE1.PERIOD_YEAR_START_DATE                    PERIOD_YEAR_START_DATE
              ,TABLE1.PERIOD_YEAR_END_DATE                       PERIOD_YEAR_END_DATE
              ,TABLE1.PERIOD_NUMBER                             PERIOD_NUMBER
              ,TABLE1.PERIOD_NAME                               PERIOD_NAME
              ,TABLE1.PERIOD_START_DATE                         PERIOD_START_DATE
              ,TABLE1.PERIOD_END_DATE                           PERIOD_END_DATE
              ,TABLE1.TRANSACTION_NUMBER                        TRANSACTION_NUMBER
              ,TABLE1.TRANSACTION_DATE                          TRANSACTION_DATE
              ,TABLE1.ACCOUNTING_SEQUENCE_NAME                  ACCOUNTING_SEQUENCE_NAME
              ,TABLE1.ACCOUNTING_SEQUENCE_VERSION               ACCOUNTING_SEQUENCE_VERSION
              ,TABLE1.ACCOUNTING_SEQUENCE_NUMBER                ACCOUNTING_SEQUENCE_NUMBER
              ,TABLE1.REPORTING_SEQUENCE_NAME                   REPORTING_SEQUENCE_NAME
              ,TABLE1.REPORTING_SEQUENCE_VERSION                REPORTING_SEQUENCE_VERSION
              ,TABLE1.REPORTING_SEQUENCE_NUMBER                 REPORTING_SEQUENCE_NUMBER
              ,TABLE1.DOCUMENT_CATEGORY                         DOCUMENT_CATEGORY
              ,TABLE1.DOCUMENT_SEQUENCE_NAME                    DOCUMENT_SEQUENCE_NAME
              ,TABLE1.DOCUMENT_SEQUENCE_NUMBER                  DOCUMENT_SEQUENCE_NUMBER
              ,TABLE1.APPLICATION_ID                            APPLICATION_ID
              ,TABLE1.APPLICATION_NAME                          APPLICATION_NAME
              ,TABLE1.LEDGER_ID                                 LEDGER_ID
              ,TABLE1.LEDGER_SHORT_NAME                         LEDGER_SHORT_NAME
              ,TABLE1.LEDGER_DESCRIPTION                        LEDGER_DESCRIPTION
              ,TABLE1.LEDGER_NAME                               LEDGER_NAME
              ,TABLE1.LEDGER_CURRENCY                           LEDGER_CURRENCY
              ,TABLE1.HEADER_ID                                 HEADER_ID
              ,TABLE1.HEADER_DESCRIPTION                        HEADER_DESCRIPTION
              ,TABLE1.JOURNAL_ENTRY_STATUS                      JOURNAL_ENTRY_STATUS
              ,TABLE1.TRANSFER_TO_GL_STATUS                     TRANSFER_TO_GL_STATUS
              ,TABLE1.BALANCE_TYPE_CODE                         BALANCE_TYPE_CODE
              ,TABLE1.BALANCE_TYPE                              BALANCE_TYPE
              ,TABLE1.BUDGET_NAME                               BUDGET_NAME
              ,TABLE1.ENCUMBRANCE_TYPE                          ENCUMBRANCE_TYPE
              ,TABLE1.FUND_STATUS                               FUND_STATUS
              ,TABLE1.JE_CATEGORY_NAME                          JE_CATEGORY_NAME
              ,TABLE1.JE_SOURCE_NAME                            JE_SOURCE_NAME
              ,TABLE1.GL_BATCH_NAME                             GL_BATCH_NAME
	      ,TABLE1.GL_DEFAULT_EFFECTIVE_DATE			GL_DEFAULT_EFFECTIVE_DATE
              ,TABLE1.GL_BATCH_STATUS                           GL_BATCH_STATUS
              ,TABLE1.POSTED_DATE                               POSTED_DATE
              ,TABLE1.GL_JE_NAME                                GL_JE_NAME
              ,TABLE1.GL_DOC_SEQUENCE_NAME                      GL_DOC_SEQUENCE_NAME
              ,TABLE1.GL_DOC_SEQUENCE_VALUE                     GL_DOC_SEQUENCE_VALUE
              ,TABLE1.GL_LINE_NUMBER                            GL_LINE_NUMBER
              ,TABLE1.EVENT_ID                                  EVENT_ID
              ,TABLE1.EVENT_DATE                                EVENT_DATE
              ,TABLE1.EVENT_NUMBER                              EVENT_NUMBER
              ,TABLE1.EVENT_CLASS_CODE                          EVENT_CLASS_CODE
              ,TABLE1.EVENT_CLASS_NAME                          EVENT_CLASS_NAME
              ,TABLE1.EVENT_TYPE_CODE                           EVENT_TYPE_CODE
              ,TABLE1.EVENT_TYPE_NAME                           EVENT_TYPE_NAME
              ,TABLE1.LINE_NUMBER                               LINE_NUMBER
              ,TABLE1.ACCOUNTING_CLASS_CODE                     ACCOUNTING_CLASS_CODE
              ,TABLE1.ACCOUNTING_CLASS_NAME                     ACCOUNTING_CLASS_NAME
              ,TABLE1.LINE_DESCRIPTION                          LINE_DESCRIPTION
              ,TABLE1.CODE_COMBINATION_ID                       CODE_COMBINATION_ID
              ,TABLE1.ACCOUNTING_CODE_COMBINATION               ACCOUNTING_CODE_COMBINATION
              ,TABLE1.CODE_COMBINATION_DESCRIPTION              CODE_COMBINATION_DESCRIPTION
              ,TABLE1.CONTROL_ACCOUNT_FLAG                      CONTROL_ACCOUNT_FLAG
              ,TABLE1.ENTERED_CURRENCY                          ENTERED_CURRENCY
              ,TABLE1.CONVERSION_RATE                           CONVERSION_RATE
              ,TABLE1.CONVERSION_RATE_DATE                      CONVERSION_RATE_DATE
              ,TABLE1.CONVERSION_RATE_TYPE_CODE                 CONVERSION_RATE_TYPE_CODE
              ,TABLE1.CONVERSION_RATE_TYPE                      CONVERSION_RATE_TYPE
              ,TABLE1.ENTERED_DR                                ENTERED_DR
              ,TABLE1.ENTERED_CR                                ENTERED_CR
              ,TABLE1.UNROUNDED_ACCOUNTED_DR                    UNROUNDED_ACCOUNTED_DR
              ,TABLE1.UNROUNDED_ACCOUNTED_CR                    UNROUNDED_ACCOUNTED_CR
              ,TABLE1.ACCOUNTED_DR                              ACCOUNTED_DR
              ,TABLE1.ACCOUNTED_CR                              ACCOUNTED_CR
              ,TABLE1.STATISTICAL_AMOUNT                        STATISTICAL_AMOUNT
              ,TABLE1.RECONCILIATION_REFERENCE                  RECONCILIATION_REFERENCE
              ,TABLE1.ATTRIBUTE_CATEGORY                        ATTRIBUTE_CATEGORY
              ,TABLE1.ATTRIBUTE1                                ATTRIBUTE1
              ,TABLE1.ATTRIBUTE2                                ATTRIBUTE2
              ,TABLE1.ATTRIBUTE3                                ATTRIBUTE3
              ,TABLE1.ATTRIBUTE4                                ATTRIBUTE4
              ,TABLE1.ATTRIBUTE5                                ATTRIBUTE5
              ,TABLE1.ATTRIBUTE6                                ATTRIBUTE6
              ,TABLE1.ATTRIBUTE7                                ATTRIBUTE7
              ,TABLE1.ATTRIBUTE8                                ATTRIBUTE8
              ,TABLE1.ATTRIBUTE9                                ATTRIBUTE9
              ,TABLE1.ATTRIBUTE10                               ATTRIBUTE10
              ,TABLE1.PARTY_TYPE_CODE                           PARTY_TYPE_CODE
              ,TABLE1.PARTY_TYPE                                PARTY_TYPE
               &p_party_details_col
              ,TABLE1.BALANCING_SEGMENT                         BALANCING_SEGMENT
              ,TABLE1.NATURAL_ACCOUNT_SEGMENT                   NATURAL_ACCOUNT_SEGMENT
              ,TABLE1.COST_CENTER_SEGMENT                       COST_CENTER_SEGMENT
              ,TABLE1.MANAGEMENT_SEGMENT                        MANAGEMENT_SEGMENT
              ,TABLE1.INTERCOMPANY_SEGMENT                      INTERCOMPANY_SEGMENT
              ,TABLE1.BALANCING_SEGMENT_DESC                    BALANCING_SEGMENT_DESC
              ,TABLE1.NATURAL_ACCOUNT_DESC                      NATURAL_ACCOUNT_DESC
              ,TABLE1.COST_CENTER_DESC                          COST_CENTER_DESC
              ,TABLE1.MANAGEMENT_SEGMENT_DESC                   MANAGEMENT_SEGMENT_DESC
              ,TABLE1.INTERCOMPANY_SEGMENT_DESC                 INTERCOMPANY_SEGMENT_DESC
              ,TABLE1.SEGMENT1                                  SEGMENT1
              ,TABLE1.SEGMENT2                                  SEGMENT2
              ,TABLE1.SEGMENT3                                  SEGMENT3
              ,TABLE1.SEGMENT4                                  SEGMENT4
              ,TABLE1.SEGMENT5                                  SEGMENT5
              ,TABLE1.SEGMENT6                                  SEGMENT6
              ,TABLE1.SEGMENT7                                  SEGMENT7
              ,TABLE1.SEGMENT8                                  SEGMENT8
              ,TABLE1.SEGMENT9                                  SEGMENT9
              ,TABLE1.SEGMENT10                                 SEGMENT10
              ,TABLE1.SEGMENT11                                 SEGMENT11
              ,TABLE1.SEGMENT12                                 SEGMENT12
              ,TABLE1.SEGMENT13                                 SEGMENT13
              ,TABLE1.SEGMENT14                                 SEGMENT14
              ,TABLE1.SEGMENT15                                 SEGMENT15
              ,TABLE1.SEGMENT16                                 SEGMENT16
              ,TABLE1.SEGMENT17                                 SEGMENT17
              ,TABLE1.SEGMENT18                                 SEGMENT18
              ,TABLE1.SEGMENT19                                 SEGMENT19
              ,TABLE1.SEGMENT20                                 SEGMENT20
              ,TABLE1.SEGMENT21                                 SEGMENT21
              ,TABLE1.SEGMENT22                                 SEGMENT22
              ,TABLE1.SEGMENT23                                 SEGMENT23
              ,TABLE1.SEGMENT24                                 SEGMENT24
              ,TABLE1.SEGMENT25                                 SEGMENT25
              ,TABLE1.SEGMENT26                                 SEGMENT26
              ,TABLE1.SEGMENT27                                 SEGMENT27
              ,TABLE1.SEGMENT28                                 SEGMENT28
              ,TABLE1.SEGMENT29                                 SEGMENT29
              ,TABLE1.SEGMENT30                                 SEGMENT30
              ,substr(USERIDS,1,instr(USERIDS,'|',1,1)-1)                                                    USER_TRX_IDENTIFIER_NAME_1
              ,substr(USERIDS,instr(USERIDS,'|',1,1)+1,(instr(USERIDS,'|',1,2)-1-instr(USERIDS,'|',1,1)))    USER_TRX_IDENTIFIER_VALUE_1
              ,substr(USERIDS,instr(USERIDS,'|',1,2)+1,(instr(USERIDS,'|',1,3)-1-instr(USERIDS,'|',1,2)))    USER_TRX_IDENTIFIER_NAME_2
              ,substr(USERIDS,instr(USERIDS,'|',1,3)+1,(instr(USERIDS,'|',1,4)-1-instr(USERIDS,'|',1,3)))    USER_TRX_IDENTIFIER_VALUE_2
              ,substr(USERIDS,instr(USERIDS,'|',1,4)+1,(instr(USERIDS,'|',1,5)-1-instr(USERIDS,'|',1,4)))    USER_TRX_IDENTIFIER_NAME_3
              ,substr(USERIDS,instr(USERIDS,'|',1,5)+1,(instr(USERIDS,'|',1,6)-1-instr(USERIDS,'|',1,5)))    USER_TRX_IDENTIFIER_VALUE_3
              ,substr(USERIDS,instr(USERIDS,'|',1,6)+1,(instr(USERIDS,'|',1,7)-1-instr(USERIDS,'|',1,6)))    USER_TRX_IDENTIFIER_NAME_4
              ,substr(USERIDS,instr(USERIDS,'|',1,7)+1,(instr(USERIDS,'|',1,8)-1-instr(USERIDS,'|',1,7)))    USER_TRX_IDENTIFIER_VALUE_4
              ,substr(USERIDS,instr(USERIDS,'|',1,8)+1,(instr(USERIDS,'|',1,9)-1-instr(USERIDS,'|',1,8)))    USER_TRX_IDENTIFIER_NAME_5
              ,substr(USERIDS,instr(USERIDS,'|',1,9)+1,(instr(USERIDS,'|',1,10)-1-instr(USERIDS,'|',1,9)))   USER_TRX_IDENTIFIER_VALUE_5
              ,substr(USERIDS,instr(USERIDS,'|',1,10)+1,(instr(USERIDS,'|',1,11)-1-instr(USERIDS,'|',1,10))) USER_TRX_IDENTIFIER_NAME_6
              ,substr(USERIDS,instr(USERIDS,'|',1,11)+1,(instr(USERIDS,'|',1,12)-1-instr(USERIDS,'|',1,11))) USER_TRX_IDENTIFIER_VALUE_6
              ,substr(USERIDS,instr(USERIDS,'|',1,12)+1,(instr(USERIDS,'|',1,13)-1-instr(USERIDS,'|',1,12))) USER_TRX_IDENTIFIER_NAME_7
              ,substr(USERIDS,instr(USERIDS,'|',1,13)+1,(instr(USERIDS,'|',1,14)-1-instr(USERIDS,'|',1,13))) USER_TRX_IDENTIFIER_VALUE_7
              ,substr(USERIDS,instr(USERIDS,'|',1,14)+1,(instr(USERIDS,'|',1,15)-1-instr(USERIDS,'|',1,14))) USER_TRX_IDENTIFIER_NAME_8
              ,substr(USERIDS,instr(USERIDS,'|',1,15)+1,(instr(USERIDS,'|',1,16)-1-instr(USERIDS,'|',1,15))) USER_TRX_IDENTIFIER_VALUE_8
              ,substr(USERIDS,instr(USERIDS,'|',1,16)+1,(instr(USERIDS,'|',1,17)-1-instr(USERIDS,'|',1,16))) USER_TRX_IDENTIFIER_NAME_9
              ,substr(USERIDS,instr(USERIDS,'|',1,17)+1,(instr(USERIDS,'|',1,18)-1-instr(USERIDS,'|',1,17))) USER_TRX_IDENTIFIER_VALUE_9
              ,substr(USERIDS,instr(USERIDS,'|',1,18)+1,(instr(USERIDS,'|',1,19)-1-instr(USERIDS,'|',1,18))) USER_TRX_IDENTIFIER_NAME_10
              ,substr(USERIDS,instr(USERIDS,'|',1,19)+1,(length(USERIDS)-instr(USERIDS,'|',1,19)))           USER_TRX_IDENTIFIER_VALUE_10
	      &p_le_col
	      ,TABLE1.ORIG_LINE_NUMBER                          ORIG_LINE_NUMBER
              ,TABLE1.LEGAL_CREATED_ID                          LEGAL_CREATED_ID
              ,TABLE1.LEGAL_POSTED_ID                           LEGAL_POSTED_ID	      
          FROM
              (&p_sla_col_1
               &p_gl_columns
               &p_sla_col_2
               &p_party_details
               &p_sla_qualifier_segment
               &p_sla_col_3
               &p_trx_identifiers_1
         	   &p_trx_identifiers_2   
               &p_trx_identifiers_3   
               &p_trx_identifiers_4   
               &p_trx_identifiers_5 
               &p_sla_legal_ent_col
               &p_sla_from
               &p_sla_seg_desc_from
               &p_gl_view
               &p_sla_legal_ent_from
               &p_party_from
               &p_sla_join
               &p_sla_seg_desc_join
               &p_other_param_filter
               &p_gl_join
               &p_sla_legal_ent_join
               &p_party_join
               &p_union_all
               &p_gl_col_1
               &p_gl_party_details
               &p_gl_qualifier_segment
               &p_gl_col_2
               &p_gl_legal_ent_col
               &p_gl_from
               &p_gl_seg_desc_from
               &p_gl_legal_ent_from
               &p_gl_where
               &p_gl_seg_desc_join
               &p_gl_legal_ent_join) TABLE1
	       &p_le_from	       
          WHERE
               1 = 1
               &p_trx_id_filter
	       &p_le_join
	       &p_order_by_clause

SELECT TABLE1.GL_DATE GL_DATE ,TABLE1.CREATED_BY CREATED_BY ,TABLE1.CREATION_DATE CREATION_DATE ,TABLE1.LAST_UPDATE_DATE LAST_UPDATE_DATE ,TABLE1.GL_TRANSFER_DATE GL_TRANSFER_DATE ,TABLE1.REFERENCE_DATE REFERENCE_DATE ,TABLE1.COMPLETED_DATE COMPLETED_DATE ,TABLE1.EXTERNAL_REFERENCE EXTERNAL_REFERENCE ,TABLE1.REFERENCE_1 REFERENCE_1 ,TABLE1.REFERENCE_4 REFERENCE_4 ,TABLE1.PERIOD_YEAR PERIOD_YEAR ,TABLE1.PERIOD_YEAR_START_DATE PERIOD_YEAR_START_DATE ,TABLE1.PERIOD_YEAR_END_DATE PERIOD_YEAR_END_DATE ,TABLE1.PERIOD_NUMBER PERIOD_NUMBER ,TABLE1.PERIOD_NAME PERIOD_NAME ,TABLE1.PERIOD_START_DATE PERIOD_START_DATE ,TABLE1.PERIOD_END_DATE PERIOD_END_DATE ,TABLE1.TRANSACTION_NUMBER TRANSACTION_NUMBER ,TABLE1.TRANSACTION_DATE TRANSACTION_DATE ,TABLE1.ACCOUNTING_SEQUENCE_NAME ACCOUNTING_SEQUENCE_NAME ,TABLE1.ACCOUNTING_SEQUENCE_VERSION ACCOUNTING_SEQUENCE_VERSION ,TABLE1.ACCOUNTING_SEQUENCE_NUMBER ACCOUNTING_SEQUENCE_NUMBER ,TABLE1.REPORTING_SEQUENCE_NAME REPORTING_SEQUENCE_NAME ,TABLE1.REPORTING_SEQUENCE_VERSION REPORTING_SEQUENCE_VERSION ,TABLE1.REPORTING_SEQUENCE_NUMBER REPORTING_SEQUENCE_NUMBER ,TABLE1.DOCUMENT_CATEGORY DOCUMENT_CATEGORY ,TABLE1.DOCUMENT_SEQUENCE_NAME DOCUMENT_SEQUENCE_NAME ,TABLE1.DOCUMENT_SEQUENCE_NUMBER DOCUMENT_SEQUENCE_NUMBER ,TABLE1.APPLICATION_ID APPLICATION_ID ,TABLE1.APPLICATION_NAME APPLICATION_NAME ,TABLE1.LEDGER_ID LEDGER_ID ,TABLE1.LEDGER_SHORT_NAME LEDGER_SHORT_NAME ,TABLE1.LEDGER_DESCRIPTION LEDGER_DESCRIPTION ,TABLE1.LEDGER_NAME LEDGER_NAME ,TABLE1.LEDGER_CURRENCY LEDGER_CURRENCY ,TABLE1.HEADER_ID HEADER_ID ,TABLE1.HEADER_DESCRIPTION HEADER_DESCRIPTION ,TABLE1.JOURNAL_ENTRY_STATUS JOURNAL_ENTRY_STATUS ,TABLE1.TRANSFER_TO_GL_STATUS TRANSFER_TO_GL_STATUS ,TABLE1.BALANCE_TYPE_CODE BALANCE_TYPE_CODE ,TABLE1.BALANCE_TYPE BALANCE_TYPE ,TABLE1.BUDGET_NAME BUDGET_NAME ,TABLE1.ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE ,TABLE1.FUND_STATUS FUND_STATUS ,TABLE1.JE_CATEGORY_NAME JE_CATEGORY_NAME ,TABLE1.JE_SOURCE_NAME JE_SOURCE_NAME ,TABLE1.GL_BATCH_NAME GL_BATCH_NAME ,TABLE1.GL_DEFAULT_EFFECTIVE_DATE GL_DEFAULT_EFFECTIVE_DATE ,TABLE1.GL_BATCH_STATUS GL_BATCH_STATUS ,TABLE1.POSTED_DATE POSTED_DATE ,TABLE1.GL_JE_NAME GL_JE_NAME ,TABLE1.GL_DOC_SEQUENCE_NAME GL_DOC_SEQUENCE_NAME ,TABLE1.GL_DOC_SEQUENCE_VALUE GL_DOC_SEQUENCE_VALUE ,TABLE1.GL_LINE_NUMBER GL_LINE_NUMBER ,TABLE1.EVENT_ID EVENT_ID ,TABLE1.EVENT_DATE EVENT_DATE ,TABLE1.EVENT_NUMBER EVENT_NUMBER ,TABLE1.EVENT_CLASS_CODE EVENT_CLASS_CODE ,TABLE1.EVENT_CLASS_NAME EVENT_CLASS_NAME ,TABLE1.EVENT_TYPE_CODE EVENT_TYPE_CODE ,TABLE1.EVENT_TYPE_NAME EVENT_TYPE_NAME ,TABLE1.LINE_NUMBER LINE_NUMBER ,TABLE1.ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE ,TABLE1.ACCOUNTING_CLASS_NAME ACCOUNTING_CLASS_NAME ,TABLE1.LINE_DESCRIPTION LINE_DESCRIPTION ,TABLE1.CODE_COMBINATION_ID CODE_COMBINATION_ID ,TABLE1.ACCOUNTING_CODE_COMBINATION ACCOUNTING_CODE_COMBINATION ,TABLE1.CODE_COMBINATION_DESCRIPTION CODE_COMBINATION_DESCRIPTION ,TABLE1.CONTROL_ACCOUNT_FLAG CONTROL_ACCOUNT_FLAG ,TABLE1.ENTERED_CURRENCY ENTERED_CURRENCY ,TABLE1.CONVERSION_RATE CONVERSION_RATE ,TABLE1.CONVERSION_RATE_DATE CONVERSION_RATE_DATE ,TABLE1.CONVERSION_RATE_TYPE_CODE CONVERSION_RATE_TYPE_CODE ,TABLE1.CONVERSION_RATE_TYPE CONVERSION_RATE_TYPE ,TABLE1.ENTERED_DR ENTERED_DR ,TABLE1.ENTERED_CR ENTERED_CR ,TABLE1.UNROUNDED_ACCOUNTED_DR UNROUNDED_ACCOUNTED_DR ,TABLE1.UNROUNDED_ACCOUNTED_CR UNROUNDED_ACCOUNTED_CR ,TABLE1.ACCOUNTED_DR ACCOUNTED_DR ,TABLE1.ACCOUNTED_CR ACCOUNTED_CR ,TABLE1.STATISTICAL_AMOUNT STATISTICAL_AMOUNT ,TABLE1.RECONCILIATION_REFERENCE RECONCILIATION_REFERENCE ,TABLE1.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY ,TABLE1.ATTRIBUTE1 ATTRIBUTE1 ,TABLE1.ATTRIBUTE2 ATTRIBUTE2 ,TABLE1.ATTRIBUTE3 ATTRIBUTE3 ,TABLE1.ATTRIBUTE4 ATTRIBUTE4 ,TABLE1.ATTRIBUTE5 ATTRIBUTE5 ,TABLE1.ATTRIBUTE6 ATTRIBUTE6 ,TABLE1.ATTRIBUTE7 ATTRIBUTE7 ,TABLE1.ATTRIBUTE8 ATTRIBUTE8 ,TABLE1.ATTRIBUTE9 ATTRIBUTE9 ,TABLE1.ATTRIBUTE10 ATTRIBUTE10 ,TABLE1.PARTY_TYPE_CODE PARTY_TYPE_CODE ,TABLE1.PARTY_TYPE PARTY_TYPE &p_party_details_col ,TABLE1.BALANCING_SEGMENT BALANCING_SEGMENT ,TABLE1.NATURAL_ACCOUNT_SEGMENT NATURAL_ACCOUNT_SEGMENT ,TABLE1.COST_CENTER_SEGMENT COST_CENTER_SEGMENT ,TABLE1.MANAGEMENT_SEGMENT MANAGEMENT_SEGMENT ,TABLE1.INTERCOMPANY_SEGMENT INTERCOMPANY_SEGMENT ,TABLE1.BALANCING_SEGMENT_DESC BALANCING_SEGMENT_DESC ,TABLE1.NATURAL_ACCOUNT_DESC NATURAL_ACCOUNT_DESC ,TABLE1.COST_CENTER_DESC COST_CENTER_DESC ,TABLE1.MANAGEMENT_SEGMENT_DESC MANAGEMENT_SEGMENT_DESC ,TABLE1.INTERCOMPANY_SEGMENT_DESC INTERCOMPANY_SEGMENT_DESC ,TABLE1.SEGMENT1 SEGMENT1 ,TABLE1.SEGMENT2 SEGMENT2 ,TABLE1.SEGMENT3 SEGMENT3 ,TABLE1.SEGMENT4 SEGMENT4 ,TABLE1.SEGMENT5 SEGMENT5 ,TABLE1.SEGMENT6 SEGMENT6 ,TABLE1.SEGMENT7 SEGMENT7 ,TABLE1.SEGMENT8 SEGMENT8 ,TABLE1.SEGMENT9 SEGMENT9 ,TABLE1.SEGMENT10 SEGMENT10 ,TABLE1.SEGMENT11 SEGMENT11 ,TABLE1.SEGMENT12 SEGMENT12 ,TABLE1.SEGMENT13 SEGMENT13 ,TABLE1.SEGMENT14 SEGMENT14 ,TABLE1.SEGMENT15 SEGMENT15 ,TABLE1.SEGMENT16 SEGMENT16 ,TABLE1.SEGMENT17 SEGMENT17 ,TABLE1.SEGMENT18 SEGMENT18 ,TABLE1.SEGMENT19 SEGMENT19 ,TABLE1.SEGMENT20 SEGMENT20 ,TABLE1.SEGMENT21 SEGMENT21 ,TABLE1.SEGMENT22 SEGMENT22 ,TABLE1.SEGMENT23 SEGMENT23 ,TABLE1.SEGMENT24 SEGMENT24 ,TABLE1.SEGMENT25 SEGMENT25 ,TABLE1.SEGMENT26 SEGMENT26 ,TABLE1.SEGMENT27 SEGMENT27 ,TABLE1.SEGMENT28 SEGMENT28 ,TABLE1.SEGMENT29 SEGMENT29 ,TABLE1.SEGMENT30 SEGMENT30 ,substr(USERIDS,1,instr(USERIDS,'|',1,1)-1) USER_TRX_IDENTIFIER_NAME_1 ,substr(USERIDS,instr(USERIDS,'|',1,1)+1,(instr(USERIDS,'|',1,2)-1-instr(USERIDS,'|',1,1))) USER_TRX_IDENTIFIER_VALUE_1 ,substr(USERIDS,instr(USERIDS,'|',1,2)+1,(instr(USERIDS,'|',1,3)-1-instr(USERIDS,'|',1,2))) USER_TRX_IDENTIFIER_NAME_2 ,substr(USERIDS,instr(USERIDS,'|',1,3)+1,(instr(USERIDS,'|',1,4)-1-instr(USERIDS,'|',1,3))) USER_TRX_IDENTIFIER_VALUE_2 ,substr(USERIDS,instr(USERIDS,'|',1,4)+1,(instr(USERIDS,'|',1,5)-1-instr(USERIDS,'|',1,4))) USER_TRX_IDENTIFIER_NAME_3 ,substr(USERIDS,instr(USERIDS,'|',1,5)+1,(instr(USERIDS,'|',1,6)-1-instr(USERIDS,'|',1,5))) USER_TRX_IDENTIFIER_VALUE_3 ,substr(USERIDS,instr(USERIDS,'|',1,6)+1,(instr(USERIDS,'|',1,7)-1-instr(USERIDS,'|',1,6))) USER_TRX_IDENTIFIER_NAME_4 ,substr(USERIDS,instr(USERIDS,'|',1,7)+1,(instr(USERIDS,'|',1,8)-1-instr(USERIDS,'|',1,7))) USER_TRX_IDENTIFIER_VALUE_4 ,substr(USERIDS,instr(USERIDS,'|',1,8)+1,(instr(USERIDS,'|',1,9)-1-instr(USERIDS,'|',1,8))) USER_TRX_IDENTIFIER_NAME_5 ,substr(USERIDS,instr(USERIDS,'|',1,9)+1,(instr(USERIDS,'|',1,10)-1-instr(USERIDS,'|',1,9))) USER_TRX_IDENTIFIER_VALUE_5 ,substr(USERIDS,instr(USERIDS,'|',1,10)+1,(instr(USERIDS,'|',1,11)-1-instr(USERIDS,'|',1,10))) USER_TRX_IDENTIFIER_NAME_6 ,substr(USERIDS,instr(USERIDS,'|',1,11)+1,(instr(USERIDS,'|',1,12)-1-instr(USERIDS,'|',1,11))) USER_TRX_IDENTIFIER_VALUE_6 ,substr(USERIDS,instr(USERIDS,'|',1,12)+1,(instr(USERIDS,'|',1,13)-1-instr(USERIDS,'|',1,12))) USER_TRX_IDENTIFIER_NAME_7 ,substr(USERIDS,instr(USERIDS,'|',1,13)+1,(instr(USERIDS,'|',1,14)-1-instr(USERIDS,'|',1,13))) USER_TRX_IDENTIFIER_VALUE_7 ,substr(USERIDS,instr(USERIDS,'|',1,14)+1,(instr(USERIDS,'|',1,15)-1-instr(USERIDS,'|',1,14))) USER_TRX_IDENTIFIER_NAME_8 ,substr(USERIDS,instr(USERIDS,'|',1,15)+1,(instr(USERIDS,'|',1,16)-1-instr(USERIDS,'|',1,15))) USER_TRX_IDENTIFIER_VALUE_8 ,substr(USERIDS,instr(USERIDS,'|',1,16)+1,(instr(USERIDS,'|',1,17)-1-instr(USERIDS,'|',1,16))) USER_TRX_IDENTIFIER_NAME_9 ,substr(USERIDS,instr(USERIDS,'|',1,17)+1,(instr(USERIDS,'|',1,18)-1-instr(USERIDS,'|',1,17))) USER_TRX_IDENTIFIER_VALUE_9 ,substr(USERIDS,instr(USERIDS,'|',1,18)+1,(instr(USERIDS,'|',1,19)-1-instr(USERIDS,'|',1,18))) USER_TRX_IDENTIFIER_NAME_10 ,substr(USERIDS,instr(USERIDS,'|',1,19)+1,(length(USERIDS)-instr(USERIDS,'|',1,19))) USER_TRX_IDENTIFIER_VALUE_10 &p_le_col ,TABLE1.ORIG_LINE_NUMBER ORIG_LINE_NUMBER ,TABLE1.LEGAL_CREATED_ID LEGAL_CREATED_ID ,TABLE1.LEGAL_POSTED_ID LEGAL_POSTED_ID FROM (&p_sla_col_1 &p_gl_columns &p_sla_col_2 &p_party_details &p_sla_qualifier_segment &p_sla_col_3 &p_trx_identifiers_1 &p_trx_identifiers_2 &p_trx_identifiers_3 &p_trx_identifiers_4 &p_trx_identifiers_5 &p_sla_legal_ent_col &p_sla_from &p_sla_seg_desc_from &p_gl_view &p_sla_legal_ent_from &p_party_from &p_sla_join &p_sla_seg_desc_join &p_other_param_filter &p_gl_join &p_sla_legal_ent_join &p_party_join &p_union_all &p_gl_col_1 &p_gl_party_details &p_gl_qualifier_segment &p_gl_col_2 &p_gl_legal_ent_col &p_gl_from &p_gl_seg_desc_from &p_gl_legal_ent_from &p_gl_where &p_gl_seg_desc_join &p_gl_legal_ent_join) TABLE1 &p_le_from WHERE 1 = 1 &p_trx_id_filter &p_le_join &p_order_by_clause

Parameter Name

SQL text

Validation

P_CUSTOM_PARAMETER_4

P_CUSTOM_PARAMETER_3

Source

P_POST_ACCT_PROGRAM_ROWID

P_FETCH_FROM_GL

P_PARTY_TYPE_CODE

P_PROCESS_CATEGORY_ROWID

P_PARTY_NAME

P_POSTING_STATUS

Period To

LOV Oracle

Period From

LOV Oracle

Operating Unit Name

P_COA_ID

Ledger Name

FND_MO_REPORTING_LEVEL

LOV Oracle

Responsibility Application

LOV Oracle

Match with GL

LOV Oracle

Include Zero Amount Lines

LOV Oracle

Transaction Number High

LOV Oracle

Transaction Number Low

LOV Oracle

Transaction Date To

Date

Transaction Date From

Date

Customer Number High

LOV Oracle

Customer Number Low

LOV Oracle

Customer Name

LOV Oracle

Transfer or Posting Status

LOV Oracle

Entered Currency

LOV Oracle

GL Date To

Date

GL Date From

Date

GL Account High

GL Account Low

Order by

LOV Oracle

Operating Unit

LOV Oracle

Ledger

LOV Oracle

Download

Related Blitz Reports
JG Global Journal Ledger CST Journal Entries Report - Cost Management JG Global Journals and Third Party JG Global Daily Journals JE Italian Journal Ledger JG Global GL and SLA Account by Journal Lines JE French Accounting Entries Audit File XLA Account Analysis JG Global Subledger Detail Journal