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

FV Entered Commitment Amount
ENT_UNPAID_OBL_AMOUNT NUMBER

FV Entered Unpaid Obligation Amount
ACC_COMMITMENT_AMOUNT NUMBER

FV Accounted Commitment Amount
ACC_UNPAID_OBL_AMOUNT NUMBER

FV Accounted Unpaid Obligation Amount
ENT_UNPAID_OBL_PYA_AMOUNT NUMBER

FV Entered Unpaid Obligation PYA Amount
ACC_UNPAID_OBL_PYA_AMOUNT NUMBER

FV Accounted Unpaid Obligation PYA Amount
ENT_UNPAID_OBL_PYA_OFF_AMOUNT NUMBER

FV Entered Unpaid Obligation PYA Offset Amount
ACC_UNPAID_OBL_PYA_OFF_AMOUNT NUMBER

FV Accounted Unpaid Obligation PYA Offset Amount
ENT_ANTICIPATED_BUDGET_AMOUNT NUMBER

FV Entered Anticipated Budget Amount
ACC_ANTICIPATED_BUDGET_AMOUNT NUMBER

FV Accounted Anticipated Budget Amount
ENT_UNANTICIPATED_BUD_AMOUNT NUMBER

FV Entered Unanticipated Budget Amount
ACC_UNANTICIPATED_BUD_AMOUNT NUMBER

FV Accounted Unanticipated Budget Amount
ENT_UNRESERVED_BUDGET_AMOUNT NUMBER

FV Entered Unreserved Budget Amount
ACC_UNRESERVED_BUDGET_AMOUNT NUMBER

FV Accounted Unreserved Budget Amount
ENT_CHARGE_AMOUNT NUMBER

FV Entered Charge Amount
ACC_CHARGE_AMOUNT NUMBER

FV Accounted Charge Amount
ENT_UNPAID_EXP_AMOUNT NUMBER

FV Entered Unpaid Expenditure Amount
ACC_UNPAID_EXP_AMOUNT NUMBER

FV Accounted Unpaid Expenditure Amount
ENT_PAID_EXP_AMOUNT NUMBER

FV Entered Paid Expenditure Amount
ACC_PAID_EXP_AMOUNT NUMBER

FV Accounted Paid Expenditure Amount
AR_TRANSACTION_CATEGORY VARCHAR2 (50)
FV AR Transaction Category
ACC_PAID_EXP_PYA_OFF_AMOUNT NUMBER

FV Accounted Paid Expenditure PYA Offset Amount
ENT_PAID_EXP_PYA_OFF_AMOUNT NUMBER

FV Entered Paid Expenditure PYA Offset Amount
ENT_PAID_OBL_AMOUNT NUMBER

FV Entered Paid Obligation Amount
ACC_PAID_OBL_AMOUNT NUMBER

FV Accounted Paid Obligation Amount
ENT_UNPAID_EXP_PYA_AMOUNT NUMBER

FV Entered Unpaid Expenditure PYA Amount
ACC_UNPAID_EXP_PYA_AMOUNT NUMBER

FV Accounted Unpaid Expenditure PYA Amount
ENT_UNPAID_EXP_PYA_OFF_AMOUNT NUMBER

FV Entered Unpaid Expenditure PYA Offset Amount
ACC_UNPAID_EXP_PYA_OFF_AMOUNT NUMBER

FV Accounted Unpaid Expenditure PYA Offset Amount
EXP_APPROPRIATIONS_AMOUNT NUMBER

ENT_PAID_EXP_PYA_AMOUNT NUMBER

FV Entered Paid Expenditure PYA Amount
ACC_PAID_EXP_PYA_AMOUNT NUMBER

FV Accounted Paid Expenditure PYA Amount
ACC_EXPENDED_APPROP_AMOUNT NUMBER

FV Accounted Expended Appropriations Amount
ENT_EXPENDED_APPROP_AMOUNT NUMBER

FV Entered Expended Appropriations Amount
TREASURY_SYMBOL_ID NUMBER

Treasury Symbol Id
DIRECT_OR_REIMB VARCHAR2 (1)
Direct or Reimbursable
PO_DISTRIBUTION_ID NUMBER

Purchase Order Distribution Identifier
FUND_TYPE VARCHAR2 (2)
Fund Type
FED_NON_FED_IND VARCHAR2 (1)
Federal or Non-Federal Code
ENT_REFUND_AMOUNT NUMBER

FV Entered Refund Amount
ACC_REFUND_AMOUNT NUMBER

FV Accounted Refund Amount
ADVANCE_REQUIRED VARCHAR2 (1)
Advance Required
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
,      ENT_COMMITMENT_AMOUNT
,      ENT_UNPAID_OBL_AMOUNT
,      ACC_COMMITMENT_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
,      ENT_CHARGE_AMOUNT
,      ACC_CHARGE_AMOUNT
,      ENT_UNPAID_EXP_AMOUNT
,      ACC_UNPAID_EXP_AMOUNT
,      ENT_PAID_EXP_AMOUNT
,      ACC_PAID_EXP_AMOUNT
,      AR_TRANSACTION_CATEGORY
,      ACC_PAID_EXP_PYA_OFF_AMOUNT
,      ENT_PAID_EXP_PYA_OFF_AMOUNT
,      ENT_PAID_OBL_AMOUNT
,      ACC_PAID_OBL_AMOUNT
,      ENT_UNPAID_EXP_PYA_AMOUNT
,      ACC_UNPAID_EXP_PYA_AMOUNT
,      ENT_UNPAID_EXP_PYA_OFF_AMOUNT
,      ACC_UNPAID_EXP_PYA_OFF_AMOUNT
,      EXP_APPROPRIATIONS_AMOUNT
,      ENT_PAID_EXP_PYA_AMOUNT
,      ACC_PAID_EXP_PYA_AMOUNT
,      ACC_EXPENDED_APPROP_AMOUNT
,      ENT_EXPENDED_APPROP_AMOUNT
,      TREASURY_SYMBOL_ID
,      DIRECT_OR_REIMB
,      PO_DISTRIBUTION_ID
,      FUND_TYPE
,      FED_NON_FED_IND
,      ENT_REFUND_AMOUNT
,      ACC_REFUND_AMOUNT
,      ADVANCE_REQUIRED
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_AP_PROCESSING_PKG - show dependent code
Package BodyFV_SLA_AR_PROCESSING_PKG - show dependent code
Package BodyFV_SLA_CST_PROCESSING_PKG - show dependent code
Package BodyFV_SLA_FV_PROCESSING_PKG - show dependent code
Package BodyFV_SLA_PO_PROCESSING_PKG - show dependent code
Package BodyFV_SLA_UTL_PROCESSING_PKG - show dependent code
PL/SQL PackageFV_SLA_UTL_PROCESSING_PKG - show dependent code
ViewFV_TREASURY_EXTRACT_DETAILS_V
ViewFV_XLA_AP_REF_V
ViewFV_XLA_AR_REF_V
ViewFV_XLA_CST_REF_V
ViewFV_XLA_PO_REF_V