[Home] [Help] [Dependency Information]
Object Name: | ASO_SUP_COMPONENT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ASO.ASO_SUP_COMPONENT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is to display Components and Response mapping details with the name, description, etc. As per the business need a component can have one or many predefined responses.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
COMPONENT_ID | NUMBER | Yes | Component ID | |
COMPONENT_TYPE | VARCHAR2 | (30) | Yes | Component type |
COMPONENT_TYPE_MEANING | VARCHAR2 | (80) | Yes | COMPONENT TYPE MEANING |
COMPONENT_NAME | VARCHAR2 | (2000) | Yes | Component name |
DESCRIPTION | VARCHAR2 | (2000) | Description | |
RESPONSE_TYPE | VARCHAR2 | (30) | Response type | |
RESPONSE_TYPE_MEANING | VARCHAR2 | (80) | Response type meaning | |
INSTRUCTION | VARCHAR2 | (2000) | Instruction | |
MANDATORY_FLAG | VARCHAR2 | (1) | Mandatory flag | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CONTEXT | VARCHAR2 | (30) | Context | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive Flexfield Segment | |
ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive Flexfield Segment | |
ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive Flexfield Segment | |
ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive Flexfield Segment | |
ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive Flexfield Segment |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, COMPONENT_ID
, COMPONENT_TYPE
, COMPONENT_TYPE_MEANING
, COMPONENT_NAME
, DESCRIPTION
, RESPONSE_TYPE
, RESPONSE_TYPE_MEANING
, INSTRUCTION
, MANDATORY_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
FROM APPS.ASO_SUP_COMPONENT_V;
|
|
|