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

TABLE: FA.FA_ADJUSTMENTS

Object Details
Object Name: FA_ADJUSTMENTS
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_ADJUSTMENTS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_ADJUSTMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_HEADER_ID
ColumnADJUSTMENT_LINE_ID
FA_ADJUSTMENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDISTRIBUTION_ID
ColumnBOOK_TYPE_CODE
ColumnPERIOD_COUNTER_CREATED
ColumnSOURCE_TYPE_CODE
ColumnADJUSTMENT_TYPE
FA_ADJUSTMENTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSET_ID
ColumnBOOK_TYPE_CODE
ColumnPERIOD_COUNTER_CREATED
FA_ADJUSTMENTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJE_HEADER_ID
ColumnJE_LINE_NUM
FA_ADJUSTMENTS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERIOD_COUNTER_CREATED
ColumnBOOK_TYPE_CODE
FA_ADJUSTMENTS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCODE_COMBINATION_ID
ColumnBOOK_TYPE_CODE
ColumnPERIOD_COUNTER_CREATED
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_HEADER_ID NUMBER (15) Yes
SOURCE_TYPE_CODE VARCHAR2 (15) Yes
ADJUSTMENT_TYPE VARCHAR2 (15) Yes
DEBIT_CREDIT_FLAG VARCHAR2 (2) Yes
CODE_COMBINATION_ID NUMBER (15)
BOOK_TYPE_CODE VARCHAR2 (15) Yes
ASSET_ID NUMBER (15) Yes
ADJUSTMENT_AMOUNT NUMBER
Yes
DISTRIBUTION_ID NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
ANNUALIZED_ADJUSTMENT NUMBER

JE_HEADER_ID NUMBER (15)
JE_LINE_NUM NUMBER (15)
PERIOD_COUNTER_ADJUSTED NUMBER (15) Yes
PERIOD_COUNTER_CREATED NUMBER (15) Yes
ASSET_INVOICE_ID NUMBER (15)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
DEPRN_OVERRIDE_FLAG VARCHAR2 (1)
TRACK_MEMBER_FLAG VARCHAR2 (1)
ADJUSTMENT_LINE_ID NUMBER (15) Yes
SOURCE_LINE_ID NUMBER (15)
SOURCE_DEST_CODE VARCHAR2 (15)
Query Text

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


SELECT TRANSACTION_HEADER_ID
,      SOURCE_TYPE_CODE
,      ADJUSTMENT_TYPE
,      DEBIT_CREDIT_FLAG
,      CODE_COMBINATION_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      ADJUSTMENT_AMOUNT
,      DISTRIBUTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ANNUALIZED_ADJUSTMENT
,      JE_HEADER_ID
,      JE_LINE_NUM
,      PERIOD_COUNTER_ADJUSTED
,      PERIOD_COUNTER_CREATED
,      ASSET_INVOICE_ID
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      DEPRN_OVERRIDE_FLAG
,      TRACK_MEMBER_FLAG
,      ADJUSTMENT_LINE_ID
,      SOURCE_LINE_ID
,      SOURCE_DEST_CODE
FROM FA.FA_ADJUSTMENTS;

Dependencies

[top of page]

FA.FA_ADJUSTMENTS does not reference any database object

FA.FA_ADJUSTMENTS is referenced by following:

SchemaAPPS
SynonymFA_ADJUSTMENTS