Product: | CSC - Customer Care |
---|---|
Description: | View of CSC_PROF_MODULE_GROUPS. This view is used in Customer Profile Setup form - Preferences tab. |
Implementation/DBA Data: | APPS.CSC_PROF_MODULE_GROUPS_V |
SELECT PMG.ROWID ROW_ID
, PMG.MODULE_GROUP_ID
, PMG.FORM_FUNCTION_ID
, PMG.FORM_FUNCTION_NAME
, RSP.RESPONSIBILITY_ID
, RSP.RESPONSIBILITY_NAME
, RSP.APPLICATION_ID
, PMG.PARTY_TYPE
, PMG.DASHBOARD_GROUP_ID
, PMG.GROUP_ID
, PMG.DASHBOARD_GROUP_FLAG
, PMG.CURRENCY_CODE
, PMG.LAST_UPDATE_DATE
, PMG.LAST_UPDATED_BY
, PMG.CREATION_DATE
, PMG.CREATED_BY
, PMG.LAST_UPDATE_LOGIN
, FFV.USER_FUNCTION_NAME FORM_FUNCTION
, PGV.GROUP_NAME GROUP_NAME
, PGV1.GROUP_NAME DASHBOARD_GROUP_NAME
, PMG.APPLICATION_ID
, PMG.SEEDED_FLAG
FROM CSC_PROF_MODULE_GROUPS PMG
, FND_FORM_FUNCTIONS_VL FFV
, CSC_PROF_GROUPS_VL PGV
, CSC_PROF_GROUPS_VL PGV1
, FND_RESPONSIBILITY_VL RSP
WHERE RSP.RESPONSIBILITY_ID(+) = PMG.RESPONSIBILITY_ID
AND RSP.APPLICATION_ID(+) = PMG.RESP_APPL_ID
AND FFV.FUNCTION_NAME = PMG.FORM_FUNCTION_NAME
AND (PGV.GROUP_ID(+) = NVL(PMG.GROUP_ID
, -1)
AND PGV1.GROUP_ID(+) = NVL(PMG.DASHBOARD_GROUP_ID
, -1))