[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AS_METH_STAGE_INSTANCES |
|---|---|
| Object Type: | TABLE |
| Owner: | OSM |
| FND Design Data: |  AS.AS_METH_STAGE_INSTANCES
|
| Subobject Name: | |
| Status: | VALID |
This table stores methodology stage instances. When a methodology is selected for a lead or opportunity, a methodology stage instance is created for each stage within the methodology having an associated sales supplement template. A corresponding sales supplement template instance is created, which provides the link to the transactional values for the supplemental data. The relationship between the methodology stage instance and the corresponding sales supplement template instance is captured in ASO_SUP_TMPL_INSTANCE, where OWNER_TABLE_NAME is 'AS_METH_STAGE_INSTANCES' and OWNER_TABLE_ID is METH_STAGE_INSTANCE_ID.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AS_METH_STAGE_INSTANCES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 METH_STAGE_INSTANCE_ID
|
| AS_METH_STAGE_INSTANCES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SALES_METHODOLOGY_ID
SALES_STAGE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| METH_STAGE_INSTANCE_ID | NUMBER | Yes | Methodology Stage Instance Id | |
| SALES_METHODOLOGY_ID | NUMBER | Yes | Sales Methodology Id | |
| SALES_STAGE_ID | NUMBER | Yes | Sales Stage Id | |
| COMPLETE_FLAG | VARCHAR2 | (1) | Yes | Complete Flag |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Yes | Last Updated By | |
| CREATION_DATE | DATE | Yes | Creation Date | |
| CREATED_BY | NUMBER | Yes | Created By | |
| LAST_UPDATE_LOGIN | NUMBER | Last Update Login | ||
| REQUEST_ID | NUMBER | Request Id | ||
| PROGRAM_APPLICATION_ID | NUMBER | Program Application Id | ||
| PROGRAM_ID | NUMBER | Program Id | ||
| PROGRAM_UPDATE_DATE | DATE | Program Update Date | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition 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 | |
| OBJECT_VERSION_NUMBER | NUMBER | Yes | Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT METH_STAGE_INSTANCE_ID
, SALES_METHODOLOGY_ID
, SALES_STAGE_ID
, COMPLETE_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, OBJECT_VERSION_NUMBER
FROM OSM.AS_METH_STAGE_INSTANCES;
OSM.AS_METH_STAGE_INSTANCES does not reference any database object
OSM.AS_METH_STAGE_INSTANCES is referenced by following:
APPS
AS_METH_STAGE_INSTANCES
|
|
|
|