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

VIEW: APPS.FV_TREASURY_EXTRACT_DETAILS_V

Object Details
Object Name: FV_TREASURY_EXTRACT_DETAILS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


This view is used as line level transaction object(SLA) for TREASURY_ACCOMPLISHMENT event class


[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (15)
BC Event Id
LINE_NUMBER NUMBER (15)
BC Event Line Number
FEDERAL_FUND_CATEGORY VARCHAR2 (1)
Fund category
FEDERAL_FUND_EXPIRED_STATUS VARCHAR2 (15)
Expired status of fund
FV_PAY_ACCOUNTING_EVENT_ID NUMBER (15)
Federal Payment Accounting Event ID
FEDERAL_FUND_CAT_DESC VARCHAR2 (13)
Description of fund category
FEDERAL_ADJUSTMENT_TYPE VARCHAR2 (15)
Upward or Downward adjustment type
FV_TREASURY_CONFIRMATION_ID NUMBER (15)
Federal Treasury Confirmation Id
FEDERAL_PRIOR_YEAR_FLAG VARCHAR2 (1)
Flag to denote a prior year transaction
FV_PAY_CHECK_ID NUMBER (15)
Federal Payment Check Id
FV_INV_CURRENCY_CODE VARCHAR2 (15)
Federal Invoice Currency Code
FV_PAY_DIST_AMOUNT NUMBER

Federal Payment distribution amount
FV_PAY_HIST_DIST_ID NUMBER (15)
Federal Payment history distribution Id
FV_PAYMENT_HISTORY_ID NUMBER (15)
Federal Payment history Id
FV_INV_DISTRIBUTION_ID NUMBER (15)
Federal Invoice Distribution Id
FV_INVOICE_PAYMENT_ID NUMBER (15)
Federal Invoice Payment Id
FV_REV_PAY_HIST_DIST_ID NUMBER (15)
Applied to Distribution Identifier for Void Payments
FV_REV_PMT_HIST_ID NUMBER (15)
AP Payment History ID which is reversed
FV_AP_CASH_CLEARING_CCID NUMBER (15)
Cash Clearing Account
ENT_UNPAID_OBL_AMOUNT NUMBER

Entered Unpaid Obligation Amount
DIT_CONFIRM_CASH_ACCOUNT VARCHAR2 (25)
DIT Confirm Cash Account
ACC_UNPAID_OBL_AMOUNT NUMBER

Accounted Unpaid Obligation Amount
FV_INV_DIST_CCID NUMBER

Invoice Distribution Code combination Id
FV_INV_DIST_AMOUNT NUMBER

Invoice Distribution Amount
FV_INV_DIST_LINE_NUMBER NUMBER (15)
Invoice Distribution Line number
ENT_ANTICIPATED_BUDGET_AMOUNT NUMBER

Entered Anticipated Budget Amount
ACC_ANTICIPATED_BUDGET_AMOUNT NUMBER

Accounted Anticipated Budget Amount
FV_INV_LINE_TYPE_LOOKUP_CODE VARCHAR2 (25)
Invoice distribution line type code
ENT_UNANTICIPATED_BUD_AMOUNT NUMBER

Entered Unanticipated Budget Amount
ACC_UNANTICIPATED_BUD_AMOUNT NUMBER

Accounted Unanticipated Budget Amount
FV_INVOICE_AMOUNT NUMBER

Invoice Amount
FV_INV_ACCTS_PAY_CCID NUMBER (15)
Invoice Accountts Pay code combination Id
FV_PO_DISTRIBUTION_ID NUMBER (15)
PO Distribution Id
ENT_UNPAID_EXP_AMOUNT NUMBER

Entered Unpaid Expenditure Amount
ACC_UNPAID_EXP_AMOUNT NUMBER

Accounted Unpaid Expenditure Amount
FV_INV_TYPE_LOOKUP_CODE VARCHAR2 (25)
Invoice type lookup code
ENT_PAID_EXP_AMOUNT NUMBER

Entered Paid Expenditure Amount
ACC_PAID_EXP_AMOUNT NUMBER

Accounted Paid Expenditure Amount
FV_INVOICE_DATE DATE

Invoice Date
ENT_PAID_OBL_AMOUNT NUMBER

FV Entered Paid Obligation Amount
FV_INV_EXCHANGE_DATE DATE

Invoice Exchange Date
ACC_PAID_OBL_AMOUNT NUMBER

FV Accounted Paid Obligation Amount
FV_INV_EXCHANGE_RATE NUMBER

Invoice Exchange Rate
FV_INV_EXCHANGE_RATE_TYPE VARCHAR2 (30)
Invoice Exchange Rate Type
ACC_EXPENDED_APPROP_AMOUNT NUMBER

FV Accounted Expended Appropriations Amount
FV_APHD_INV_DIST_AMOUNT NUMBER

APHD Invoice distribution amount
ENT_EXPENDED_APPROP_AMOUNT NUMBER

FV Entered Expended Appropriations Amount
ENT_PAID_EXP_PYA_AMOUNT NUMBER

FV Entered Paid Expenditure PYA Amount
FV_BUS_FLOW_AP_APP_ID NUMBER

Applied to AP Application ID
ACC_PAID_EXP_PYA_AMOUNT NUMBER

FV Accounted Paid Expenditure PYA Amount
ENT_PAID_EXP_PYA_OFF_AMOUNT NUMBER

FV Entered Paid Expenditure PYA Offset Amount
FV_BUS_FLOW_FV_APP_ID NUMBER

Applied to FV Application ID
ACC_PAID_EXP_PYA_OFF_AMOUNT NUMBER

FV Accounted Paid Expenditure PYA Offset Amount
FV_BUS_FLOW_INV_DIST_TYPE CHAR (11)
Applied to Invoice Distribution Link Type
FV_BUS_FLOW_INV_ENTITY_CODE CHAR (11)
Applied to Invoice Entity Code
FV_BUS_FLOW_INV_DIST_ID NUMBER (15)
Applied to Invoice Distribution Identifier
FV_BUS_FLOW_INV_ID NUMBER (15)
Applied to Invoice Id
FV_BUS_FLOW_PO_APP_ID NUMBER

Applied to PO Application Id
FV_BUS_FLOW_PO_DIST_TYPE CHAR (20)
Applied to PO Distribution Link Type
FV_BUS_FLOW_PO_ENTITY_CODE CHAR (14)
Applied to PO Entity Code
FV_BUS_FLOW_PMT_DIST_TYPE CHAR (11)
Applied to Payment Distribution Link Type
FV_BUS_FLOW_PMT_ENTITY_CODE CHAR (11)
Applied to Payment Entity Code
FV_BUS_FLOW_TREASURY_DIST_TYPE CHAR (29)
Applied to Treasury Confirmation Distribution Link Type
FV_BUS_FLOW_TREAS_ENTITY_CODE CHAR (21)
Applied to Treasury Confirmation Entity Code
FV_AP_CASH_ACCOUNT NUMBER (15)
Accounting flexfield identifier for the AP cash account
FV_AP_LIABILITY_ACCOUNT NUMBER (15)
Accounting Flexfield identifier for accounts payable liability account
FV_CHECK_DATE DATE

Payment date
FV_CHECK_NUMBER NUMBER (15)
Payment Number
FV_TREASURY_PAY_NUMBER NUMBER (15)
Number assigned to payment processed through internal clearing organization
FEDERAL_DIRECT_OR_REIMB VARCHAR2 (1)
Direct or Reimbursable
FEDERAL_FUND_TYPE VARCHAR2 (2)
Fund Type
FV_PAY_ACC_DIST_AMOUNT NUMBER

Accounted Pay Distribution Amount
Query Text

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


SELECT EVENT_ID
,      LINE_NUMBER
,      FEDERAL_FUND_CATEGORY
,      FEDERAL_FUND_EXPIRED_STATUS
,      FV_PAY_ACCOUNTING_EVENT_ID
,      FEDERAL_FUND_CAT_DESC
,      FEDERAL_ADJUSTMENT_TYPE
,      FV_TREASURY_CONFIRMATION_ID
,      FEDERAL_PRIOR_YEAR_FLAG
,      FV_PAY_CHECK_ID
,      FV_INV_CURRENCY_CODE
,      FV_PAY_DIST_AMOUNT
,      FV_PAY_HIST_DIST_ID
,      FV_PAYMENT_HISTORY_ID
,      FV_INV_DISTRIBUTION_ID
,      FV_INVOICE_PAYMENT_ID
,      FV_REV_PAY_HIST_DIST_ID
,      FV_REV_PMT_HIST_ID
,      FV_AP_CASH_CLEARING_CCID
,      ENT_UNPAID_OBL_AMOUNT
,      DIT_CONFIRM_CASH_ACCOUNT
,      ACC_UNPAID_OBL_AMOUNT
,      FV_INV_DIST_CCID
,      FV_INV_DIST_AMOUNT
,      FV_INV_DIST_LINE_NUMBER
,      ENT_ANTICIPATED_BUDGET_AMOUNT
,      ACC_ANTICIPATED_BUDGET_AMOUNT
,      FV_INV_LINE_TYPE_LOOKUP_CODE
,      ENT_UNANTICIPATED_BUD_AMOUNT
,      ACC_UNANTICIPATED_BUD_AMOUNT
,      FV_INVOICE_AMOUNT
,      FV_INV_ACCTS_PAY_CCID
,      FV_PO_DISTRIBUTION_ID
,      ENT_UNPAID_EXP_AMOUNT
,      ACC_UNPAID_EXP_AMOUNT
,      FV_INV_TYPE_LOOKUP_CODE
,      ENT_PAID_EXP_AMOUNT
,      ACC_PAID_EXP_AMOUNT
,      FV_INVOICE_DATE
,      ENT_PAID_OBL_AMOUNT
,      FV_INV_EXCHANGE_DATE
,      ACC_PAID_OBL_AMOUNT
,      FV_INV_EXCHANGE_RATE
,      FV_INV_EXCHANGE_RATE_TYPE
,      ACC_EXPENDED_APPROP_AMOUNT
,      FV_APHD_INV_DIST_AMOUNT
,      ENT_EXPENDED_APPROP_AMOUNT
,      ENT_PAID_EXP_PYA_AMOUNT
,      FV_BUS_FLOW_AP_APP_ID
,      ACC_PAID_EXP_PYA_AMOUNT
,      ENT_PAID_EXP_PYA_OFF_AMOUNT
,      FV_BUS_FLOW_FV_APP_ID
,      ACC_PAID_EXP_PYA_OFF_AMOUNT
,      FV_BUS_FLOW_INV_DIST_TYPE
,      FV_BUS_FLOW_INV_ENTITY_CODE
,      FV_BUS_FLOW_INV_DIST_ID
,      FV_BUS_FLOW_INV_ID
,      FV_BUS_FLOW_PO_APP_ID
,      FV_BUS_FLOW_PO_DIST_TYPE
,      FV_BUS_FLOW_PO_ENTITY_CODE
,      FV_BUS_FLOW_PMT_DIST_TYPE
,      FV_BUS_FLOW_PMT_ENTITY_CODE
,      FV_BUS_FLOW_TREASURY_DIST_TYPE
,      FV_BUS_FLOW_TREAS_ENTITY_CODE
,      FV_AP_CASH_ACCOUNT
,      FV_AP_LIABILITY_ACCOUNT
,      FV_CHECK_DATE
,      FV_CHECK_NUMBER
,      FV_TREASURY_PAY_NUMBER
,      FEDERAL_DIRECT_OR_REIMB
,      FEDERAL_FUND_TYPE
,      FV_PAY_ACC_DIST_AMOUNT
FROM APPS.FV_TREASURY_EXTRACT_DETAILS_V;

Dependencies

[top of page]

APPS.FV_TREASURY_EXTRACT_DETAILS_V references the following:

SchemaAPPS
SynonymAP_CHECKS_ALL
SynonymAP_INVOICES_ALL
SynonymAP_INVOICE_DISTRIBUTIONS_ALL
SynonymAP_PAYMENT_HISTORY_ALL
SynonymAP_PAYMENT_HIST_DISTS
SynonymAP_SYSTEM_PARAMETERS_ALL
SynonymCE_GL_ACCOUNTS_CCID
TableFV_EXTRACT_DETAIL_GT
SynonymFV_OPERATING_UNITS_ALL
SynonymFV_TREASURY_CONFIRMATIONS_ALL
ViewFV_TREAS_CONFIRM_CHECKS_V
SynonymFV_VOIDED_CHECKS
SynonymXLA_EVENTS_GT
APPS.FV_TREASURY_EXTRACT_DETAILS_V is referenced by following:

SchemaAPPS
Package BodyXLA_08901_AAD_S_000002_PKG - show dependent code