VIEW: APPS.GL_AUTO_ALLOC_SET_HISTORY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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