[Home] [Help] [Dependency Information]
Object Name: | OKL_AM_ITEM_LOCATION_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_AM_ITEM_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 |
---|---|---|---|---|
CHR_ID | NUMBER | Contract Identifier | ||
CLE_ID_FIN_ASSET | NUMBER | Primary key column. | ||
CLE_ID_INST_LINE | NUMBER | Primary key column. | ||
CLE_ID_INST_BASE | NUMBER | Primary key column. | ||
INSTANCE_ID | NUMBER | Unique ID that identifies an item unit instance ( Internally generated sequence number ) | ||
IB_SERIAL_NUMBER | VARCHAR2 | (30) | ||
PARTY_ID | NUMBER | (15) | Party identifier | |
PARTY_SITE_ID | NUMBER | (15) | Party site identifier | |
PARTY_SITE_USE_ID | NUMBER | (15) | Party site use identifier | |
LOCATION_ID | NUMBER | (15) | Unique identifier for this location | |
CONTRACT_NUMBER | VARCHAR2 | (120) | Contract Number | |
ASSET_NUMBER | VARCHAR2 | (150) | Asset Number | |
ASSET_DESCRIPTION | VARCHAR2 | (1995) | Item description. | |
END_DATE | DATE | End Date | ||
INSTANCE_NUMBER | VARCHAR2 | (30) | Functional, user key to the item instance | |
INSTANCE_START_DATE | DATE | Activation Start Date. | ||
INSTANCE_END_DATE | DATE | Activation End Date. | ||
PARTY_NUMBER | VARCHAR2 | (30) | Unique identification number for this party | |
PARTY_NAME | VARCHAR2 | (360) | Name of this party | |
PARTY_SITE_NUMBER | VARCHAR2 | (30) | Party site number | |
PARTY_SITE_NAME | VARCHAR2 | (240) | User-defined name for the site | |
LOCATION_DESCRIPTION | VARCHAR2 | (2000) | An extensive description of the location | |
LOCATION_ADDRESS | VARCHAR2 | (80) | ||
NEW_LOCATION_ADDRESS | VARCHAR2 | (0) | ||
NEW_LOCATION_ID | NUMBER | |||
NEW_INSTALLED_LOCATION_ID | NUMBER | |||
CHANGE_PARTY_FLAG | VARCHAR2 | (0) | ||
NEW_PARTY_NAME | VARCHAR2 | (0) |
Cut, paste (and edit) the following text to query this object:
SELECT CHR_ID
, CLE_ID_FIN_ASSET
, CLE_ID_INST_LINE
, CLE_ID_INST_BASE
, INSTANCE_ID
, IB_SERIAL_NUMBER
, PARTY_ID
, PARTY_SITE_ID
, PARTY_SITE_USE_ID
, LOCATION_ID
, CONTRACT_NUMBER
, ASSET_NUMBER
, ASSET_DESCRIPTION
, END_DATE
, INSTANCE_NUMBER
, INSTANCE_START_DATE
, INSTANCE_END_DATE
, PARTY_NUMBER
, PARTY_NAME
, PARTY_SITE_NUMBER
, PARTY_SITE_NAME
, LOCATION_DESCRIPTION
, LOCATION_ADDRESS
, NEW_LOCATION_ADDRESS
, NEW_LOCATION_ID
, NEW_INSTALLED_LOCATION_ID
, CHANGE_PARTY_FLAG
, NEW_PARTY_NAME
FROM APPS.OKL_AM_ITEM_LOCATION_UV;
APPS.OKL_AM_ITEM_LOCATION_UV is not referenced by any database object
|
|
|