View: GL_JE_HEADERS_REVERSE_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_JE_HEADERS_REVERSE_V

View Text

SELECT H.ROWID
, H.NAME
, H.JE_HEADER_ID
, H.LAST_UPDATE_DATE
, H.LAST_UPDATED_BY
, H.LEDGER_ID
, LDG.NAME
, H.JE_CATEGORY
, H.JE_SOURCE
, H.PERIOD_NAME
, PS2.PERIOD_YEAR
, PS2.PERIOD_NUM
, H.CURRENCY_CODE
, H.STATUS
, H.DATE_CREATED
, H.ACCRUAL_REV_FLAG
, H.MULTI_BAL_SEG_FLAG
, H.ACTUAL_FLAG
, H.DEFAULT_EFFECTIVE_DATE
, H.CONVERSION_FLAG
, H.CREATION_DATE
, H.CREATED_BY
, H.LAST_UPDATE_LOGIN
, H.ENCUMBRANCE_TYPE_ID
, H.BUDGET_VERSION_ID
, H.BALANCED_JE_FLAG
, H.BALANCING_SEGMENT_VALUE
, H.JE_BATCH_ID
, B.NAME
, B.DESCRIPTION
, H.FROM_RECURRING_HEADER_ID
, H.UNIQUE_DATE
, H.EARLIEST_POSTABLE_DATE
, H.POSTED_DATE
, H.ACCRUAL_REV_EFFECTIVE_DATE
, H.ACCRUAL_REV_PERIOD_NAME
, PS.PERIOD_YEAR
, PS.PERIOD_NUM
, H.ACCRUAL_REV_STATUS
, H.ACCRUAL_REV_JE_HEADER_ID
, H.ACCRUAL_REV_CHANGE_SIGN_FLAG
, H.DESCRIPTION
, H.TAX_STATUS_CODE
, H.CONTROL_TOTAL
, H.RUNNING_TOTAL_DR
, H.RUNNING_TOTAL_CR
, H.RUNNING_TOTAL_ACCOUNTED_DR
, H.RUNNING_TOTAL_ACCOUNTED_CR
, H.CURRENCY_CONVERSION_RATE
, H.CURRENCY_CONVERSION_TYPE
, H.CURRENCY_CONVERSION_DATE
, H.EXTERNAL_REFERENCE
, H.ATTRIBUTE1
, H.ATTRIBUTE2
, H.ATTRIBUTE3
, H.ATTRIBUTE4
, H.ATTRIBUTE5
, H.ATTRIBUTE6
, H.ATTRIBUTE7
, H.ATTRIBUTE8
, H.ATTRIBUTE9
, H.ATTRIBUTE10
, H.CONTEXT
, H.USSGL_TRANSACTION_CODE
, H.CONTEXT2
, H.DOC_SEQUENCE_ID
, H.DOC_SEQUENCE_VALUE
, L.MEANING
, L.LOOKUP_CODE
FROM GL_LOOKUPS L
, GL_PERIOD_STATUSES PS
, GL_PERIOD_STATUSES PS2
, GL_JE_BATCHES B
, GL_JE_HEADERS H
, GL_LEDGERS LDG
WHERE LDG.LEDGER_ID = H.LEDGER_ID
AND B.JE_BATCH_ID = H.JE_BATCH_ID
AND DECODE(B.BUDGETARY_CONTROL_STATUS
, 'I'
, 'B'
, DECODE(H.ACTUAL_FLAG
, 'A'
, DECODE(PS.CLOSING_STATUS
, 'O'
, 'Y'
, 'F'
, 'Y'
, 'A')
, 'Y')) = L.LOOKUP_CODE AND L.LOOKUP_TYPE = 'REVERSIBLE_CODE'
AND H.ACCRUAL_REV_FLAG = 'Y'
AND H.ACCRUAL_REV_STATUS IS NULL
AND ((H.PARENT_JE_HEADER_ID IS NULL) OR (LDG.LEDGER_CATEGORY_CODE = 'SECONDARY'))
AND PS.APPLICATION_ID = 101
AND PS.LEDGER_ID = H.LEDGER_ID
AND PS.PERIOD_NAME = H.ACCRUAL_REV_PERIOD_NAME
AND PS2.APPLICATION_ID = 101
AND PS2.LEDGER_ID = H.LEDGER_ID
AND PS2.PERIOD_NAME = DECODE(H.PERIOD_NAME
, H.PERIOD_NAME
, H.PERIOD_NAME)
AND B.STATUS = 'P'
AND NOT EXISTS ( SELECT 'SLA JRL SOURCE'
FROM XLA_SUBLEDGERS XS
, GL_JE_SOURCES GJS
WHERE XS.JE_SOURCE_NAME = H.JE_SOURCE
AND GJS.JE_SOURCE_NAME = H.JE_SOURCE
AND GJS.OVERRIDE_EDITS_FLAG IN ('Y'
, 'E'))

Columns