[Home] [Help] [Dependency Information]
Object Name: | OKL_LA_SERIAL_NUMBER_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_LA_SERIAL_NUMBER_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 | VARCHAR2 | (0) | Unique identifier for serial number (not used currently) | |
KLE_ID | NUMBER | Yes | Install base instance sub-line identifier | |
DNZ_CLE_ID | NUMBER | Yes | Financial Asset line identifier | |
DNZ_CHR_ID | NUMBER | Yes | Contract header identifier | |
SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number | |
INSTANCE_NUMBER_IB | VARCHAR2 | (30) | Yes | Install base instance number |
INVENTORY_ITEM_ID | NUMBER | Yes | Install base instance inventory item identifier | |
INVENTORY_ORG_ID | NUMBER | Install base instance inventory organization identifier | ||
INVENTORY_MASTER_ORG_ID | NUMBER | Yes | Install base instance inventory master organization identifier | |
OBJECT_ID1_NEW | NUMBER | (15) | Yes | Install base instance party install site identifier |
OBJECT_ID2_NEW | CHAR | (1) | Install base instance party install site identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, KLE_ID
, DNZ_CLE_ID
, DNZ_CHR_ID
, SERIAL_NUMBER
, INSTANCE_NUMBER_IB
, INVENTORY_ITEM_ID
, INVENTORY_ORG_ID
, INVENTORY_MASTER_ORG_ID
, OBJECT_ID1_NEW
, OBJECT_ID2_NEW
FROM APPS.OKL_LA_SERIAL_NUMBER_UV;
APPS.OKL_LA_SERIAL_NUMBER_UV is not referenced by any database object
|
|
|