Product: | OKE - Project Contracts |
---|---|
Description: | Contract funding source allocation history view |
Implementation/DBA Data: | APPS.OKE_K_FUND_ALLOCATIONS_HV |
SELECT S.ROWID
, S.MAJOR_VERSION
, S.FUND_ALLOCATION_ID
, S.FUNDING_SOURCE_ID
, S.OBJECT_ID
, S.K_LINE_ID
, L.LINE_NUMBER
, C.ITEM_DESCRIPTION
, L.START_DATE
, L.END_DATE
, S.PROJECT_ID
, P.SEGMENT1
, S.TASK_ID
, T.TASK_NUMBER
, S.AMOUNT
, S.PREVIOUS_AMOUNT
, S.HARD_LIMIT
, S.REVENUE_HARD_LIMIT
, S.FUND_TYPE
, LV2.MEANING
, S.FUNDING_STATUS
, LV1.MEANING
, S.START_DATE_ACTIVE
, S.END_DATE_ACTIVE
, S.FISCAL_YEAR
, S.REFERENCE1
, S.REFERENCE2
, S.REFERENCE3
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATED_BY
, S.LAST_UPDATE_DATE
, S.LAST_UPDATE_LOGIN
, S.PA_CONVERSION_TYPE
, G.USER_CONVERSION_TYPE
, S.PA_CONVERSION_DATE
, S.PA_CONVERSION_RATE
, S.AGREEMENT_VERSION
, S.PA_FLAG
, P.PROJFUNC_CURRENCY_CODE
, P.MULTI_CURRENCY_BILLING_FLAG
, P.INVPROC_CURRENCY_TYPE
, S.CREATED_IN_VERSION
, S.UPDATED_IN_VERSION
, S.FUNDING_CATEGORY
, LV3.MEANING
, S.ATTRIBUTE_CATEGORY
, S.ATTRIBUTE1
, S.ATTRIBUTE2
, S.ATTRIBUTE3
, S.ATTRIBUTE4
, S.ATTRIBUTE5
, S.ATTRIBUTE6
, S.ATTRIBUTE7
, S.ATTRIBUTE8
, S.ATTRIBUTE9
, S.ATTRIBUTE10
, S.ATTRIBUTE11
, S.ATTRIBUTE12
, S.ATTRIBUTE13
, S.ATTRIBUTE14
, S.ATTRIBUTE15
, S.PA_ATTRIBUTE_CATEGORY
, S.PA_ATTRIBUTE1
, S.PA_ATTRIBUTE2
, S.PA_ATTRIBUTE3
, S.PA_ATTRIBUTE4
, S.PA_ATTRIBUTE5
, S.PA_ATTRIBUTE6
, S.PA_ATTRIBUTE7
, S.PA_ATTRIBUTE8
, S.PA_ATTRIBUTE9
, S.PA_ATTRIBUTE10
FROM OKE_K_FUND_ALLOCATIONS_H S
, OKC_K_LINES_BH L
, OKC_K_LINES_TLH C
, PA_PROJECTS_ALL P
, PA_TASKS T
, FND_LOOKUP_VALUES LV1
, FND_LOOKUP_VALUES LV2
, FND_LOOKUP_VALUES LV3
, GL_DAILY_CONVERSION_TYPES G
WHERE S.K_LINE_ID = L.ID (+)
AND L.ID = C.ID (+)
AND C.LANGUAGE(+) = USERENV('LANG')
AND S.PROJECT_ID = P.PROJECT_ID (+)
AND S.TASK_ID = T.TASK_ID (+)
AND L.MAJOR_VERSION (+) = S.MAJOR_VERSION
AND L.MAJOR_VERSION = C.MAJOR_VERSION (+)
AND LV1.VIEW_APPLICATION_ID (+) = 777
AND LV1.LOOKUP_TYPE (+) = 'FUNDING_STATUS'
AND LV1.LANGUAGE (+) = USERENV('LANG')
AND LV1.LOOKUP_CODE (+) = S.FUNDING_STATUS
AND LV2.VIEW_APPLICATION_ID (+) = 777
AND LV2.LOOKUP_TYPE (+) = 'FUND_TYPE'
AND LV2.LANGUAGE (+) = USERENV('LANG')
AND LV2.LOOKUP_CODE (+) = S.FUND_TYPE
AND G.CONVERSION_TYPE (+) = S.PA_CONVERSION_TYPE
AND LV3.LOOKUP_TYPE (+) = 'FUNDING CATEGORY TYPE'
AND LV3.LANGUAGE (+) = USERENV('LANG')
AND LV3.VIEW_APPLICATION_ID (+) = 275
AND LV3.LOOKUP_CODE (+) = S.FUNDING_CATEGORY