[Home] [Help] [Dependency Information]
Object Name: | ICX_CAT_AGREEMENT_ATTRS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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. |
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;
|
|
|