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

VIEW: APPS.OKX_ITEM_INSTS_LINES_V

Object Details
Object Name: OKX_ITEM_INSTS_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_ITEM_INSTS_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 Install Base instance line of Lease contract
ID2 CHAR (1)
Primary key column
NAME VARCHAR2 (150)
Instance number
DESCRIPTION VARCHAR2 (150) Yes Line number
ITEM_DESCRIPTION VARCHAR2 (1995)
Not used
COMMENTS VARCHAR2 (1995)
Comments
CHR_ID NUMBER

Unique identifier for contract
DNZ_CHR_ID NUMBER
Yes Denormalized unique identifier for contract
LTY_CODE VARCHAR2 (30) Yes Line style code
LSE_TYPE VARCHAR2 (10) Yes Line style type. Indicates 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 instance was terminated
START_DATE_ACTIVE DATE

Effective from date
END_DATE_ACTIVE DATE

Effective to date
STATUS VARCHAR2 (1)
Indicates whether instance line is active or inactive
CUSTOMER_PRODUCT_ID VARCHAR2 (40)
Unque identifier for customer product
REFERENCE_NUMBER VARCHAR2 (200)
Customer product reference number
ITEM_QUANTITY NUMBER

Instance quantity
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary unit of measure code
INSTANCE_ID NUMBER
Yes Unique ID that identifies an item unit instance ( Internally generated sequence number)
INSTANCE_NUMBER VARCHAR2 (30) Yes Functional, user key to the item instance
EXTERNAL_REFERENCE VARCHAR2 (30)
External reference, like customer asset tag
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Identifier from MTL_SYSTEM_ITEMS_B
INVENTORY_REVISION VARCHAR2 (3)
Inventory Revision Code
INV_MASTER_ORGANIZATION_ID NUMBER
Yes Inventory Master Organization Identifier from MTL_ORGANIZATIONS
SERIAL_NUMBER VARCHAR2 (30)
Serial Number of the Instance
MFG_SERIAL_NUMBER_FLAG VARCHAR2 (1)
Flag indicating if the Serial Number is a manufacturer's Serial number
LOT_NUMBER VARCHAR2 (80)
Lot Number
QUANTITY NUMBER
Yes Quantity
UNIT_OF_MEASURE VARCHAR2 (3) Yes Unit of Measure Code
ACCOUNTING_CLASS_CODE VARCHAR2 (10)
Accounting Classification Code
INSTANCE_CONDITION_ID NUMBER

Instance Condition Identifier
INSTANCE_STATUS_ID NUMBER
Yes Instance Status Identifier
CUSTOMER_VIEW_FLAG VARCHAR2 (1) Yes Flag indicating if the Instance is as per the Customer Definition
MERCHANT_VIEW_FLAG VARCHAR2 (1) Yes Flag indicating if the instance is as per the Merchant View
SELLABLE_FLAG VARCHAR2 (1)
Flag indicating if the Instance is sellable
SYSTEM_ID NUMBER

System Identifier to which the Instance is a part of
INSTANCE_TYPE_CODE VARCHAR2 (30)
Instance Type Code
INSTANCE_ACTIVE_START_DATE DATE

Activation Start Date
INSTANCE_ACTIVE_END_DATE DATE

Activation End Date
LOCATION_TYPE_CODE VARCHAR2 (30)
Location Type Code
LOCATION_ID NUMBER

Location Identifier
INV_ORGANIZATION_ID NUMBER

Inventory Organization Identifier
INV_SUBINVENTORY_NAME VARCHAR2 (10)
Inventory Sub-Inventory Name
INV_LOCATOR_ID NUMBER

Inventory Locator Identifier
PA_PROJECT_ID NUMBER

Project Identifier from Project Accounting
PA_PROJECT_TASK_ID NUMBER

Project Task Identifier from Project Accounting
IN_TRANSIT_ORDER_LINE_ID NUMBER

Order Line Identifier for an In-Transit Order (Internal Order)
WIP_JOB_ID NUMBER

WIP Job Identifier
PO_ORDER_LINE_ID NUMBER

Purchase Order Line Identifier
LAST_OE_ORDER_LINE_ID NUMBER

Last Order Line Idetifier that touched the Instance
LAST_OE_RMA_LINE_ID NUMBER

Last RMA Line Identifier that touched the Instance
LAST_PO_PO_LINE_ID NUMBER

Last Purchase Order Line Identifier from Purchasing
LAST_OE_PO_NUMBER VARCHAR2 (50)
Last Order Entry Purchase Order Number
LAST_WIP_JOB_ID NUMBER

Last WIP job Identifier
LAST_PA_PROJECT_ID NUMBER

Last Project Identifier from Project Accounting
LAST_PA_TASK_ID NUMBER

