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
ENT_COMMITMENT_AMOUNT NUMBER

Entered Commitment Amount
ACC_COMMITMENT_AMOUNT NUMBER

Accounted Commitment Amount
ENT_UNPAID_OBL_AMOUNT NUMBER

Entered Unpaid Obligation Amount
ACC_UNPAID_OBL_AMOUNT NUMBER

Accounted Unpaid Obligation Amount
ENT_UNPAID_OBL_PYA_AMOUNT NUMBER

Entered Unpaid Obligation Pya Amount
ACC_UNPAID_OBL_PYA_AMOUNT NUMBER

Accounted Unpaid Obligation Pya Amount
ENT_UNPAID_OBL_PYA_OFF_AMOUNT NUMBER

Entered Unpaid Obligation Pya Offset Amount
ACC_UNPAID_OBL_PYA_OFF_AMOUNT NUMBER

Accounted Unpaid Obligation Pya Offset Amount
ENT_ANTICIPATED_BUDGET_AMOUNT NUMBER

Entered Anticipated Budget Amount
ACC_ANTICIPATED_BUDGET_AMOUNT NUMBER

Accounted Anticipated Budget Amount
ENT_UNANTICIPATED_BUD_AMOUNT NUMBER

Entered Unanticipated Budget Amount
ACC_UNANTICIPATED_BUD_AMOUNT NUMBER

Accounted Unanticipated Budget Amount
ENT_UNRESERVED_BUDGET_AMOUNT NUMBER

Entered Unreserved Budget Amount
ACC_UNRESERVED_BUDGET_AMOUNT NUMBER

Accounted Unreserved Budget Amount
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
,      ENT_COMMITMENT_AMOUNT
,      ACC_COMMITMENT_AMOUNT
,      ENT_UNPAID_OBL_AMOUNT
,      ACC_UNPAID_OBL_AMOUNT
,      ENT_UNPAID_OBL_PYA_AMOUNT
,      ACC_UNPAID_OBL_PYA_AMOUNT
,      ENT_UNPAID_OBL_PYA_OFF_AMOUNT
,      ACC_UNPAID_OBL_PYA_OFF_AMOUNT
,      ENT_ANTICIPATED_BUDGET_AMOUNT
,      ACC_ANTICIPATED_BUDGET_AMOUNT
,      ENT_UNANTICIPATED_BUD_AMOUNT
,      ACC_UNANTICIPATED_BUD_AMOUNT
,      ENT_UNRESERVED_BUDGET_AMOUNT
,      ACC_UNRESERVED_BUDGET_AMOUNT
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