R12 GL All Acounting All JEs 'All Journal Entries' Query

 R12 GL All Acounting All JEs 'All Journal Entries' Query :

SELECT GB.NAME LEDGER,
          GB.LEDGER_ID,
          GJH.JE_HEADER_ID,
          GJH.JE_SOURCE,
          GJCT.USER_JE_CATEGORY_NAME JE_CATEGORY,
          GJB.NAME BATCH_NAME,
          GJH.NAME JOURNAL_NAME,
          GJH.PERIOD_NAME,
          GJH.STATUS,
          GJH.CURRENCY_CODE,
          GJH.CURRENCY_CONVERSION_RATE,
          GJH.DOC_SEQUENCE_VALUE JOURNAL_NUMBER,
          GJH.CREATION_DATE,
          GJH.DEFAULT_EFFECTIVE_DATE GL_DATE,
          GJH.DESCRIPTION JOURNAL_DESCRIPTION,
          GJL.JE_LINE_NUM,
          GJL.DESCRIPTION,
          GCC."CODE_COMBINATION_ID",
          GCC."COMPANY",
          GCC."COMPANY_DESC",
          GCC."BUSINESS_UNIT",
          GCC."BUSINESS_UNIT_DESC",
          GCC."COST_CENTER",
          GCC."COST_CENTER_DESC",
          GCC."LOCATION",
          GCC."LOCATION_DESC",
          GCC."ACCOUNT",
          GCC."ACCOUNT_DESC",
          GCC."SUB_ACCOUNT",
          GCC."SUB_ACCOUNT_DESC",
          GCC."PROJECT",
          GCC."PROJECT_DESC",
          GCC."PRODUCT",
          GCC."PRODUCT_DESC",
          GCC."CODE_COMBINATION",
          NVL (GJL.ENTERED_DR, 0) ENTERED_DEBIT,
          NVL (GJL.ENTERED_CR, 0) ENTERED_CREDIT,
          NVL (GJL.ACCOUNTED_DR, 0) DEBIT,
          NVL (GJL.ACCOUNTED_CR, 0) CREDIT,
          NVL (GJL.ACCOUNTED_DR, 0) - NVL (GJL.ACCOUNTED_CR, 0) BALANCE,
          GP.PERIOD_YEAR,
          GP.PERIOD_NUM
     FROM GL_JE_BATCHES GJB
          JOIN GL_JE_HEADERS GJH ON (GJB.JE_BATCH_ID = GJH.JE_BATCH_ID)
          JOIN GL_JE_CATEGORIES_TL GJCT
             ON (GJCT.JE_CATEGORY_NAME = GJH.JE_CATEGORY)
          JOIN GL_JE_LINES GJL ON (GJL.JE_HEADER_ID = GJH.JE_HEADER_ID)
          JOIN XX_GL_CODE_COMBINATION_DESC GCC
             ON (GCC.CODE_COMBINATION_ID = GJL.CODE_COMBINATION_ID)
          JOIN XX_PERIODS GP ON (GJH.PERIOD_NAME = GP.PERIOD_NAME)
          JOIN GL_LEDGERS GB ON (GB.LEDGER_ID = GJH.LEDGER_ID)
    WHERE 1 = 1 AND GJH.ACTUAL_FLAG = 'A' AND GJH.LEDGER_ID = :LEDGER_ID;