Last Task Identifier from Project Accounting
LAST_OE_AGREEMENT_ID NUMBER

Last Agreement Identifier from Order Entry
INSTALL_DATE DATE

Installation Date for an Instance
MANUALLY_CREATED_FLAG VARCHAR2 (1)
Flag indicating if the instance is created manually
RETURN_BY_DATE DATE

Date the Instance to be returned
ACTUAL_RETURN_DATE DATE

Date of the Actual Return
CREATION_COMPLETE_FLAG VARCHAR2 (1)
Flag indicating if the Instance Creation is complete
COMPLETENESS_FLAG VARCHAR2 (1)
Flag indicating if the Instance Configuration is Complete
LAST_UPDATE_LOGIN NUMBER (15)
Identifier for last updated by person
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
SECURITY_GROUP_ID NUMBER

Security group identifier
LAST_TXN_LINE_DETAIL_ID NUMBER

Transaction Line Detail Identifier
INSTALL_LOCATION_TYPE_CODE VARCHAR2 (30)
Install Location Type Code
INSTALL_LOCATION_ID NUMBER

Install Location Identifier
INSTANCE_USAGE_CODE VARCHAR2 (30)
Instance Usage Code
OWNER_PARTY_SOURCE_TABLE VARCHAR2 (30)
De-normalized Column for Instance Owner Party Source Table
OWNER_PARTY_ID NUMBER

De-normalized Column for Instance Owner Party Identifier
OWNER_PARTY_ACCOUNT_ID NUMBER

De-normalized Column for Instance Owner Party Account Identifier
LAST_VLD_ORGANIZATION_ID NUMBER

The Organization Identifier by which the Instance was validated Last
MIGRATED_FLAG VARCHAR2 (1)
Not used
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
,      CUSTOMER_PRODUCT_ID
,      REFERENCE_NUMBER
,      ITEM_QUANTITY
,      PRIMARY_UOM_CODE
,      INSTANCE_ID
,      INSTANCE_NUMBER
,      EXTERNAL_REFERENCE
,      INVENTORY_ITEM_ID
,      INVENTORY_REVISION
,      INV_MASTER_ORGANIZATION_ID
,      SERIAL_NUMBER
,      MFG_SERIAL_NUMBER_FLAG
,      LOT_NUMBER
,      QUANTITY
,      UNIT_OF_MEASURE
,      ACCOUNTING_CLASS_CODE
,      INSTANCE_CONDITION_ID
,      INSTANCE_STATUS_ID
,      CUSTOMER_VIEW_FLAG
,      MERCHANT_VIEW_FLAG
,      SELLABLE_FLAG
,      SYSTEM_ID
,      INSTANCE_TYPE_CODE
,      INSTANCE_ACTIVE_START_DATE
,      INSTANCE_ACTIVE_END_DATE
,      LOCATION_TYPE_CODE
,      LOCATION_ID
,      INV_ORGANIZATION_ID
,      INV_SUBINVENTORY_NAME
,      INV_LOCATOR_ID
,      PA_PROJECT_ID
,      PA_PROJECT_TASK_ID
,      IN_TRANSIT_ORDER_LINE_ID
,      WIP_JOB_ID
,      PO_ORDER_LINE_ID
,      LAST_OE_ORDER_LINE_ID
,      LAST_OE_RMA_LINE_ID
,      LAST_PO_PO_LINE_ID
,      LAST_OE_PO_NUMBER
,      LAST_WIP_JOB_ID
,      LAST_PA_PROJECT_ID
,      LAST_PA_TASK_ID
,      LAST_OE_AGREEMENT_ID
,      INSTALL_DATE
,      MANUALLY_CREATED_FLAG
,      RETURN_BY_DATE
,      ACTUAL_RETURN_DATE
,      CREATION_COMPLETE_FLAG
,      COMPLETENESS_FLAG
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      LAST_TXN_LINE_DETAIL_ID
,      INSTALL_LOCATION_TYPE_CODE
,      INSTALL_LOCATION_ID
,      INSTANCE_USAGE_CODE
,      OWNER_PARTY_SOURCE_TABLE
,      OWNER_PARTY_ID
,      OWNER_PARTY_ACCOUNT_ID
,      LAST_VLD_ORGANIZATION_ID
,      MIGRATED_FLAG
FROM APPS.OKX_ITEM_INSTS_LINES_V;

Dependencies

[top of page]

APPS.OKX_ITEM_INSTS_LINES_V references the following:

SchemaAPPS
SynonymOKC_K_ITEMS
SynonymOKC_K_LINES_B
SynonymOKC_K_LINES_TL
SynonymOKC_LINE_STYLES_B
ViewOKX_INSTALL_ITEMS_V

APPS.OKX_ITEM_INSTS_LINES_V is not referenced by any database object