[Home] [Help] [Dependency Information]
Object Name: | OKL_AM_FIXED_ASSET_LOCATION_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_AM_FIXED_ASSET_LOCATION_UV |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
NAME | VARCHAR2 | (150) | Name | |
ITEM_DESCRIPTION | VARCHAR2 | (1995) | Item description. | |
CHR_ID | NUMBER | Contract Identifier | ||
CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract Number |
CONTRACT_STATUS | VARCHAR2 | (30) | Yes | Foreign key to FND_LOOKUP_VALUES. |
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End Date | ||
LINE_STATUS | VARCHAR2 | (30) | Yes | Line status code defined in FND_LOOKUPS. |
OEC | NUMBER | (14) | ||
ASSET_TYPE | VARCHAR2 | (11) | ||
CORPORATE_BOOK | VARCHAR2 | (15) | ||
FA_ASSET_ID | NUMBER | (15) | ||
FA_ASSET_NUMBER | VARCHAR2 | (15) | ||
DISTRIBUTION_ID | NUMBER | (15) | ||
UNITS_ASSIGNED | NUMBER | |||
TRANSACTION_UNITS | NUMBER | |||
CURRENT_UNITS | NUMBER | |||
ASSIGNED_TO | NUMBER | (15) | ||
CODE_COMBINATION_ID | NUMBER | (15) | Key flexfield combination defining column | |
LOCATION_ID | NUMBER | (15) | ||
LOCATION_NAME | VARCHAR2 | (216) | ||
NEW_LOCATION_NAME | VARCHAR2 | (0) | ||
NEW_LOCATION_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, NAME
, ITEM_DESCRIPTION
, CHR_ID
, CONTRACT_NUMBER
, CONTRACT_STATUS
, START_DATE
, END_DATE
, LINE_STATUS
, OEC
, ASSET_TYPE
, CORPORATE_BOOK
, FA_ASSET_ID
, FA_ASSET_NUMBER
, DISTRIBUTION_ID
, UNITS_ASSIGNED
, TRANSACTION_UNITS
, CURRENT_UNITS
, ASSIGNED_TO
, CODE_COMBINATION_ID
, LOCATION_ID
, LOCATION_NAME
, NEW_LOCATION_NAME
, NEW_LOCATION_ID
FROM APPS.OKL_AM_FIXED_ASSET_LOCATION_UV;
APPS.OKL_AM_FIXED_ASSET_LOCATION_UV is not referenced by any database object
|
|
|