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

VIEW: APPS.OKL_LA_SERIAL_NUMBER_UV

Object Details
Object Name: OKL_LA_SERIAL_NUMBER_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_LA_SERIAL_NUMBER_UV
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.OKL_LA_SERIAL_NUMBER_UV references the following:

SchemaAPPS
SynonymCSI_ITEM_INSTANCES
SynonymHZ_LOCATIONS
SynonymHZ_PARTY_SITES
SynonymHZ_PARTY_SITE_USES
SynonymOKC_K_ITEMS
SynonymOKC_K_LINES_B
SynonymOKC_LINE_STYLES_B

APPS.OKL_LA_SERIAL_NUMBER_UV is not referenced by any database object