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

TABLE: FA.FA_PERIODIC_PRODUCTION

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


This table contains production information for assets using the
units of production depreciation method. Rows are entered
using the Enter Production form or
uploaded from the FA_PRODUCTION_INTERFACE table.
.
FA_PERIODIC_PRODUCTION stores the production amounts for an
asset between a particular date range. Date ranges
may not overlap. The depreciation
program uses this production amount to calculate
depreciation, and then marks it by changing the USED_FLAG to YES.
.
This information is also used by depreciation projections.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_PERIODIC_PRODUCTION_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSET_ID
ColumnBOOK_TYPE_CODE
ColumnSTART_DATE
ColumnEND_DATE
Columns
Name Datatype Length Mandatory Comments
ASSET_ID NUMBER (15) Yes Asset identification number
BOOK_TYPE_CODE VARCHAR2 (15) Yes Corporate book name
START_DATE DATE
Yes First date of range
END_DATE DATE
Yes Last date of range
PRODUCTION NUMBER
Yes Production amount for asset during date range
USED_FLAG VARCHAR2 (3) Yes YES if the depreciation program has used this amount to calculate depreciation for the asset
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY_CODE VARCHAR2 (30)
Descriptive flexfield structure defining column
Query Text

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


SELECT ASSET_ID
,      BOOK_TYPE_CODE
,      START_DATE
,      END_DATE
,      PRODUCTION
,      USED_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
FROM FA.FA_PERIODIC_PRODUCTION;

Dependencies

[top of page]

FA.FA_PERIODIC_PRODUCTION does not reference any database object

FA.FA_PERIODIC_PRODUCTION is referenced by following:

SchemaFA
ViewFA_PERIODIC_PRODUCTION#