JG Global Third Party Account Balance

Description
Categories: BI Publisher
Application: Regional Localizations
Source: Global Third Party Account Balance Report
Short Name: JGSLATPABL
DB package: XLA_TP_BALANCE_RPT_PKG
        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.TRANSACTION_NUMBER            TRANSACTION_NUMBER
       ,TABLE1.OPERATING_UNIT                OPERATING_UNIT --Bug 9113330
       ,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_SEQUENCE_NAME        DOCUMENT_SEQUENCE_NAME
       ,TABLE1.DOCUMENT_SEQUENCE_NUMBER      DOCUMENT_SEQUENCE_NUMBER
       ,TABLE1.HEADER_ID                     HEADER_ID
       ,TABLE1.HEADER_DESCRIPTION            HEADER_DESCRIPTION
       ,TABLE1.FUND_STATUS                   FUND_STATUS
       ,TABLE1.JE_CATEGORY_NAME              JE_CATEGORY_NAME
       ,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.JOURNAL_ENTRY_STATUS          JOURNAL_ENTRY_STATUS
       ,TABLE1.TRANSFER_TO_GL_STATUS         TRANSFER_TO_GL_STATUS
       ,TABLE1.GL_BATCH_STATUS               GL_BATCH_STATUS
       ,TABLE1.POSTED_DATE                   POSTED_DATE
       ,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.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