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

VIEW: APPS.FV_XLA_PO_REF_V

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

View Type

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


This view is used for Purchasing related federal sources fro accounting in sub ledger(XLA) .


[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)
Fund expired status
FEDERAL_PRIOR_YEAR_FLAG VARCHAR2 (1)
Flag to denote prior year transaction
FEDERAL_PYA_AMT NUMBER

Prior year amount
FEDERAL_PYA_DIFF_AMT NUMBER

Prior year difference amount
FEDERAL_ADJUSTMENT_TYPE VARCHAR2 (15)
Upward of Downward adjustment type
FEDERAL_NET_PYA_ADJ_AMT NUMBER

Prior year adjustment amount
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_OLD_CCID NUMBER

Old CCID
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_PRIOR_YEAR_FLAG
,      FEDERAL_PYA_AMT
,      FEDERAL_PYA_DIFF_AMT
,      FEDERAL_ADJUSTMENT_TYPE
,      FEDERAL_NET_PYA_ADJ_AMT
,      FEDERAL_ANTICIPATION
,      FEDERAL_ANTICIPATED_AMT
,      FEDERAL_UNANTICIPATED_AMT
,      FEDERAL_TCF_AMT
,      FEDERAL_OLD_CCID
FROM APPS.FV_XLA_PO_REF_V;

Dependencies

[top of page]

APPS.FV_XLA_PO_REF_V references the following:

SchemaAPPS
TableFV_EXTRACT_DETAIL_GT
APPS.FV_XLA_PO_REF_V is referenced by following:

SchemaAPPS
Package BodyXLA_00201_AAD_S_000004_BC_PKG - show dependent code