DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.FV_XLA_AP_REF_V

Object Details
Object Name: FV_XLA_AP_REF_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFV.FV_XLA_AP_REF_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


The view is used as payables federal accounting source.


[View Source]

Columns
Name Datatype Length Mandatory Comments
FEDERAL_EVENT_ID NUMBER (15)
Event identifier
FEDERAL_LINE_NUMBER NUMBER (15)
Line number
FEDERAL_FUND_VALUE VARCHAR2 (30)
Balancing segment value
FEDERAL_FUND_CATEGORY VARCHAR2 (1)
Fund category
FEDERAL_FUND_EXPIRED_STATUS VARCHAR2 (15)
Expired status of fund
FEDERAL_FUND_CAT_DESC VARCHAR2 (12)
Description of fund category
FEDERAL_ADJUSTMENT_TYPE VARCHAR2 (15)
Upward or Downward adjustment type
FEDERAL_PRIOR_YEAR_FLAG VARCHAR2 (1)
Flag to denote a prior year transaction
FEDERAL_ANTICIPATION VARCHAR2 (15)
Denotes whether the amount is anticipated, unanticipated or partial
FEDERAL_ANTICIPATED_AMT NUMBER

Anticipated amount
FEDERAL_UNANTICIPATED_AMT NUMBER

Unanticipated amount
FEDERAL_TCF_AMT NUMBER

Treasury confirmed Amount. Paid amount only from payments that are not voided and are treasury confirmed.
FEDERAL_PAID_RECEIVED_AMT NUMBER

Paid portion of unexpended obligation. Receipt must correctly liquidate the obligation based on its paid amount confirmed with Treasury.
FEDERAL_PAID_UNEXP_OBG_AMT NUMBER

Paid unexpended obligation amount
FEDERAL_UNPAID_UNEXP_OBG_AMT NUMBER

Unpaid unexpended obligation amount
FEDERAL_UNPAID_RECEIVED_AMT NUMBER

Unpaid portion of unexpended obligation. Receipt must correctly liquidate the obligation based on its unpaid amount confirmed with Treasury.
FEDERAL_UNPAID_OPEN_AMT NUMBER

Calculated financed amount only from payments that are not voided and are treasury confirmed.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FEDERAL_EVENT_ID
,      FEDERAL_LINE_NUMBER
,      FEDERAL_FUND_VALUE
,      FEDERAL_FUND_CATEGORY
,      FEDERAL_FUND_EXPIRED_STATUS
,      FEDERAL_FUND_CAT_DESC
,      FEDERAL_ADJUSTMENT_TYPE
,      FEDERAL_PRIOR_YEAR_FLAG
,      FEDERAL_ANTICIPATION
,      FEDERAL_ANTICIPATED_AMT
,      FEDERAL_UNANTICIPATED_AMT
,      FEDERAL_TCF_AMT
,      FEDERAL_PAID_RECEIVED_AMT
,      FEDERAL_PAID_UNEXP_OBG_AMT
,      FEDERAL_UNPAID_UNEXP_OBG_AMT
,      FEDERAL_UNPAID_RECEIVED_AMT
,      FEDERAL_UNPAID_OPEN_AMT
FROM APPS.FV_XLA_AP_REF_V;

Dependencies

[top of page]

APPS.FV_XLA_AP_REF_V references the following:

SchemaAPPS
TableFV_EXTRACT_DETAIL_GT
APPS.FV_XLA_AP_REF_V is referenced by following:

SchemaAPPS
Package BodyXLA_00200_AAD_S_000012_BC_PKG - show dependent code
Package BodyXLA_00200_AAD_S_000012_PKG - show dependent code