Product: | OKE - Project Contracts |
---|---|
Description: | Contract funding source allocation information view |
Implementation/DBA Data: | APPS.OKE_K_FUND_ALLOCATIONS_V |
SELECT S.ROWID
, S.FUND_ALLOCATION_ID
, V.MAJOR_VERSION
, 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 S
, OKC_K_LINES_B L
, OKC_K_LINES_TL C
, PA_PROJECTS_ALL P
, PA_TASKS T
, FND_LOOKUP_VALUES LV1
, FND_LOOKUP_VALUES LV2
, FND_LOOKUP_VALUES LV3
, OKE_K_VERS_NUMBERS_V V
, GL_DAILY_CONVERSION_TYPES G
WHERE S.K_LINE_ID = L.ID (+)
AND C.ID (+) = L.ID
AND C.LANGUAGE (+) = USERENV('LANG')
AND S.PROJECT_ID = P.PROJECT_ID (+)
AND S.TASK_ID = T.TASK_ID (+)
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 V.CHR_ID = S.OBJECT_ID
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