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

VIEW: APPS.OKX_INSTALL_ITEMS_V

Object Details
Object Name: OKX_INSTALL_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_INSTALL_ITEMS_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 ID that identifies an item unit instance ( Internally generated sequence number)
ID2 CHAR (1)
Primary key column
NAME VARCHAR2 (30) Yes Functional, user key to the item instance
DESCRIPTION CHAR (1)
Not used
START_DATE_ACTIVE DATE

Instance effective from date
END_DATE_ACTIVE DATE

Instance effective to date
STATUS VARCHAR2 (1)
Indicates whether the record is active or inactive
PRIMARY_UOM_CODE VARCHAR2 (3) Yes 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
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)
Last updated by
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
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      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
,      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_INSTALL_ITEMS_V;

Dependencies

[top of page]

APPS.OKX_INSTALL_ITEMS_V references the following:

SchemaAPPS
SynonymCSI_ITEM_INSTANCES
APPS.OKX_INSTALL_ITEMS_V is referenced by following:

SchemaAPPS
Package BodyOKL_ACTIVATE_IB_PVT - show dependent code
Package BodyOKL_AM_TERMNT_INTERFACE_PVT - show dependent code
Package BodyOKL_BLK_AST_UPD_PVT - show dependent code
Package BodyOKL_CONTRACT_LINE_ITEM_PVT - show dependent code
Package BodyOKL_COPY_ASSET_PVT - show dependent code
Package BodyOKL_COPY_CONTRACT_PVT - show dependent code
Package BodyOKL_CREATE_KLE_PVT - show dependent code
Package BodyOKL_EQUIPMENT_EXCHANGE_PVT - show dependent code
Package BodyOKL_INS_CLAIM_ASSET_PVT - show dependent code
Package BodyOKL_LA_VALIDATION_UTIL_PVT - show dependent code
Package BodyOKL_OPI_PVT - show dependent code
Package BodyOKL_SERVICE_INTEGRATION_PVT - show dependent code
Package BodyOKL_VERSION_PVT - show dependent code
ViewOKX_ITEM_INSTS_LINES_V