QA_IP_CS_ATTR_VALUES_GT
This is the global temporary table used to hold the PIM related attribute values
Details
-
Schema: FUSION
-
Object owner: QA
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifies the item for which the attributes values need to be retrieved. | |
| ORGANIZATION_ID | NUMBER | 18 | Identifies the organization in which the item is defined. | |
| REVISION | VARCHAR2 | 18 | Identifies the item version for which the attribute values need to be retrieved. | |
| INSPECTION_PLAN_ID | NUMBER | 18 | Surrrogate identifier for inspection plan. | |
| CHARACTERISTIC_ID | NUMBER | 18 | Surrrogate identifier for characteristic. | |
| ATTRIBUTE_TYPE | VARCHAR2 | 30 | Indicates the attribute column corresponding to qa_ip_specifications. Valid values are - TARGET, MINIMUM and MAXIMUM. | |
| ATTRIBUTE_GROUP_CODE | VARCHAR2 | 80 | Indicates the internal attribute group code. | |
| ATTRIBUTE_CODE | VARCHAR2 | 30 | Indicates the internal attribute code. | |
| ATTRIBUTE_NEW_VALUE | VARCHAR2 | 4000 | Indicates the attribute value retrieved. | |
| ATTRIBUTE_UOM | VARCHAR2 | 9 | Indicates the attribute UOM retrieved. | |
| ERROR_MESSAGE | VARCHAR2 | 30 | Indicates the error message encountered. | |
| STATUS_CODE | VARCHAR2 | 10 | Indicates the status of the program. | |
| ATTRIBUTE_OLD_VALUE | VARCHAR2 | 4000 | Indicates the attribute value stored in inspection plan specifications. |