eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.ICX_CAT_AGREEMENT_ATTRS_V

Object Details

Object Name:	ICX_CAT_AGREEMENT_ATTRS_V
Object Type:	VIEW
Owner:	APPS
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
ATTRIBUTE_ID	NUMBER		Yes	Internal identifier for a Descriptor.
LANGUAGE	VARCHAR2	(4)	Yes	Defined language for the row
ATTRIBUTE_NAME	VARCHAR2	(250)	Yes	Attribute Name
DESCRIPTION	VARCHAR2	(2000)		Description
SEQUENCE	NUMBER			Sequence of the descriptor
RT_CATEGORY_ID	NUMBER		Yes	Item Category Id. (References ICX_CAT_CATEGORIES_TL.rt_category_id)
TYPE	NUMBER		Yes	Type of the descriptor. Stores 0 for Text based descriptor1 for Numeric descriptor2 for Translatable text based descriptor.
KEY	VARCHAR2	(250)	Yes	Descriptor Key
STORED_IN_TABLE	VARCHAR2	(30)		Table where the Attribute's Value is stored. Valid values are null : When the Attribute's value is either calculated or stored in PO_LINES_ALL table. PO_ATTRIBUTE_VALUES : When the Attribute's value is stored in PO_ATTRUBUTE_VALUES PO_ATTRIBUTE_VALUES_TLP : When the Attribute's value is stored in PO_ATTRUBUTE_VALUES_TLP
STORED_IN_COLUMN	VARCHAR2	(30)		Stored in column. The column in which the descriptor value is populated.

Query Text

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


SELECT ATTRIBUTE_ID
,      LANGUAGE
,      ATTRIBUTE_NAME
,      DESCRIPTION
,      SEQUENCE
,      RT_CATEGORY_ID
,      TYPE
,      KEY
,      STORED_IN_TABLE
,      STORED_IN_COLUMN
FROM APPS.ICX_CAT_AGREEMENT_ATTRS_V;

Dependencies

[top of page]

APPS.ICX_CAT_AGREEMENT_ATTRS_V references the following:

APPS: ICX_CAT_ATTRIBUTES_TL

APPS.ICX_CAT_AGREEMENT_ATTRS_V is referenced by following:

APPS: PON_AUCTION_CREATE_PO_PKG - show dependent code; PON_AUCTION_INTERFACE_PKG - show dependent code; PON_AUC_INTERFACE_TABLE_PKG - show dependent code; PON_NEGOTIATION_COPY_GRP - show dependent code; PON_UNSOL_CREATE_PO_PKG - show dependent code; PO_ATTRIBUTE_VALUES_PVT - show dependent code; PO_DATATEMPLATE_PKG - show dependent code