VIEW: APPS.OKE_K_FUND_ALLOCATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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