[Home] [Help] [Dependency Information]
Object Name: | CSC_PLAN_ENABLE_SETUP |
---|---|
Object Type: | TABLE |
Owner: | CSC |
FND Design Data: | CSC.CSC_PLAN_ENABLE_SETUP |
Subobject Name: | |
Status: | VALID |
CSC_PLAN_ENABLE_SETUP table stores the names of the form functions integrated with the Relationship Plans module and the points of integration.
Modules that need to integrate with relationship plans, can do so by coding any one or more of the following four triggers (point of integration): ON-INSERT, ON-UPDATE, CUSTOM1 and CUSTOM2. The details of the form that needs integration and the triggers that acheive this integraion are stored in this table.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSC_PLAN_ENABLE_SETUP_U1 | NORMAL | UNIQUE | APPS_TS_SEED | FUNCTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ENABLE_SETUP_ID | NUMBER | (15) | Yes | Unique identifier for CSC_PLAN_ENABLE_SETUP |
FUNCTION_ID | NUMBER | Yes | References FUNCTION_ID of FND_FORM_FUNCTIONS | |
START_DATE_ACTIVE | DATE | Yes | Effective start date | |
END_DATE_ACTIVE | DATE | Effective end date | ||
ON_INSERT_ENABLE_FLAG | VARCHAR2 | (1) | Yes | Flag for on-insert trigger of integrating module to fire outcomes of the relationship plan attached |
ON_UPDATE_ENABLE_FLAG | VARCHAR2 | (1) | Yes | Flag for on-update trigger of integrating module to fire outcomes of the relationship plan attached |
CUSTOM1_ENABLE_FLAG | VARCHAR2 | (1) | Yes | Flag for user defined custom1 trigger of integrating module to fire outcomes of the relationship plan attached |
CUSTOM2_ENABLE_FLAG | VARCHAR2 | (1) | Yes | Flag for user defined custom2 trigger of integrating module to fire outcomes of the relationship plan attached |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | VARCHAR2 | (15) | Standard Who column | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive Flexfield Segment Column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive Flexfield Structure Defining column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Version number of the record |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT ENABLE_SETUP_ID
, FUNCTION_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ON_INSERT_ENABLE_FLAG
, ON_UPDATE_ENABLE_FLAG
, CUSTOM1_ENABLE_FLAG
, CUSTOM2_ENABLE_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
FROM CSC.CSC_PLAN_ENABLE_SETUP;
CSC.CSC_PLAN_ENABLE_SETUP does not reference any database object
CSC.CSC_PLAN_ENABLE_SETUP is referenced by following:
|
|
|