FND Design Data [Home] [Help]

View: OKE_K_FUNDING_SOURCES_PM_HV

Product: OKE - Project Contracts
Description: Contract funding source history view
Implementation/DBA Data: ViewAPPS.OKE_K_FUNDING_SOURCES_PM_HV
View Text

SELECT S.ROWID
, TO_NUMBER(S.FUNDING_SOURCE_ID||S.MAJOR_VERSION)
, S.FUNDING_SOURCE_ID
, S.POOL_PARTY_ID
, S.K_PARTY_ID
, S.OBJECT_TYPE
, S.OBJECT_ID
, S.MAJOR_VERSION
, S.AGREEMENT_NUMBER
, S.AMOUNT
, S.INITIAL_AMOUNT
, S.PREVIOUS_AMOUNT
, S.FUNDING_STATUS
, S.HARD_LIMIT
, S.CURRENCY_CODE
, S.K_CONVERSION_TYPE
, S.K_CONVERSION_DATE
, S.K_CONVERSION_RATE
, S.START_DATE_ACTIVE
, S.END_DATE_ACTIVE
, S.AGREEMENT_FLAG
, 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_H S

Columns

Name
ROW_ID
FUNDING_SOURCE_H_PK
FUNDING_SOURCE_ID
POOL_PARTY_ID
K_PARTY_ID
OBJECT_TYPE
OBJECT_ID
MAJOR_VERSION
AGREEMENT_NUMBER
AMOUNT
INITIAL_AMOUNT
PREVIOUS_AMOUNT
FUNDING_STATUS_CODE
HARD_LIMIT
CURRENCY_CODE
K_CONVERSION_TYPE
K_CONVERSION_DATE
K_CONVERSION_RATE
START_DATE_ACTIVE
END_DATE_ACTIVE
AGREEMENT_FLAG
CREATION_DATE
CREATED_BY
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
PA_ATTRIBUTE_CATEGORY
PA_ATTRIBUTE1
PA_ATTRIBUTE2
PA_ATTRIBUTE3
PA_ATTRIBUTE4
PA_ATTRIBUTE5
PA_ATTRIBUTE6
PA_ATTRIBUTE7
PA_ATTRIBUTE8
PA_ATTRIBUTE9
PA_ATTRIBUTE10