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

VIEW: APPS.OKX_SYSTEM_ITEMS_V

Object Details
Object Name: OKX_SYSTEM_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_SYSTEM_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 Inventory item identifier
ID2 NUMBER
Yes Organization identifier
NAME VARCHAR2 (240)
Item name.
DESCRIPTION VARCHAR2 (40)
This column contains Item translated description
CUSTOMER_ORDER_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is customer orderable
SERVICE_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating service item
VENDOR_WARRANTY_FLAG VARCHAR2 (1) Yes Flag indicating service for the item is provided by a supplier
SERVICEABLE_PRODUCT_FLAG VARCHAR2 (1) Yes Indicates whether the item is serviceable by other service-type items and can have service requests reported against it
COVERAGE_TEMPLATE_ID NUMBER

Coverage schedule identifier
ITEM_TYPE VARCHAR2 (30)
User-defined item type
B_STATUS VARCHAR2 (1) Yes Flexfield segment enabled flag
STATUS VARCHAR2 (1)
Status
START_DATE_ACTIVE DATE

Flexfield segment start date
END_DATE_ACTIVE DATE

Flexfield segment end date
SHIPPABLE_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating shippable item
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary unit of measure code
USAGE_ITEM_FLAG VARCHAR2 (1)
Flag indicating an item represents usage. Usage items can be sold as a use of something
SERVICE_STARTING_DELAY NUMBER

Days after shipment that service begins
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
SEGMENT1 VARCHAR2 (40)
Key flexfield segment
SEGMENT2 VARCHAR2 (40)
Key flexfield segment
SEGMENT3 VARCHAR2 (40)
Key flexfield segment
SEGMENT4 VARCHAR2 (40)
Key flexfield segment
SEGMENT5 VARCHAR2 (40)
Key flexfield segment
SEGMENT6 VARCHAR2 (40)
Key flexfield segment
SEGMENT7 VARCHAR2 (40)
Key flexfield segment
SEGMENT8 VARCHAR2 (40)
Key flexfield segment
SEGMENT9 VARCHAR2 (40)
Key flexfield segment
SEGMENT10 VARCHAR2 (40)
Key flexfield segment
SEGMENT11 VARCHAR2 (40)
Key flexfield segment
SEGMENT12 VARCHAR2 (40)
Key flexfield segment
SEGMENT13 VARCHAR2 (40)
Key flexfield segment
SEGMENT14 VARCHAR2 (40)
Key flexfield segment
SEGMENT15 VARCHAR2 (40)
Key flexfield segment
SEGMENT16 VARCHAR2 (40)
Key flexfield segment
SEGMENT17 VARCHAR2 (40)
Key flexfield segment
SEGMENT18 VARCHAR2 (40)
Key flexfield segment
SEGMENT19 VARCHAR2 (40)
Key flexfield segment
SEGMENT20 VARCHAR2 (40)
Key flexfield segment
CUSTOMER_ORDER_FLAG VARCHAR2 (1) Yes
INTERNAL_ORDER_FLAG VARCHAR2 (1) Yes
INTERNAL_ORDER_ENABLED_FLAG VARCHAR2 (1) Yes
INVOICEABLE_ITEM_FLAG VARCHAR2 (1) Yes
INVOICE_ENABLED_FLAG VARCHAR2 (1) Yes
BOM_ITEM_TYPE NUMBER
Yes Type of item
INVENTORY_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating inventory item
BOM_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item may appear on a BOM
LIST_PRICE_PER_UNIT NUMBER

Unit list price - purchasing
ATP_FLAG VARCHAR2 (1) Yes Flag indicating ATP must be checked when item is ordered
INVENTORY_ITEM_STATUS_CODE VARCHAR2 (10) Yes Material status code
PURCHASING_ITEM_FLAG VARCHAR2 (1) Yes Purchasing Item Flag
EXPENSE_ACCOUNT NUMBER

Refer to column description of the base table
PURCHASING_ENABLED_FLAG VARCHAR2 (1) Yes
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Global descriptive flexfield structure defining column
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Global descriptive flexfield segment
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      CUSTOMER_ORDER_ENABLED_FLAG
,      SERVICE_ITEM_FLAG
,      VENDOR_WARRANTY_FLAG
,      SERVICEABLE_PRODUCT_FLAG
,      COVERAGE_TEMPLATE_ID
,      ITEM_TYPE
,      B_STATUS
,      STATUS
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SHIPPABLE_ITEM_FLAG
,      PRIMARY_UOM_CODE
,      USAGE_ITEM_FLAG
,      SERVICE_STARTING_DELAY
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      CUSTOMER_ORDER_FLAG
,      INTERNAL_ORDER_FLAG
,      INTERNAL_ORDER_ENABLED_FLAG
,      INVOICEABLE_ITEM_FLAG
,      INVOICE_ENABLED_FLAG
,      BOM_ITEM_TYPE
,      INVENTORY_ITEM_FLAG
,      BOM_ENABLED_FLAG
,      LIST_PRICE_PER_UNIT
,      ATP_FLAG
,      INVENTORY_ITEM_STATUS_CODE
,      PURCHASING_ITEM_FLAG
,      EXPENSE_ACCOUNT
,      PURCHASING_ENABLED_FLAG
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
FROM APPS.OKX_SYSTEM_ITEMS_V;

