[Home] [Help] [Dependency Information]
Object Name: | OKX_AST_DST_HST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_AST_DST_HST_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID1 | NUMBER | (15) | Yes | Primary key column. Unique distribution identification number |
ID2 | CHAR | (1) | Primary key column | |
NAME | VARCHAR2 | (15) | Yes | Unique identifier for asset |
DESCRIPTION | VARCHAR2 | (15) | Yes | Book name |
ASSET_ID | NUMBER | (15) | Yes | Unique identifier for asset |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book name |
DISTRIBUTION_ID | NUMBER | (15) | Yes | Unique identifier for distribution |
UNITS_ASSIGNED | NUMBER | Yes | Number of units assigned to the distribution | |
CODE_COMBINATION_ID | NUMBER | (15) | Yes | Depreciation expense account identification number |
LOCATION_ID | NUMBER | (15) | Yes | Location flexfield identification number |
TRANSACTION_HEADER_ID_IN | NUMBER | (15) | Yes | Identifies the transaction that created the distribution |
START_DATE_ACTIVE | DATE | Yes | Effective from date | |
END_DATE_ACTIVE | DATE | Effective to date | ||
STATUS | VARCHAR2 | (1) | Indicates whether the record is active or not | |
PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code | |
ASSIGNED_TO | NUMBER | (15) | Employee identification number | |
TRANSACTION_HEADER_ID_OUT | NUMBER | (15) | Identifies the transaction that made the distribution obsolete | |
TRANSACTION_UNITS | NUMBER | Number of units involved in the transaction. Negative for the row from which the units were transferred away or retired. Positive for the row to which the units were transferred or added | ||
RETIREMENT_ID | NUMBER | (15) | Identifies a retirement |
Cut, paste (and edit) the following text to query this object:
SELECT ID1
, ID2
, NAME
, DESCRIPTION
, ASSET_ID
, BOOK_TYPE_CODE
, DISTRIBUTION_ID
, UNITS_ASSIGNED
, CODE_COMBINATION_ID
, LOCATION_ID
, TRANSACTION_HEADER_ID_IN
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, STATUS
, PRIMARY_UOM_CODE
, ASSIGNED_TO
, TRANSACTION_HEADER_ID_OUT
, TRANSACTION_UNITS
, RETIREMENT_ID
FROM APPS.OKX_AST_DST_HST_V;
|
|
|