VIEW: APPS.OKE_K_FUNDING_SOURCES_V

Source

View Text - Preformatted

SELECT S.ROWID , S.FUNDING_SOURCE_ID , S.POOL_PARTY_ID , P.START_DATE_ACTIVE , P.END_DATE_ACTIVE , F.NAME , S.K_PARTY_ID , Z.PARTY_NAME , Z.PARTY_NUMBER , S.OBJECT_TYPE , S.OBJECT_ID , V.CONTRACT_NUMBER , V.ESTIMATED_AMOUNT , V.CURRENCY_CODE , C.MAJOR_VERSION , S.AGREEMENT_NUMBER , S.AMOUNT , S.INITIAL_AMOUNT , S.PREVIOUS_AMOUNT , S.FUNDING_STATUS , L.MEANING , S.HARD_LIMIT , S.REVENUE_HARD_LIMIT , S.CURRENCY_CODE , S.K_CONVERSION_TYPE , G.USER_CONVERSION_TYPE , S.K_CONVERSION_DATE , S.K_CONVERSION_RATE , S.START_DATE_ACTIVE , S.END_DATE_ACTIVE , S.AGREEMENT_FLAG , S.AGREEMENT_ORG_ID , O.NAME , S.FUNDING_ACROSS_OU , S.CREATION_DATE , S.CREATED_BY , S.LAST_UPDATED_BY , S.LAST_UPDATE_DATE , S.LAST_UPDATE_LOGIN , 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_FUNDING_SOURCES S , OKE_FUNDING_POOLS F , OKE_POOL_PARTIES P , HZ_PARTIES Z , OKC_K_HEADERS_B V , OKE_K_VERS_NUMBERS_V C , FND_LOOKUP_VALUES L , GL_DAILY_CONVERSION_TYPES G , HR_ALL_ORGANIZATION_UNITS_TL O WHERE F.FUNDING_POOL_ID (+) = P.FUNDING_POOL_ID AND P.POOL_PARTY_ID (+) = S.POOL_PARTY_ID AND Z.PARTY_ID (+) = S.K_PARTY_ID AND V.ID = S.OBJECT_ID AND L.VIEW_APPLICATION_ID (+) = 777 AND L.LOOKUP_TYPE (+) = 'FUNDING_STATUS' AND L.LANGUAGE (+) = USERENV('LANG') AND L.LOOKUP_CODE (+) = S.FUNDING_STATUS AND C.CHR_ID = V.ID AND G.CONVERSION_TYPE (+) = S.K_CONVERSION_TYPE AND S.AGREEMENT_ORG_ID = O.ORGANIZATION_ID (+) AND O.LANGUAGE (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT S.ROWID
, S.FUNDING_SOURCE_ID
, S.POOL_PARTY_ID
, P.START_DATE_ACTIVE
, P.END_DATE_ACTIVE
, F.NAME
, S.K_PARTY_ID
, Z.PARTY_NAME
, Z.PARTY_NUMBER
, S.OBJECT_TYPE
, S.OBJECT_ID
, V.CONTRACT_NUMBER
, V.ESTIMATED_AMOUNT
, V.CURRENCY_CODE
, C.MAJOR_VERSION
, S.AGREEMENT_NUMBER
, S.AMOUNT
, S.INITIAL_AMOUNT
, S.PREVIOUS_AMOUNT
, S.FUNDING_STATUS
, L.MEANING
, S.HARD_LIMIT
, S.REVENUE_HARD_LIMIT
, S.CURRENCY_CODE
, S.K_CONVERSION_TYPE
, G.USER_CONVERSION_TYPE
, S.K_CONVERSION_DATE
, S.K_CONVERSION_RATE
, S.START_DATE_ACTIVE
, S.END_DATE_ACTIVE
, S.AGREEMENT_FLAG
, S.AGREEMENT_ORG_ID
, O.NAME
, S.FUNDING_ACROSS_OU
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATED_BY
, S.LAST_UPDATE_DATE
, S.LAST_UPDATE_LOGIN
, 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_FUNDING_SOURCES S
, OKE_FUNDING_POOLS F
, OKE_POOL_PARTIES P
, HZ_PARTIES Z
, OKC_K_HEADERS_B V
, OKE_K_VERS_NUMBERS_V C
, FND_LOOKUP_VALUES L
, GL_DAILY_CONVERSION_TYPES G
, HR_ALL_ORGANIZATION_UNITS_TL O
WHERE F.FUNDING_POOL_ID (+) = P.FUNDING_POOL_ID
AND P.POOL_PARTY_ID (+) = S.POOL_PARTY_ID
AND Z.PARTY_ID (+) = S.K_PARTY_ID
AND V.ID = S.OBJECT_ID
AND L.VIEW_APPLICATION_ID (+) = 777
AND L.LOOKUP_TYPE (+) = 'FUNDING_STATUS'
AND L.LANGUAGE (+) = USERENV('LANG')
AND L.LOOKUP_CODE (+) = S.FUNDING_STATUS
AND C.CHR_ID = V.ID
AND G.CONVERSION_TYPE (+) = S.K_CONVERSION_TYPE
AND S.AGREEMENT_ORG_ID = O.ORGANIZATION_ID (+)
AND O.LANGUAGE (+) = USERENV('LANG')