VIEW: APPS.FND_IMP_MENU_DEP_SUMMARY2_VL

Source

View Text - Preformatted

SELECT p.snapshot_id, p.bug_no, o.object_name path, p.filename form_name, (select count(*) from fnd_user_resp_groups where responsibility_id=re.responsibility_id and sysdate>start_date and (end_date is null or end_date>sysdate)) user_cnt, a.application_short_name application_short_name, t.responsibility_name, re.responsibility_id responsibility_id, o.attrib3 description, p.patch_id from fnd_responsibility_tl t, fnd_imp_deprelations r, fnd_imp_depobjects o, fnd_responsibility re, fnd_application a, ( (select p.directory || '/' || p.filename object_name, p.snapshot_id, p.filename, p.bug_no, p.patch_id from fnd_imp_psmaster2 p where (lower(p.file_type) = 'fmb' or lower(p.file_type) = 'jsp') and p.typeid <> 'not applied' ) union ( select distinct(a.dep_directory || '/' || a.dep_filename) object_name, a.snapshot_id, a.dep_filename, a.bug_no, a.patch_id from fnd_imp_affectedfiles a where a.typeid <> 'not applied' ) ) p where r.dependency_type = 'MENU_NAVIGATION' and p.snapshot_id = o.snapshot_id and p.object_name = r.child_object_name and r.parent_object_id = o.object_id and re.responsibility_id = t.responsibility_id and a.application_id = re.application_id and re.menu_id = o.attrib2 and t.language = userenv('LANG')

View Text - HTML Formatted

SELECT P.SNAPSHOT_ID
, P.BUG_NO
, O.OBJECT_NAME PATH
, P.FILENAME FORM_NAME
, (SELECT COUNT(*)
FROM FND_USER_RESP_GROUPS
WHERE RESPONSIBILITY_ID=RE.RESPONSIBILITY_ID
AND SYSDATE>START_DATE
AND (END_DATE IS NULL OR END_DATE>SYSDATE)) USER_CNT
, A.APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME
, T.RESPONSIBILITY_NAME
, RE.RESPONSIBILITY_ID RESPONSIBILITY_ID
, O.ATTRIB3 DESCRIPTION
, P.PATCH_ID
FROM FND_RESPONSIBILITY_TL T
, FND_IMP_DEPRELATIONS R
, FND_IMP_DEPOBJECTS O
, FND_RESPONSIBILITY RE
, FND_APPLICATION A
, ( (SELECT P.DIRECTORY || '/' || P.FILENAME OBJECT_NAME
, P.SNAPSHOT_ID
, P.FILENAME
, P.BUG_NO
, P.PATCH_ID
FROM FND_IMP_PSMASTER2 P
WHERE (LOWER(P.FILE_TYPE) = 'FMB' OR LOWER(P.FILE_TYPE) = 'JSP')
AND P.TYPEID <> 'NOT APPLIED' ) UNION ( SELECT DISTINCT(A.DEP_DIRECTORY || '/' || A.DEP_FILENAME) OBJECT_NAME
, A.SNAPSHOT_ID
, A.DEP_FILENAME
, A.BUG_NO
, A.PATCH_ID
FROM FND_IMP_AFFECTEDFILES A
WHERE A.TYPEID <> 'NOT APPLIED' ) ) P
WHERE R.DEPENDENCY_TYPE = 'MENU_NAVIGATION'
AND P.SNAPSHOT_ID = O.SNAPSHOT_ID
AND P.OBJECT_NAME = R.CHILD_OBJECT_NAME
AND R.PARENT_OBJECT_ID = O.OBJECT_ID
AND RE.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
AND A.APPLICATION_ID = RE.APPLICATION_ID
AND RE.MENU_ID = O.ATTRIB2
AND T.LANGUAGE = USERENV('LANG')