Dependencies

[top of page]

APPS.OKX_SYSTEM_ITEMS_V references the following:

SchemaAPPS
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymMTL_SYSTEM_ITEMS_TL
APPS.OKX_SYSTEM_ITEMS_V is referenced by following:

SchemaAPPS
Package BodyCSL_CONTRACT_HANDLING_PKG - show dependent code
Package BodyCSM_CONTRACT_EVENT_PKG - show dependent code
Package BodyOKC_COPY_CONTRACT_PVT - show dependent code
Package BodyOKC_CREATE_PO_FROM_K_PVT - show dependent code
Package BodyOKC_OC_INT_KTQ_PVT - show dependent code
Package BodyOKC_PRICE_PUB - show dependent code
ViewOKC_REL_OBJ_OPP_LINES_V
ViewOKC_REL_OBJ_ORDER_LINES_V
ViewOKC_REL_OBJ_QUOTE_LINES_V
ViewOKI_SOLD_ITEM_LINES_V
ViewOKI_TOP_LINES_V
Package BodyOKL_AM_CNTRCT_LN_TRMNT_PVT - show dependent code
Package BodyOKL_ART_PVT - show dependent code
Package BodyOKL_ASD_PVT - show dependent code
ViewOKL_BPD_CNTR_PRICE_LIST_UV
Package BodyOKL_CONTRACT_LINE_ITEM_PVT - show dependent code
ViewOKL_CS_AST_ADDONS_UV
ViewOKL_CS_PAY_LINE_DTL_UV
ViewOKL_CS_SERVICE_ASSETS_UV
ViewOKL_CS_SERVICE_LINES_UV
ViewOKL_FEE_SERVICE_STRMS_UV
ViewOKL_INS_PRODUCTS_UV
Package BodyOKL_IPT_PVT - show dependent code
Package BodyOKL_ITI_PVT - show dependent code
ViewOKL_LA_PAYMENTS_SUMMARY_UV
Package BodyOKL_LA_VALIDATION_UTIL_PVT - show dependent code
ViewOKL_LINE_STREAMS_UV
ViewOKL_LINE_STRMS_SUM_UV
Package BodyOKL_OPEN_INTERFACE_PVT - show dependent code
Package BodyOKL_POOLCONC_PVT - show dependent code
ViewOKL_POOL_ASSETS_UV
PL/SQL PackageOKL_POOL_PVT - show dependent code
ViewOKL_PYMTS_SERVICE_INSTS_UV
Package BodyOKL_SERVICE_INTEGRATION_PVT - show dependent code
Package BodyOKL_SPLIT_ASSET_COMP_PVT - show dependent code
ViewOKL_SPLIT_ASSET_COMP_UV
ViewOKL_UBB_USAGE_ITEMS_UV
Package BodyOKS_AUTH_UTIL_PVT - show dependent code
Package BodyOKS_AUTO_REMINDER - show dependent code
ViewOKS_BILLPRST_SRVLINE_V
ViewOKS_BILLPRST_SRVSUBLINE_V
ViewOKS_BILLPRST_SUBSCRLINE_V
ViewOKS_BILLPRST_USGSUBLINE_V
Package BodyOKS_BILL_UTIL_PUB - show dependent code
Package BodyOKS_CONTRACTS_PUB - show dependent code
Package BodyOKS_COVERAGES_PUB - show dependent code
ViewOKS_COVERED_LEVEL_V
Package BodyOKS_ENTITLEMENTS_PVT - show dependent code
Package BodyOKS_ENT_UTIL_PVT - show dependent code
Package BodyOKS_EXTWARPRGM_OSO_PVT - show dependent code
Package BodyOKS_EXTWARPRGM_PVT - show dependent code
Package BodyOKS_EXTWAR_UTIL_PVT - show dependent code
Package BodyOKS_IBINT_PUB - show dependent code
ViewOKS_LINE_DETAILS_V
Package BodyOKS_OCINT_PUB - show dependent code
Package BodyOKS_OC_INT_KTO_PVT - show dependent code
Package BodyOKS_OKSCODET_XMLP_PKG - show dependent code
Package BodyOKS_OMINT_PUB - show dependent code
ViewOKS_ORDER_V
ViewOKS_PROD_DETAILS_V
ViewOKS_SERV_HDR_V
ViewOKS_SERV_PRODEXC_V
ViewOKS_USAGE_COUNTERS_V
ViewOKX_COVERED_LINES_V
ViewOKX_MODEL_LINES_V
ViewOKX_PRODUCT_LINES_V