View: FND_IMP_MENU_DEP_SUMMARY2_VL

Product:	FND - Application Object Library
Description:	FND_IMP_MENU_DEP_SUMMARY2_VL
Implementation/DBA Data:	APPS.FND_IMP_MENU_DEP_SUMMARY2_VL

View Text

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

Columns