[Home] [Help] [Dependency Information]
Object Name: | CSC_PLAN_ENABLE_SETUP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSC.CSC_PLAN_ENABLE_SETUP_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is based on CSC_PLAN_ENABLE_SETUP and has information about forms that are integrated with the relationship plans module and their points of integration, which could be acheived by coding any one of the following triggers in the integrating form: ON-INSERT, ON-UPDATE, CUSTOM1 and CUSTOM2.
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 | |
USER_FUNCTION_NAME | VARCHAR2 | (80) | Yes | User function name |
START_DATE_ACTIVE | DATE | Yes | Effective start date | |
END_DATE_ACTIVE | DATE | Effective end date | ||
FUNCTION_NAME | VARCHAR2 | (480) | Yes | Function name |
FUNCTION_TYPE | VARCHAR2 | (30) | Function type | |
APPLICATION_ID | NUMBER | Application identifier | ||
APPLICATION_NAME | VARCHAR2 | (240) | Yes | Application name |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ENABLE_SETUP_ID
, FUNCTION_ID
, USER_FUNCTION_NAME
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, FUNCTION_NAME
, FUNCTION_TYPE
, APPLICATION_ID
, APPLICATION_NAME
, 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
FROM APPS.CSC_PLAN_ENABLE_SETUP_V;
APPS.CSC_PLAN_ENABLE_SETUP_V is not referenced by any database object
|
|
|