[Home] [Help] [Dependency Information]
Object Name: | QA_PLAN_CHARS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QA.QA_PLAN_CHARS_V |
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 |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Identifies row in QA_PLAN_CHARS table. | |
PLAN_ID | NUMBER | Yes | Collection plan identifier | |
CHAR_ID | NUMBER | Yes | Collection element identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
PROMPT_SEQUENCE | NUMBER | Collection element sequence in collection plan | ||
CHAR_TYPE_CODE | VARCHAR2 | (30) | Yes | collection element type code |
ORGANIZATION_ID | NUMBER | Yes | Identifies inventory organization in which this plan has been defined | |
CHAR_TYPE_MEANING | VARCHAR2 | (80) | Yes | Collection element type meaning |
CHAR_TYPE_DESCRIPTION | VARCHAR2 | (240) | Collection element type description | |
PROMPT | VARCHAR2 | (30) | Yes | Collection element prompt |
ENABLED_FLAG | NUMBER | Yes | Flag to indicate if collection element is enabled or not | |
ENABLED_MEANING | VARCHAR2 | (80) | Yes | Enabled flag meaning |
MANDATORY_FLAG | NUMBER | Yes | Flag to indicate if this collection element is mandatory or not. | |
MANDATORY_MEANING | VARCHAR2 | (80) | Yes | Mandatory flag meaning |
DEFAULT_VALUE | VARCHAR2 | (2000) | collection element default value | |
DEFAULT_VALUE_ID | NUMBER | Collection element default value identifier | ||
RESULT_COLUMN_NAME | VARCHAR2 | (30) | Name of the column in table QA_RESULTS to which this collection element is mapped for this collection plan. | |
VALUES_EXIST_FLAG | NUMBER | Yes | Flag to indicate if master set of values exist for this collection element and plan. | |
SQL_STRING_FLAG | VARCHAR2 | (1) | Flag to indicate if SQL validation string has been defined for the collection element. | |
VALUES_EXIST_MEANING | VARCHAR2 | (80) | Yes | Value exist flag meaning |
MASTER_CHAR_VALUES_EXIST_FLAG | NUMBER | Yes | This column indicates if master set of values has been entered for this collection element | |
DISPLAYED_FLAG | NUMBER | Yes | Indicates whether collection element should be displayed in the plan or not. | |
DISPLAYED_MEANING | VARCHAR2 | (80) | Yes | Displayed flag meaning |
PLAN_NAME | VARCHAR2 | (30) | Yes | Collection plan name |
PLAN_DESCRIPTION | VARCHAR2 | (150) | Collection plan description | |
CHAR_NAME | VARCHAR2 | (30) | Yes | Collection element name |
CHAR_CONTEXT_FLAG | NUMBER | Yes | Collection element context flag | |
CHAR_CONTEXT_MEANING | VARCHAR2 | (80) | Yes | Context flag meaning |
DATATYPE | NUMBER | Yes | Collection element datatype | |
DATATYPE_MEANING | VARCHAR2 | (80) | Yes | Collection element datatype meaning |
DISPLAY_LENGTH | NUMBER | Collection element display length | ||
DECIMAL_PRECISION | NUMBER | Collection element decimal precision | ||
UOM_CODE | VARCHAR2 | (3) | Collection element unit of measurement code | |
UNIT_OF_MEASURE | VARCHAR2 | (25) | Collection element unit of measurement | |
DATA_ENTRY_HINT | VARCHAR2 | (240) | Data entry help text that is displayed when cursor points to this collection element | |
HARDCODED_COLUMN | VARCHAR2 | (30) | Underlying database column for this collection element | |
DEVELOPER_NAME | VARCHAR2 | (30) | Reference column for collection element name | |
FK_LOOKUP_TYPE | NUMBER | Foreign key lookup type code for collection element | ||
FK_TABLE_NAME | VARCHAR2 | (30) | Name of the table to which collection element is a foreign key | |
FK_TABLE_SHORT_NAME | VARCHAR2 | (5) | Foreign key table short name | |
FK_ID | VARCHAR2 | (30) | Foreign key column identifier in Quality. This information is used for dynamic view creation and validation purposes. | |
FK_ID2 | VARCHAR2 | (30) | additional foreign key column | |
FK_ID3 | VARCHAR2 | (30) | additional foreign key column | |
PK_ID | VARCHAR2 | (30) | Primary key column identifier for the foreign key. Oracle quality uses this information for dynamic view creation and validation purposes. | |
PK_ID2 | VARCHAR2 | (30) | Additional primary key column identifier | |
PK_ID3 | VARCHAR2 | (30) | Additional primary key column identifier | |
FK_MEANING | VARCHAR2 | (30) | Foreign key meaning | |
FK_DESCRIPTION | VARCHAR2 | (30) | Foreign key description | |
FK_ADD_WHERE | VARCHAR2 | (255) | Where clause that needs to be added to quality dynamic view creation logic for this collection element | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
SEQUENCE_NUMBER | NUMBER | |||
SEQUENCE_PREFIX | VARCHAR2 | (10) | ||
SEQUENCE_SUFFIX | VARCHAR2 | (10) | ||
SEQUENCE_SEPARATOR | VARCHAR2 | (1) | ||
SEQUENCE_START | NUMBER | |||
SEQUENCE_LENGTH | NUMBER | |||
SEQUENCE_INCREMENT | NUMBER | |||
SEQUENCE_NEXTVAL | NUMBER | |||
SEQUENCE_ZERO_PAD | NUMBER | |||
SEQUENCE_NAME | VARCHAR2 | (80) | ||
QPC_DECIMAL_PRECISION | NUMBER | plan element decimal precision | ||
QPC_UOM_CODE | VARCHAR2 | (3) | plan element uom code | |
READ_ONLY_FLAG | NUMBER | indicates whether this element can be modified in data entry UI | ||
READ_ONLY_MEANING | VARCHAR2 | (80) | Yes | Translated meaning |
SS_POPLIST_FLAG | NUMBER | indicates whether this element will be rendered as poplist in self-service UI | ||
SS_POPLIST_MEANING | VARCHAR2 | (80) | Yes | Translated meaning |
INFORMATION_FLAG | NUMBER | indicates whether this element will be displayed as Information in self-service UI | ||
INFORMATION_MEANING | VARCHAR2 | (80) | Yes | Translated meaning |
DEVICE_FLAG | NUMBER | |||
DEVICE_MEANING | VARCHAR2 | (80) | Yes | |
DEVICE_ID | NUMBER | |||
DEVICE | VARCHAR2 | (513) | ||
OVERRIDE_FLAG | NUMBER | |||
OVERRIDE_MEANING | VARCHAR2 | (80) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PLAN_ID
, CHAR_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PROMPT_SEQUENCE
, CHAR_TYPE_CODE
, ORGANIZATION_ID
, CHAR_TYPE_MEANING
, CHAR_TYPE_DESCRIPTION
, PROMPT
, ENABLED_FLAG
, ENABLED_MEANING
, MANDATORY_FLAG
, MANDATORY_MEANING
, DEFAULT_VALUE
, DEFAULT_VALUE_ID
, RESULT_COLUMN_NAME
, VALUES_EXIST_FLAG
, SQL_STRING_FLAG
, VALUES_EXIST_MEANING
, MASTER_CHAR_VALUES_EXIST_FLAG
, DISPLAYED_FLAG
, DISPLAYED_MEANING
, PLAN_NAME
, PLAN_DESCRIPTION
, CHAR_NAME
, CHAR_CONTEXT_FLAG
, CHAR_CONTEXT_MEANING
, DATATYPE
, DATATYPE_MEANING
, DISPLAY_LENGTH
, DECIMAL_PRECISION
, UOM_CODE
, UNIT_OF_MEASURE
, DATA_ENTRY_HINT
, HARDCODED_COLUMN
, DEVELOPER_NAME
, FK_LOOKUP_TYPE
, FK_TABLE_NAME
, FK_TABLE_SHORT_NAME
, FK_ID
, FK_ID2
, FK_ID3
, PK_ID
, PK_ID2
, PK_ID3
, FK_MEANING
, FK_DESCRIPTION
, FK_ADD_WHERE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SEQUENCE_NUMBER
, SEQUENCE_PREFIX
, SEQUENCE_SUFFIX
, SEQUENCE_SEPARATOR
, SEQUENCE_START
, SEQUENCE_LENGTH
, SEQUENCE_INCREMENT
, SEQUENCE_NEXTVAL
, SEQUENCE_ZERO_PAD
, SEQUENCE_NAME
, QPC_DECIMAL_PRECISION
, QPC_UOM_CODE
, READ_ONLY_FLAG
, READ_ONLY_MEANING
, SS_POPLIST_FLAG
, SS_POPLIST_MEANING
, INFORMATION_FLAG
, INFORMATION_MEANING
, DEVICE_FLAG
, DEVICE_MEANING
, DEVICE_ID
, DEVICE
, OVERRIDE_FLAG
, OVERRIDE_MEANING
FROM APPS.QA_PLAN_CHARS_V;
|
|
|