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

VIEW: APPS.OKX_MODEL_LINES_V

Object Details
Object Name: OKX_MODEL_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_MODEL_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 Primary key column. Unique identifier for model line
ID2 CHAR (1)
Primary key column
NAME VARCHAR2 (240)
Model name. This is inventory item name
DESCRIPTION VARCHAR2 (150) Yes Line number
ITEM_DESCRIPTION VARCHAR2 (1995)
Model item description
COMMENTS VARCHAR2 (1995)
Comments
CHR_ID NUMBER

Unique identifier for contract
DNZ_CHR_ID NUMBER
Yes De-normalized unique identifier for contract
PARENT_LINE_ID NUMBER

Identifier for parent line
LTY_CODE VARCHAR2 (30) Yes Line style code
LSE_TYPE VARCHAR2 (10) Yes line style type. Whether line is a top-line or sub-line
LSE_PARENT_ID NUMBER

Parent line style identifier
LINE_NUMBER VARCHAR2 (150) Yes Line number
DATE_TERMINATED DATE

Date line terminated
START_DATE_ACTIVE DATE

Effective from date
END_DATE_ACTIVE DATE

Effective to date
STATUS VARCHAR2 (1)
Indicates whether model line is active or inactive
INVENTORY_ITEM_ID VARCHAR2 (40)
Identifier for model line inventory item
ORGANIZATION_ID NUMBER

Identifier for model line inventory organization
QUANTITY NUMBER

Quantity
UNIT_OF_MEASURE_CODE VARCHAR2 (3)
Unit of measure code
ITEM_NAME VARCHAR2 (240)
Name of model line item
PRIMARY_UOM_CODE VARCHAR2 (0)
Primary unit of measue code
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
,      PARENT_LINE_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_MODEL_LINES_V;

Dependencies

[top of page]

APPS.OKX_MODEL_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_MODEL_LINES_V is referenced by following:

SchemaAPPS
Package BodyOKL_AM_ASSET_RETURN_PVT - show dependent code
ViewOKL_AM_RESIDUAL_VALUE_WD_UV