[Home] [Help] [Dependency Information]
Object Name: | OKL_LA_ITEM_DTLS_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_LA_ITEM_DTLS_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 | System generated unique identifier. Primary key column of the table. | |
PARENT_LINE_ID | NUMBER | ID of the parent Line. A line can have sub-lines. Refers to ID in OKC_K_LINES_B. | ||
UNIT_COST | VARCHAR2 | (40) | Unit Cost | |
DNZ_CHR_ID | NUMBER | Yes | Contract Id demormalized for performance | |
ID1 | VARCHAR2 | (40) | Foreign Key for OKX view reference | |
ID2 | VARCHAR2 | (200) | Foreign Key for OKX view reference | |
OBJECT_CODE | VARCHAR2 | (30) | Object Code in OKX View | |
QUANTITY | NUMBER | Quantity | ||
NAME | VARCHAR2 | (240) | Item Name | |
DESCRIPTION | VARCHAR2 | (240) | Item Description | |
MANUFACTURER_NAME | VARCHAR2 | (30) | Manufacturer Name | |
MODEL_NUMBER | VARCHAR2 | (40) | Model Number | |
YEAR_OF_MANUFACTURE | VARCHAR2 | (240) | Year of manufacturing | |
VENDOR_NAME | VARCHAR2 | (0) | vandor name | |
VENDOR_ID | VARCHAR2 | (40) | vendor id | |
CPL_ID | NUMBER | Party Role ID | ||
NOTES | VARCHAR2 | (1995) | notes |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, PARENT_LINE_ID
, UNIT_COST
, DNZ_CHR_ID
, ID1
, ID2
, OBJECT_CODE
, QUANTITY
, NAME
, DESCRIPTION
, MANUFACTURER_NAME
, MODEL_NUMBER
, YEAR_OF_MANUFACTURE
, VENDOR_NAME
, VENDOR_ID
, CPL_ID
, NOTES
FROM APPS.OKL_LA_ITEM_DTLS_UV;
APPS.OKL_LA_ITEM_DTLS_UV is not referenced by any database object
|
|
|