VIEW: APPS.CSC_PROF_MODULE_GROUPS_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))