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

TABLE: FA.FA_MASSADD_DISTRIBUTIONS

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


FA_MASSADD_DISTRIBUTIONS stores distribution information for each mass
addition line.
Scope: public
Lifecycle: active
Display Name: FA Mass Addition Distributions
Product: FA
Category: BUSINESS_ENTITY FA_ASSET


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_MASSADD_DISTRIBUTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnMASSADD_DIST_ID
FA_MASSADD_DISTRIBUTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnMASS_ADDITION_ID
FA_MASSADD_DISTRIBUTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnEMPLOYEE_ID
Columns
Name Datatype Length Mandatory Comments
MASSADD_DIST_ID NUMBER

Mass addition distribution identification number
MASS_ADDITION_ID NUMBER

Mass addition identification number
UNITS NUMBER

Number of units
DEPRN_EXPENSE_CCID NUMBER

Depreciation expense account segment
LOCATION_ID NUMBER

Location flexfield
EMPLOYEE_ID NUMBER

Employee identification number
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
Query Text

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


SELECT MASSADD_DIST_ID
,      MASS_ADDITION_ID
,      UNITS
,      DEPRN_EXPENSE_CCID
,      LOCATION_ID
,      EMPLOYEE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM FA.FA_MASSADD_DISTRIBUTIONS;

Dependencies

[top of page]

FA.FA_MASSADD_DISTRIBUTIONS does not reference any database object

FA.FA_MASSADD_DISTRIBUTIONS is referenced by following:

SchemaFA
ViewFA_MASSADD_DISTRIBUTIONS#