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

VIEW: APPS.ICX_OE_DIRECT_ITEMS_V

Object Details
Object Name: ICX_OE_DIRECT_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_OE_DIRECT_ITEMS_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

ITEM_NUMBER VARCHAR2 (40)
ITEM_DESCRIPTION VARCHAR2 (240)
QUANTITY VARCHAR2 (0)
UNIT_OF_MEASURE VARCHAR2 (25) Yes
PRICE NUMBER

PRICE_LIST_ID NUMBER
Yes
PRICE_LIST_LINE_ID NUMBER
Yes
ORG_ID NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_ADDRESS_ID NUMBER

CUSTOMER_ITEM_ID NUMBER

CUSTOMER_ITEM_NAME VARCHAR2 (50)
CUSTOMER_CATEGORY_CODE VARCHAR2 (30)
ITEM_DEFINITION_LEVEL VARCHAR2 (1)
MASTER_ORGANIZATION_ID NUMBER
Yes
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      QUANTITY
,      UNIT_OF_MEASURE
,      PRICE
,      PRICE_LIST_ID
,      PRICE_LIST_LINE_ID
,      ORG_ID
,      CUSTOMER_ID
,      CUSTOMER_ADDRESS_ID
,      CUSTOMER_ITEM_ID
,      CUSTOMER_ITEM_NAME
,      CUSTOMER_CATEGORY_CODE
,      ITEM_DEFINITION_LEVEL
,      MASTER_ORGANIZATION_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
FROM APPS.ICX_OE_DIRECT_ITEMS_V;

Dependencies

[top of page]

APPS.ICX_OE_DIRECT_ITEMS_V references the following:

SchemaAPPS
SynonymFND_PROFILE_OPTIONS
SynonymFND_PROFILE_OPTION_VALUES
SynonymICX_WEB_STORE_OPTIONS
SynonymMTL_CUSTOMER_ITEMS
SynonymMTL_CUSTOMER_ITEM_XREFS
SynonymMTL_ITEM_CATEGORIES
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_UNITS_OF_MEASURE
PL/SQL PackageQP_PRICE_LIST_PVT - show dependent code
PL/SQL PackageQP_UTIL - show dependent code
SynonymSO_PRICE_LIST_LINES

APPS.ICX_OE_DIRECT_ITEMS_V is not referenced by any database object