eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CSC_PROF_MODULE_GROUPS_V

Object Details

Object Name:	CSC_PROF_MODULE_GROUPS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSC.CSC_PROF_MODULE_GROUPS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View of CSC_PROF_MODULE_GROUPS. This view is used in Customer Profile Setup form - Preferences tab.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id
MODULE_GROUP_ID	NUMBER		Yes	The unique id of the module group
FORM_FUNCTION_ID	NUMBER			Foreign key to FND_FORM_FUNCTIONS. This will associate a form with a profile group
FORM_FUNCTION_NAME	VARCHAR2	(480)		Function name of the calling form
RESPONSIBILITY_ID	NUMBER	(15)		Responsibility_id from csc_prof_module_groups table
RESPONSIBILITY_NAME	VARCHAR2	(100)		Responsibility Name from fn_responsibility_vl table
RESP_APPL_ID	NUMBER	(15)		This is for storing the responsibility id
PARTY_TYPE	VARCHAR2	(30)		Type of party to which this group is attached. In the form function defined, for this type of party, the profile checks present in the given group would be displayed
DASHBOARD_GROUP_ID	NUMBER			Foreign Key to CSC_PROF_GROUPS_B.GROUP_ID for getting dashboard group
GROUP_ID	NUMBER			Foreign Key to CSC_PROF_GROUPS_B.GROUP_ID
DASHBOARD_GROUP_FLAG	VARCHAR2	(3)		Can be either 'Y' or 'N'. Y means that the group specified in the group_id will be used in Customer Dashboard and of course 'N' means will not be used
CURRENCY_CODE	VARCHAR2	(15)		The currency code to be used by the profile group
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
FORM_FUNCTION	VARCHAR2	(80)	Yes	User name of form function
GROUP_NAME	VARCHAR2	(240)		Name of the group - Translated Column
DASHBOARD_GROUP_NAME	VARCHAR2	(240)		Name of the Dashboard Group - Translated Column
APPLICATION_ID	NUMBER			Stores application id.
SEEDED_FLAG	VARCHAR2	(3)		Identifier to know if the record is seed or not

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      MODULE_GROUP_ID
,      FORM_FUNCTION_ID
,      FORM_FUNCTION_NAME
,      RESPONSIBILITY_ID
,      RESPONSIBILITY_NAME
,      RESP_APPL_ID
,      PARTY_TYPE
,      DASHBOARD_GROUP_ID
,      GROUP_ID
,      DASHBOARD_GROUP_FLAG
,      CURRENCY_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      FORM_FUNCTION
,      GROUP_NAME
,      DASHBOARD_GROUP_NAME
,      APPLICATION_ID
,      SEEDED_FLAG
FROM APPS.CSC_PROF_MODULE_GROUPS_V;

Dependencies

[top of page]

APPS.CSC_PROF_MODULE_GROUPS_V references the following:

APPS: CSC_PROF_GROUPS_VL; CSC_PROF_MODULE_GROUPS; FND_FORM_FUNCTIONS_VL; FND_RESPONSIBILITY_VL

APPS.CSC_PROF_MODULE_GROUPS_V is referenced by following:

APPS: CSC_CUSTOMER_PROFILE_DB_V; CSC_CUSTOMER_PROFILE_V