VIEW: APPS.OKE_POOL_PARTIES_V

Source

View Text - Preformatted

SELECT S.ROWID , S.POOL_PARTY_ID , S.FUNDING_POOL_ID , F.NAME , S.PARTY_ID , H.PARTY_NAME , S.AMOUNT , S.INITIAL_AMOUNT , S.AVAILABLE_AMOUNT , S.CURRENCY_CODE , S.CONVERSION_TYPE , G.USER_CONVERSION_TYPE , S.CONVERSION_DATE , S.CONVERSION_RATE , S.START_DATE_ACTIVE , S.END_DATE_ACTIVE , 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 FROM OKE_POOL_PARTIES S , OKE_FUNDING_POOLS F , HZ_PARTIES H , GL_DAILY_CONVERSION_TYPES G WHERE F.FUNDING_POOL_ID = S.FUNDING_POOL_ID AND S.PARTY_ID = H.PARTY_ID AND G.CONVERSION_TYPE (+) = S.CONVERSION_TYPE

View Text - HTML Formatted

SELECT S.ROWID
, S.POOL_PARTY_ID
, S.FUNDING_POOL_ID
, F.NAME
, S.PARTY_ID
, H.PARTY_NAME
, S.AMOUNT
, S.INITIAL_AMOUNT
, S.AVAILABLE_AMOUNT
, S.CURRENCY_CODE
, S.CONVERSION_TYPE
, G.USER_CONVERSION_TYPE
, S.CONVERSION_DATE
, S.CONVERSION_RATE
, S.START_DATE_ACTIVE
, S.END_DATE_ACTIVE
, 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
FROM OKE_POOL_PARTIES S
, OKE_FUNDING_POOLS F
, HZ_PARTIES H
, GL_DAILY_CONVERSION_TYPES G
WHERE F.FUNDING_POOL_ID = S.FUNDING_POOL_ID
AND S.PARTY_ID = H.PARTY_ID
AND G.CONVERSION_TYPE (+) = S.CONVERSION_TYPE