1. Tables and Views for Financials
  2. FV_BE_XLA_V

FV_BE_XLA_V

Details

  • Schema: FUSION

  • Object owner: FV

  • Object type: VIEW

Columns

Name

DOCUMENT_ID

DOCUMENT_NUMBER

REVISION_NUMBER

HDR_DESCRIPTION

DOCUMENT_AMOUNT

APPROVAL_DATE

BUDGET_LEVEL

BUDGET_LEVEL_NUM

BE_SOURCE

Query

SQL_Statement

SELECT H.DOCUMENT_ID DOCUMENT_ID,

H.DOCUMENT_NUMBER DOCUMENT_NUMBER,

H.REVISION_NUMBER REVISION_NUMBER,

H.DESCRIPTION HDR_DESCRIPTION,

H.DOCUMENT_AMOUNT DOCUMENT_AMOUNT,

H.APPROVAL_DATE APPROVAL_DATE,

L.BUDGET_LEVEL BUDGET_LEVEL,

L.LEVEL_NUM BUDGET_LEVEL_NUM,

F.MEANING BE_SOURCE

FROM FV_BE_TRANSACTION_HEADERS H,

FND_LOOKUPS F,

FV_BE_LEVELS L

WHERE H.BUDGET_LEVEL_ID = L.BUDGET_LEVEL_ID

AND H.LEDGER_ID = L.LEDGER_ID

AND F.LOOKUP_TYPE = 'ORA_FV_SOURCE'

AND F.LOOKUP_CODE = H.SOURCE_TYPE_CODE