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


VIEW: APPS.CZ_EXV_ITEMS

Object Details
Object Name: CZ_EXV_ITEMS
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
SEGMENT1 VARCHAR2 (40)
FIXED_LEAD_TIME NUMBER

START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

CUSTOMER_ORDER_ENABLED_FLAG VARCHAR2 (1) Yes
INDIVISIBLE_FLAG VARCHAR2 (1)
CONCATENATED_SEGMENTS VARCHAR2 (40)
INVENTORY_ITEM_STATUS_CODE VARCHAR2 (10) Yes
ITEM_CATALOG_GROUP_ID NUMBER

PRIMARY_UOM_CODE VARCHAR2 (3)
BOM_ITEM_TYPE NUMBER
Yes
DESCRIPTION VARCHAR2 (240)
ITEM_DESC VARCHAR2 (240)
TOP_ITEM_ID NUMBER
Yes
EXPLOSION_TYPE VARCHAR2 (20) Yes
INV_APPLICATION_ID NUMBER

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SEGMENT1
,      FIXED_LEAD_TIME
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CUSTOMER_ORDER_ENABLED_FLAG
,      INDIVISIBLE_FLAG
,      CONCATENATED_SEGMENTS
,      INVENTORY_ITEM_STATUS_CODE
,      ITEM_CATALOG_GROUP_ID
,      PRIMARY_UOM_CODE
,      BOM_ITEM_TYPE
,      DESCRIPTION
,      ITEM_DESC
,      TOP_ITEM_ID
,      EXPLOSION_TYPE
,      INV_APPLICATION_ID
FROM APPS.CZ_EXV_ITEMS;

Dependencies

[top of page]

APPS.CZ_EXV_ITEMS references the following:

SchemaAPPS
ViewBOM_BILL_OF_MATERIALS
SynonymBOM_EXPLOSIONS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_SYSTEM_ITEMS_TL
APPS.CZ_EXV_ITEMS is referenced by following:

SchemaAPPS
Package BodyCZ_IMP_SINGLE - show dependent code