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

VIEW: APPS.FA_TRANSACTION_HISTORY_TRX_V

Object Details
Object Name: FA_TRANSACTION_HISTORY_TRX_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FA_TRANSACTION_HISTORY_TRX_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 NUMBER (15) Yes Unique transaction identification number
TRANSACTION_TYPE_CODE VARCHAR2 (20) Yes Identifies the type of transaction
BOOK_TYPE_CODE VARCHAR2 (15) Yes Book name
TRANSACTION_TYPE VARCHAR2 (80)
Meaning of the lookup code; translatable
ASSET_ID NUMBER (15) Yes System generated asset identification number
ASSET_NUMBER VARCHAR2 (15) Yes User assigned asset number
ASSET_NUMBER_DESC VARCHAR2 (98)
CATEGORY_ID NUMBER (15) Yes
SEGMENT1 VARCHAR2 (30)
SEGMENT2 VARCHAR2 (30)
SEGMENT3 VARCHAR2 (30)
SEGMENT4 VARCHAR2 (30)
SEGMENT5 VARCHAR2 (30)
SEGMENT6 VARCHAR2 (30)
SEGMENT7 VARCHAR2 (30)
TRANSACTION_DATE_ENTERED DATE
Yes
PERIOD_EFFECTIVE VARCHAR2 (15) Yes
DATE_EFFECTIVE DATE
Yes
PERIOD_COUNTER NUMBER (15) Yes
PERIOD_ENTERED VARCHAR2 (15) Yes
COMMENTS VARCHAR2 (30)
ATTRIBUTE_CATEGORY_CODE VARCHAR2 (30)
INOVICE_TRANSACTION_ID NUMBER (15)
SOURCE_HEADER_ID NUMBER (15)
MASS_REFERENCE_ID NUMBER (15)
TRANSACTION_SUBTYPE VARCHAR2 (9)
TRANSACTION_KEY VARCHAR2 (2)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
TRX_REFERENCE_ID NUMBER (15)
TRX_REFERENCE_TYPE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (80)
Query Text

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


SELECT TRANSACTION_HEADER_ID
,      TRANSACTION_TYPE_CODE
,      BOOK_TYPE_CODE
,      TRANSACTION_TYPE
,      ASSET_ID
,      ASSET_NUMBER
,      ASSET_NUMBER_DESC
,      CATEGORY_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      TRANSACTION_DATE_ENTERED
,      PERIOD_EFFECTIVE
,      DATE_EFFECTIVE
,      PERIOD_COUNTER
,      PERIOD_ENTERED
,      COMMENTS
,      ATTRIBUTE_CATEGORY_CODE
,      INOVICE_TRANSACTION_ID
,      SOURCE_HEADER_ID
,      MASS_REFERENCE_ID
,      TRANSACTION_SUBTYPE
,      TRANSACTION_KEY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRX_REFERENCE_ID
,      TRX_REFERENCE_TYPE
,      DESCRIPTION
FROM APPS.FA_TRANSACTION_HISTORY_TRX_V;

Dependencies

[top of page]

APPS.FA_TRANSACTION_HISTORY_TRX_V references the following:

SchemaAPPS
SynonymFA_ADDITIONS_B
SynonymFA_ADDITIONS_TL
SynonymFA_ASSET_HISTORY
SynonymFA_BOOK_CONTROLS
SynonymFA_CALENDAR_PERIODS
SynonymFA_CATEGORIES
SynonymFA_DEPRN_PERIODS
SynonymFA_LOOKUPS_B
SynonymFA_LOOKUPS_TL
SynonymFA_TRANSACTION_HEADERS
SynonymFA_TRX_REFERENCES
APPS.FA_TRANSACTION_HISTORY_TRX_V is referenced by following:

SchemaAPPS
Package BodyJA_CN_FA_ACUI_EXPORT_PKG - show dependent code
Package BodyJA_CN_FA_AC_EXPORT_PKG - show dependent code
Package BodyJA_CN_FA_MM_EXPORT_PKG - show dependent code
Package BodyJA_CN_FA_RAI_EXPORT_PKG - show dependent code
Package BodyJA_CN_PS_FA_ACUI_EXP_PKG - show dependent code
Package BodyJA_CN_PS_FA_AC_EXP_PKG - show dependent code