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

VIEW: APPS.FA_FINANCIAL_INQUIRY_COST_V

Object Details
Object Name: FA_FINANCIAL_INQUIRY_COST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FA_FINANCIAL_INQUIRY_COST_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_HEADER_ID_IN NUMBER (15)
Identifies the transaction that made this row effective
ASSET_ID NUMBER (15)
Asset identification number
ASSET_NUMBER VARCHAR2 (15)
User assigned asset number
BOOK_TYPE_CODE VARCHAR2 (30)
Book name
TRANSACTION_TYPE VARCHAR2 (80)
PERIOD_ENTERED VARCHAR2 (15)
PERIOD_EFFECTIVE VARCHAR2 (15)
CURRENT_COST NUMBER

TRANSACTION_DATE_ENTERED DATE

FISCAL_YEAR NUMBER (4)
DATE_EFFECTIVE DATE

Refer to base table
SOB_ID NUMBER (15)
TRX_REFERENCE_ID NUMBER (15)
TRX_REFERENCE_TYPE VARCHAR2 (30)
Query Text

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


SELECT TRANSACTION_HEADER_ID_IN
,      ASSET_ID
,      ASSET_NUMBER
,      BOOK_TYPE_CODE
,      TRANSACTION_TYPE
,      PERIOD_ENTERED
,      PERIOD_EFFECTIVE
,      CURRENT_COST
,      TRANSACTION_DATE_ENTERED
,      FISCAL_YEAR
,      DATE_EFFECTIVE
,      SOB_ID
,      TRX_REFERENCE_ID
,      TRX_REFERENCE_TYPE
FROM APPS.FA_FINANCIAL_INQUIRY_COST_V;

Dependencies

[top of page]

APPS.FA_FINANCIAL_INQUIRY_COST_V references the following:

SchemaAPPS
SynonymFA_ADDITIONS_B
SynonymFA_BOOKS
SynonymFA_BOOKS_BAS
SynonymFA_BOOK_CONTROLS
SynonymFA_CALENDAR_PERIODS
SynonymFA_DEPRN_PERIODS
SynonymFA_LOOKUPS
SynonymFA_MC_BOOKS
SynonymFA_TRANSACTION_HEADERS
SynonymFA_TRX_REFERENCES

APPS.FA_FINANCIAL_INQUIRY_COST_V is not referenced by any database object