View: GL_AUTO_ALLOC_SET_HISTORY_V

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

View Text

SELECT H.ROWID ROW_ID
, H.REQUEST_ID
, H.ALLOCATION_SET_ID
, H.ALLOCATION_SET_NAME
, H.ALLOCATION_SET_TYPE_CODE
, H.ALLOCATION_CODE
, H.CHART_OF_ACCOUNTS_ID
, H.PERIOD_SET_NAME
, H.ACCOUNTED_PERIOD_TYPE
, H.ACCESS_SET_ID
, H.LEDGER_ID
, H.BALANCING_SEGMENT_VALUE
, H.LAST_UPDATE_DATE
, H.LAST_UPDATED_BY
, H.LAST_UPDATE_LOGIN
, H.CREATION_DATE
, H.CREATED_BY
, H.ORG_ID
, H.DESCRIPTION
, H.OWNER
, H.PERIOD_NAME
, H.BUDGET_VERSION_ID
, H.JOURNAL_EFFECTIVE_DATE
, H.CALCULATION_EFFECTIVE_DATE
, H.USAGE_CODE
, H.GL_PERIOD_NAME
, H.PA_PERIOD_NAME
, H.EXPENDITURE_ITEM_DATE
, H.MONITOR_URL
, L.MEANING ALLOCATION_SET_TYPE
, L2.MEANING USAGE
, B.BUDGET_NAME BUDGET_NAME
, LGR.NAME LEDGER_NAME
, DECODE(T.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_AUTO_ALLOC_SETS_V'
, 'GL_DAS_AUTO_ALLOC_SETS'
, TO_CHAR(T.ALLOCATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') VIEW_PRIVILEGE
, DECODE(T.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_AUTO_ALLOC_SETS_U'
, 'GL_DAS_AUTO_ALLOC_SETS'
, TO_CHAR(T.ALLOCATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
, DECODE(T.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_AUTO_ALLOC_SETS_M'
, 'GL_DAS_AUTO_ALLOC_SETS'
, TO_CHAR(T.ALLOCATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') MODIFY_PRIVILEGE
FROM GL_BUDGET_VERSIONS B
, GL_LOOKUPS L2
, GL_LOOKUPS L
, GL_AUTO_ALLOC_SET_HISTORY H
, GL_LEDGERS LGR
, GL_AUTO_ALLOC_SETS T
WHERE L.LOOKUP_TYPE='ALLOCATION_SET_TYPE'
AND L.LOOKUP_CODE = H.ALLOCATION_SET_TYPE_CODE
AND L2.LOOKUP_TYPE = 'AB_JOURNAL_TYPE'
AND L2.LOOKUP_CODE = H.USAGE_CODE
AND B.BUDGET_VERSION_ID (+) = H.BUDGET_VERSION_ID
AND LGR.LEDGER_ID (+) = H.LEDGER_ID
AND T.ALLOCATION_SET_ID = H.ALLOCATION_SET_ID

Columns