DBA Data[Home] [Help]

VIEW: APPS.FV_BUDGET_DISTRIBUTION_HDR_V

Source

View Text - Preformatted

SELECT FBDH.DISTRIBUTION_ID , FBDH.FUND_VALUE , FTS.TREASURY_SYMBOL, FBDH.SET_OF_BOOKS_ID, FBDH.LAST_UPDATE_DATE, FBDH.LAST_UPDATED_BY, FBDH.CREATION_DATE , FBDH.CREATED_BY , FBDH.LAST_UPDATE_LOGIN, FBDH.ATTRIBUTE1 , FBDH.ATTRIBUTE2, FBDH.ATTRIBUTE3 , FBDH.ATTRIBUTE4 , FBDH.ATTRIBUTE5, FBDH.ATTRIBUTE6 , FBDH.ATTRIBUTE7, FBDH.ATTRIBUTE8, FBDH.ATTRIBUTE9, FBDH.ATTRIBUTE10 , FBDH.ATTRIBUTE11 , FBDH.ATTRIBUTE12 , FBDH.ATTRIBUTE13 , FBDH.ATTRIBUTE14 , FBDH.ATTRIBUTE15, FBDH.ATTRIBUTE_CATEGORY, FBDH.ORG_ID , FBDH.FACTS_PRGM_SEGMENT, FBDH.TREASURY_SYMBOL_ID, FBDH.ROWID ROW_ID, FBDH.FREEZE_DEFINITION_FLAG, FBDH.AUTO_CREATE_FLAG FROM FV_BUDGET_DISTRIBUTION_HDR FBDH, FV_TREASURY_SYMBOLS FTS WHERE FBDH.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID ORDER BY FTS.TREASURY_SYMBOL,FBDH.FUND_VALUE
View Text - HTML Formatted

SELECT FBDH.DISTRIBUTION_ID
, FBDH.FUND_VALUE
, FTS.TREASURY_SYMBOL
, FBDH.SET_OF_BOOKS_ID
, FBDH.LAST_UPDATE_DATE
, FBDH.LAST_UPDATED_BY
, FBDH.CREATION_DATE
, FBDH.CREATED_BY
, FBDH.LAST_UPDATE_LOGIN
, FBDH.ATTRIBUTE1
, FBDH.ATTRIBUTE2
, FBDH.ATTRIBUTE3
, FBDH.ATTRIBUTE4
, FBDH.ATTRIBUTE5
, FBDH.ATTRIBUTE6
, FBDH.ATTRIBUTE7
, FBDH.ATTRIBUTE8
, FBDH.ATTRIBUTE9
, FBDH.ATTRIBUTE10
, FBDH.ATTRIBUTE11
, FBDH.ATTRIBUTE12
, FBDH.ATTRIBUTE13
, FBDH.ATTRIBUTE14
, FBDH.ATTRIBUTE15
, FBDH.ATTRIBUTE_CATEGORY
, FBDH.ORG_ID
, FBDH.FACTS_PRGM_SEGMENT
, FBDH.TREASURY_SYMBOL_ID
, FBDH.ROWID ROW_ID
, FBDH.FREEZE_DEFINITION_FLAG
, FBDH.AUTO_CREATE_FLAG
FROM FV_BUDGET_DISTRIBUTION_HDR FBDH
, FV_TREASURY_SYMBOLS FTS
WHERE FBDH.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID ORDER BY FTS.TREASURY_SYMBOL
, FBDH.FUND_VALUE