eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: FV.FV_EXTRACT_DETAIL_GT_LOGS#

Object Details

Object Name:	FV_EXTRACT_DETAIL_GT_LOGS#
Object Type:	VIEW
Owner:	FV
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
EVENT_ID	NUMBER
LINE_NUMBER	NUMBER
APPLICATION_ID	NUMBER
FUND_VALUE	VARCHAR2	(30)
FUND_CATEGORY	VARCHAR2	(1)
FUND_EXPIRED_STATUS	VARCHAR2	(15)
PRIOR_YEAR_FLAG	VARCHAR2	(1)
ADJUSTMENT_TYPE	VARCHAR2	(15)
NET_PYA_ADJ_AMT	NUMBER
ENTERED_PYA_AMT	NUMBER
ENTERED_PYA_DIFF_AMT	NUMBER
ANTICIPATION	VARCHAR2	(15)
ANTICIPATED_AMT	NUMBER
UNANTICIPATED_AMT	NUMBER
TCF_AMT	NUMBER
UNEXPENDED_OBLIGATION	NUMBER
PAID_UNEXPENDED_OBLIGATION	NUMBER
PAID_RECEIVED_AMT	NUMBER
UNPAID_UNEXPENDED_OBLIGATION	NUMBER
UNPAID_RECEIVED_AMT	NUMBER
UNPAID_OPEN_AMT	NUMBER
FUND_TIME_FRAME	VARCHAR2	(25)
RCV_PARENT_SUB_LEDGER_ID	NUMBER
ACCOUNT_VALID_FLAG	VARCHAR2	(1)
ACCOUNT_RULE	VARCHAR2	(50)
OLD_CCID	NUMBER
RECEIVABLE_WITH_ADVANCE	VARCHAR2	(1)
ENT_COMMITMENT_AMOUNT	NUMBER
ENT_UNPAID_OBL_AMOUNT	NUMBER
ACC_COMMITMENT_AMOUNT	NUMBER
ACC_UNPAID_OBL_AMOUNT	NUMBER
ENT_UNPAID_OBL_PYA_AMOUNT	NUMBER
ACC_UNPAID_OBL_PYA_AMOUNT	NUMBER
ENT_UNPAID_OBL_PYA_OFF_AMOUNT	NUMBER
ACC_UNPAID_OBL_PYA_OFF_AMOUNT	NUMBER
ENT_ANTICIPATED_BUDGET_AMOUNT	NUMBER
ACC_ANTICIPATED_BUDGET_AMOUNT	NUMBER
ENT_UNANTICIPATED_BUD_AMOUNT	NUMBER
ACC_UNANTICIPATED_BUD_AMOUNT	NUMBER
ENT_UNRESERVED_BUDGET_AMOUNT	NUMBER
ACC_UNRESERVED_BUDGET_AMOUNT	NUMBER
ENT_CHARGE_AMOUNT	NUMBER
ACC_CHARGE_AMOUNT	NUMBER
ENT_UNPAID_EXP_AMOUNT	NUMBER
ACC_UNPAID_EXP_AMOUNT	NUMBER
ENT_PAID_EXP_AMOUNT	NUMBER
ACC_PAID_EXP_AMOUNT	NUMBER
AR_TRANSACTION_CATEGORY	VARCHAR2	(50)
ENT_PAID_OBL_AMOUNT	NUMBER
ACC_PAID_OBL_AMOUNT	NUMBER
ENT_UNPAID_EXP_PYA_AMOUNT	NUMBER
ACC_UNPAID_EXP_PYA_AMOUNT	NUMBER
ENT_UNPAID_EXP_PYA_OFF_AMOUNT	NUMBER
ACC_UNPAID_EXP_PYA_OFF_AMOUNT	NUMBER
ACC_EXPENDED_APPROP_AMOUNT	NUMBER
ENT_EXPENDED_APPROP_AMOUNT	NUMBER
ENT_PAID_EXP_PYA_AMOUNT	NUMBER
ACC_PAID_EXP_PYA_AMOUNT	NUMBER
ENT_PAID_EXP_PYA_OFF_AMOUNT	NUMBER
ACC_PAID_EXP_PYA_OFF_AMOUNT	NUMBER
TREASURY_SYMBOL_ID	NUMBER
DIRECT_OR_REIMB	VARCHAR2	(1)
PO_DISTRIBUTION_ID	NUMBER
FUND_TYPE	VARCHAR2	(5)
FED_NON_FED_IND	VARCHAR2	(1)
ENT_REFUND_AMOUNT	NUMBER
ACC_REFUND_AMOUNT	NUMBER
ADVANCE_REQUIRED	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
,      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
,      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
,      ACC_EXPENDED_APPROP_AMOUNT
,      ENT_EXPENDED_APPROP_AMOUNT
,      ENT_PAID_EXP_PYA_AMOUNT
,      ACC_PAID_EXP_PYA_AMOUNT
,      ENT_PAID_EXP_PYA_OFF_AMOUNT
,      ACC_PAID_EXP_PYA_OFF_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 FV.FV_EXTRACT_DETAIL_GT_LOGS#;

Dependencies

[top of page]

FV.FV_EXTRACT_DETAIL_GT_LOGS# references the following:

FV: FV_EXTRACT_DETAIL_GT_LOGS

FV.FV_EXTRACT_DETAIL_GT_LOGS# is referenced by following:

APPS: FV_EXTRACT_DETAIL_GT_LOGS