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

VIEW: APPS.OKX_PRODUCT_LINES_V

Object Details
Object Name: OKX_PRODUCT_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_PRODUCT_LINES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID1 NUMBER
Yes Surrogate key used for primary unique identifiers
ID2 CHAR (1)
(Multi-part) Primary Key
NAME VARCHAR2 (240)
Item name.
DESCRIPTION VARCHAR2 (150) Yes Sequencial line number.
ITEM_DESCRIPTION VARCHAR2 (1995)
Item description.
COMMENTS VARCHAR2 (1995)
User entered comment.
CHR_ID NUMBER

Foreign key to OKC_K_HEADERS_B.
DNZ_CHR_ID NUMBER
Yes Contract ID. Denormalized for performance.
LTY_CODE VARCHAR2 (30) Yes Foreign key to FND_LOOKUP_VALUES.
LSE_TYPE VARCHAR2 (10) Yes Line style type ID.
LSE_PARENT_ID NUMBER

Parent ID.
LINE_NUMBER VARCHAR2 (150) Yes Sequencial line number
DATE_TERMINATED DATE

Date contract was terminated.
START_DATE_ACTIVE DATE

The beginning of the active period, one second after midnight on the date indicated.
END_DATE_ACTIVE DATE

The end of the active period, one second before midnight on the date indicated.
STATUS VARCHAR2 (1)
Status
INVENTORY_ITEM_ID VARCHAR2 (40)
Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view. This is here the id of the inventory item.
ORGANIZATION_ID NUMBER

Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view. This is here the id of the inventory organization the item belongs to.
QUANTITY NUMBER

Number of items.
UNIT_OF_MEASURE_CODE VARCHAR2 (3)
Unit of Measure code.
ITEM_NAME VARCHAR2 (240)
Item name.
PRIMARY_UOM_CODE VARCHAR2 (0)
Used for lines entry, list of UOM.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      ITEM_DESCRIPTION
,      COMMENTS
,      CHR_ID
,      DNZ_CHR_ID
,      LTY_CODE
,      LSE_TYPE
,      LSE_PARENT_ID
,      LINE_NUMBER
,      DATE_TERMINATED
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      QUANTITY
,      UNIT_OF_MEASURE_CODE
,      ITEM_NAME
,      PRIMARY_UOM_CODE
FROM APPS.OKX_PRODUCT_LINES_V;

Dependencies

[top of page]

APPS.OKX_PRODUCT_LINES_V references the following:

SchemaAPPS
SynonymOKC_K_ITEMS
SynonymOKC_K_LINES_B
SynonymOKC_K_LINES_TL
SynonymOKC_LINE_STYLES_B
ViewOKX_SYSTEM_ITEMS_V
APPS.OKX_PRODUCT_LINES_V is referenced by following:

SchemaAPPS
Package BodyOKC_OC_INT_KTQ_PVT - show dependent code