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

VIEW: APPS.ICX_CATALOG_ORD_ITEMS_V

Object Details
Object Name: ICX_CATALOG_ORD_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_CATALOG_ORD_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
ITEM_ID NUMBER


REQ_NUMBER VARCHAR2 (20) Yes
REQUISITION_HEADER_ID NUMBER
Yes
REQUISITION_LINE_ID NUMBER
Yes
CATEGORY_ID NUMBER
Yes
VENDOR_ID NUMBER


CREATION_DATE DATE


LINE_NUM NUMBER
Yes
ITEM_NUMBER VARCHAR2 (4000)

ITEM_DESCRIPTION VARCHAR2 (240) Yes
UNIT_PRICE NUMBER


QUANTITY NUMBER


UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)

EXT_AMOUNT NUMBER

Extended price
Query Text

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


SELECT ITEM_ID
,      REQ_NUMBER
,      REQUISITION_HEADER_ID
,      REQUISITION_LINE_ID
,      CATEGORY_ID
,      VENDOR_ID
,      CREATION_DATE
,      LINE_NUM
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      UNIT_PRICE
,      QUANTITY
,      UNIT_MEAS_LOOKUP_CODE
,      EXT_AMOUNT
FROM APPS.ICX_CATALOG_ORD_ITEMS_V;

Dependencies

[top of page]

APPS.ICX_CATALOG_ORD_ITEMS_V references the following:

SchemaAPPS
PL/SQL PackageICX_UTIL - show dependent code
SynonymMTL_SYSTEM_ITEMS
SynonymPO_REQUISITION_HEADERS
SynonymPO_REQUISITION_LINES

APPS.ICX_CATALOG_ORD_ITEMS_V is not referenced by any database object