View: FV_BE_BA_FD_HDR_V

Product:	FV - Federal Financials
Description:	The main purpose of this view is used as Transaction extract headers for SLA to identify the sources
Implementation/DBA Data:	APPS.FV_BE_BA_FD_HDR_V

View Text

SELECT GT.EVENT_ID
, HDR.DOC_ID
, HDR.DOC_NUMBER
, HDR.REVISION_NUM
, DTL.QUARTER_NUM
, HDR.TREASURY_SYMBOL_ID
, HDR.FUND_VALUE
, HDR.BUDGET_LEVEL_ID
, HDR.TRANSACTION_DATE
, FV_BE_XLA_PKG.GET_CCID('SQLGL'
, 'GL#'
, GL.CHART_OF_ACCOUNTS_ID
, SYSDATE
, HDR.BUDGETING_SEGMENTS) DISTRIBUTION_ACCOUNT
, DTL.GL_DATE
, HDR.SEGMENT1 HEADER_SEGMENT1
, HDR.SEGMENT2 HEADER_SEGMENT2
, HDR.SEGMENT3 HEADER_SEGMENT3
, HDR.SEGMENT4 HEADER_SEGMENT4
, HDR.SEGMENT5 HEADER_SEGMENT5
, HDR.SEGMENT6 HEADER_SEGMENT6
, HDR.SEGMENT7 HEADER_SEGMENT7
, HDR.SEGMENT8 HEADER_SEGMENT8
, HDR.SEGMENT9 HEADER_SEGMENT9
, HDR.SEGMENT10 HEADER_SEGMENT10
, HDR.SEGMENT11 HEADER_SEGMENT11
, HDR.SEGMENT12 HEADER_SEGMENT12
, HDR.SEGMENT13 HEADER_SEGMENT13
, HDR.SEGMENT14 HEADER_SEGMENT14
, HDR.SEGMENT15 HEADER_SEGMENT15
, HDR.SEGMENT16 HEADER_SEGMENT16
, HDR.SEGMENT17 HEADER_SEGMENT17
, HDR.SEGMENT18 HEADER_SEGMENT18
, HDR.SEGMENT19 HEADER_SEGMENT19
, HDR.SEGMENT20 HEADER_SEGMENT20
, HDR.SEGMENT21 HEADER_SEGMENT21
, HDR.SEGMENT22 HEADER_SEGMENT22
, HDR.SEGMENT23 HEADER_SEGMENT23
, HDR.SEGMENT24 HEADER_SEGMENT24
, HDR.SEGMENT25 HEADER_SEGMENT25
, HDR.SEGMENT26 HEADER_SEGMENT26
, HDR.SEGMENT27 HEADER_SEGMENT27
, HDR.SEGMENT28 HEADER_SEGMENT28
, HDR.SEGMENT29 HEADER_SEGMENT29
, HDR.SEGMENT30 HEADER_SEGMENT30
, HDR.APPROVAL_ID
, HDR.SOURCE SOURCE
, HDR.APPROVED_BY_USER_ID
, HDR.OLD_DOC_NUMBER
, HDR.SET_OF_BOOKS_ID LEDGER_ID
, GL.CURRENCY_CODE
, HDR.PARENT_DOC_ID
, HDR.ATTRIBUTE1 HEADER_ATTRIBUTE1
, HDR.ATTRIBUTE2 HEADER_ATTRIBUTE2
, HDR.ATTRIBUTE3 HEADER_ATTRIBUTE3
, HDR.ATTRIBUTE4 HEADER_ATTRIBUTE4
, HDR.ATTRIBUTE5 HEADER_ATTRIBUTE5
, HDR.ATTRIBUTE6 HEADER_ATTRIBUTE6
, HDR.ATTRIBUTE7 HEADER_ATTRIBUTE7
, HDR.ATTRIBUTE8 HEADER_ATTRIBUTE8
, HDR.ATTRIBUTE9 HEADER_ATTRIBUTE9
, HDR.ATTRIBUTE10 HEADER_ATTRIBUTE10
, HDR.ATTRIBUTE11 HEADER_ATTRIBUTE11
, HDR.ATTRIBUTE12 HEADER_ATTRIBUTE12
, HDR.ATTRIBUTE13 HEADER_ATTRIBUTE13
, HDR.ATTRIBUTE14 HEADER_ATTRIBUTE14
, HDR.ATTRIBUTE15 HEADER_ATTRIBUTE15
, HDR.ATTRIBUTE_CATEGORY HEADER_ATTR_CATEGORY
, HDR.BU_GROUP_ID
, HDR.DOC_STATUS
, DTL.PUBLIC_LAW_CODE
, DTL.ADVANCE_TYPE
, DTL.DEPT_ID
, DTL.MAIN_ACCOUNT
, DTL.TRANSFER_DESCRIPTION
, SYM.TREASURY_SYMBOL
, SYM.TIME_FRAME
, SYM.ESTABLISHED_FISCAL_YR
, SYM.EXPIRATION_DATE
, SYM.CANCELLATION_DATE
, SYM.RESOURCE_TYPE
, FPM.FUND_CATEGORY
, FPM.BEA_CATEGORY
FROM FV_BE_TRX_HDRS HDR
, FV_BE_TRX_DTLS DTL
, FV_TREASURY_SYMBOLS SYM
, FV_FACTS_BUDGET_ACCOUNTS BUDACCT
, FV_FACTS_BUD_FED_ACCTS FED
, FV_FUND_PARAMETERS FPM
, XLA_EVENTS_GT GT
, GL_LEDGERS GL
WHERE DTL.EVENT_ID = GT.EVENT_ID
AND HDR.DOC_ID = DTL.DOC_ID
AND HDR.TREASURY_SYMBOL_ID = SYM.TREASURY_SYMBOL_ID
AND SYM.TREASURY_SYMBOL_ID = FPM.TREASURY_SYMBOL_ID
AND BUDACCT.BUDGET_ACCT_CODE_ID = FED.BUDGET_ACCT_CODE_ID
AND FED.FEDERAL_ACCT_SYMBOL_ID = SYM.FEDERAL_ACCT_SYMBOL_ID
AND HDR.SOURCE <> 'RPR'
AND HDR.SET_OF_BOOKS_ID = GL.LEDGER_ID

Columns