VIEW: APPS.GL_JE_HEADERS_REVERSE_V

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))