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

TABLE: APPS.FV_EXTRACT_DETAIL_GT

Object Details
Object Name: FV_EXTRACT_DETAIL_GT
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.FV_EXTRACT_DETAIL_GT
TableFV.FV_EXTRACT_DETAIL_GT
Subobject Name:
Status: VALID

Temporary Table Details

APPS.FV_EXTRACT_DETAIL_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (15)
Event identifier
LINE_NUMBER NUMBER (15)
Line number
APPLICATION_ID NUMBER (15)
Application Identifier
FUND_VALUE VARCHAR2 (30)
Balancing segment value
FUND_CATEGORY VARCHAR2 (1)
Fund category
FUND_EXPIRED_STATUS VARCHAR2 (15)
Expired status of fund
PRIOR_YEAR_FLAG VARCHAR2 (1)
Flag to denote a prior year transaction
ADJUSTMENT_TYPE VARCHAR2 (15)
Upward or Downward adjustment type
NET_PYA_ADJ_AMT NUMBER

Prior year adjustment amount
ENTERED_PYA_AMT NUMBER

Entered Prior year amount
ENTERED_PYA_DIFF_AMT NUMBER

Entered Prior year difference amount
ANTICIPATION VARCHAR2 (15)
Denotes whether the amount is anticipated, unanticipated or partial
ANTICIPATED_AMT NUMBER

Anticipated amount
UNANTICIPATED_AMT NUMBER

Unanticipated amount
TCF_AMT NUMBER

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

Unexpended obligation
PAID_UNEXPENDED_OBLIGATION NUMBER

Paid Unexpended obligation
PAID_RECEIVED_AMT NUMBER

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

UnPaid Unexpended obligation
UNPAID_RECEIVED_AMT NUMBER

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

Calculated financed amount only from payments that are not voided and are treasury confirmed
FUND_TIME_FRAME VARCHAR2 (25)
Fund time frame
RCV_PARENT_SUB_LEDGER_ID NUMBER

Receivable sub ledger identifier
ACCOUNT_VALID_FLAG VARCHAR2 (1)
Flag denotes whether the account is valid for that transaction
ACCOUNT_RULE VARCHAR2 (50)
Account rule
OLD_CCID NUMBER

The Old CCID
RECEIVABLE_WITH_ADVANCE VARCHAR2 (1)
Query Text

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


SELECT EVENT_ID
,      LINE_NUMBER
,      APPLICATION_ID
,      FUND_VALUE
,      FUND_CATEGORY
,      FUND_EXPIRED_STATUS
,      PRIOR_YEAR_FLAG
,      ADJUSTMENT_TYPE
,      NET_PYA_ADJ_AMT
,      ENTERED_PYA_AMT
,      ENTERED_PYA_DIFF_AMT
,      ANTICIPATION
,      ANTICIPATED_AMT
,      UNANTICIPATED_AMT
,      TCF_AMT
,      UNEXPENDED_OBLIGATION
,      PAID_UNEXPENDED_OBLIGATION
,      PAID_RECEIVED_AMT
,      UNPAID_UNEXPENDED_OBLIGATION
,      UNPAID_RECEIVED_AMT
,      UNPAID_OPEN_AMT
,      FUND_TIME_FRAME
,      RCV_PARENT_SUB_LEDGER_ID
,      ACCOUNT_VALID_FLAG
,      ACCOUNT_RULE
,      OLD_CCID
,      RECEIVABLE_WITH_ADVANCE
FROM APPS.FV_EXTRACT_DETAIL_GT;

Dependencies

[top of page]

APPS.FV_EXTRACT_DETAIL_GT does not reference any database object

APPS.FV_EXTRACT_DETAIL_GT is referenced by following:

SchemaAPPS
Package BodyFV_SLA_PROCESSING_PKG - show dependent code
ViewFV_XLA_AP_REF_V
ViewFV_XLA_AR_REF_V
ViewFV_XLA_CST_REF_V
ViewFV_XLA_PO_REF_V