View: BIS_DISPLAY_FORM_FUNC_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_DISPLAY_FORM_FUNC_V

View Text

SELECT "FUNCTION_ID"
, "FUNCTION_NAME"
, "OBJECT_TYPE"
, "USER_FUNCTION_NAME"
, "DESCRIPTION"
, "WEB_HTML_CALL"
, "PARAMETERS"
, "TYPE"
, "ISSEED"
, "FUNCTIONAL_AREA_ID"
, "FUNCTIONAL_AREA_NAME"
, "FUNCTIONAL_AREA_SHORT_NAME"
, "APPLICATION_ID"
, "LAST_UPDATE_DATE"
, "CREATED_BY"
, "OBSOLETE"
FROM ( SELECT FF_VL.FUNCTION_ID FUNCTION_ID
, FF_VL.FUNCTION_NAME FUNCTION_NAME
, BIS_UTIL.GET_OBJECT_TYPE(FF_VL.TYPE
, FF_VL.PARAMETERS
, FF_VL.WEB_HTML_CALL) OBJECT_TYPE
, FF_VL.USER_FUNCTION_NAME USER_FUNCTION_NAME
, FF_VL.DESCRIPTION DESCRIPTION
, FF_VL.WEB_HTML_CALL WEB_HTML_CALL
, FF_VL.PARAMETERS PARAMETERS
, FF_VL.TYPE
, DECODE (FF_VL.CREATED_BY
, 1
, 'Y'
, 2
, 'Y'
, 120
, 'Y'
, 'N') ISSEED
, (SELECT FUNCTIONAL_AREA_ID
FROM BIS_FUNCTIONAL_AREAS
WHERE SHORT_NAME = 'BIS_UNN') FUNCTIONAL_AREA_ID
, (SELECT NAME
FROM BIS_FUNCTIONAL_AREAS_VL
WHERE SHORT_NAME = 'BIS_UNN') FUNCTIONAL_AREA_NAME
, 'BIS_UNN' FUNCTIONAL_AREA_SHORT_NAME
, NVL(FF_VL.APPLICATION_ID
, -1) APPLICATION_ID
, FF_VL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FF_VL.CREATED_BY CREATED_BY
, DECODE(NVL(INSTR(FF_VL.PARAMETERS
, '&POBSOLETEFLAG=Y')
, 0)
, 0
, 'F'
, 'T') OBSOLETE
FROM FND_FORM_FUNCTIONS_VL FF_VL
WHERE FF_VL.TYPE IS NOT NULL
AND FF_VL.WEB_HTML_CALL IS NOT NULL
AND FF_VL.FUNCTION_NAME IS NOT NULL
AND BIS_UTIL.GET_OBJECT_TYPE(FF_VL.TYPE
, FF_VL.PARAMETERS
, FF_VL.WEB_HTML_CALL) IS NOT NULL
AND NOT EXISTS ( SELECT FF_EXT_VL.OBJECT_NAME
FROM BIS_FORM_FUNCTION_EXTENSION_VL FF_EXT_VL
WHERE FF_VL.FUNCTION_NAME = FF_EXT_VL.OBJECT_NAME ) UNION ALL SELECT "FUNCTION_ID"
, "FUNCTION_NAME"
, "OBJECT_TYPE"
, "USER_FUNCTION_NAME"
, "DESCRIPTION"
, "WEB_HTML_CALL"
, "PARAMETERS"
, "TYPE"
, "ISSEED"
, "FUNCTIONAL_AREA_ID"
, "FUNCTIONAL_AREA_NAME"
, "FUNCTIONAL_AREA_SHORT_NAME"
, "APPLICATION_ID"
, "LAST_UPDATE_DATE"
, "CREATED_BY"
, "OBSOLETE"
FROM ( SELECT FF_VL.FUNCTION_ID FUNCTION_ID
, FF_VL.FUNCTION_NAME FUNCTION_NAME
, NVL(FF_EXT_VL.OBJECT_TYPE
, BIS_UTIL.GET_OBJECT_TYPE(FF_VL.TYPE
, FF_VL.PARAMETERS
, FF_VL.WEB_HTML_CALL)) OBJECT_TYPE
, NVL(FF_EXT_VL.NAME
, FF_VL.USER_FUNCTION_NAME) USER_FUNCTION_NAME
, NVL(FF_EXT_VL.DESCRIPTION
, FF_VL.DESCRIPTION) DESCRIPTION
, FF_VL.WEB_HTML_CALL WEB_HTML_CALL
, FF_VL.PARAMETERS PARAMETERS
, FF_VL.TYPE
, DECODE (FF_VL.CREATED_BY
, 1
, 'Y'
, 2
, 'Y'
, 120
, 'Y'
, 'N') ISSEED
, FF_EXT_VL.FUNCTIONAL_AREA_ID FUNCTIONAL_AREA_ID
, BIS_FUNC.NAME FUNCTIONAL_AREA_NAME
, NVL(BIS_FUNC.SHORT_NAME
, 'BIS_UNN') FUNCTIONAL_AREA_SHORT_NAME
, NVL(FF_VL.APPLICATION_ID
, NVL(FF_EXT_VL.APPLICATION_ID
, -1)) APPLICATION_ID
, FF_VL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FF_VL.CREATED_BY CREATED_BY
, DECODE(NVL(INSTR(FF_VL.PARAMETERS
, '&POBSOLETEFLAG=Y')
, 0)
, 0
, 'F'
, 'T') OBSOLETE
FROM BIS_FORM_FUNCTION_EXTENSION_VL FF_EXT_VL
, FND_FORM_FUNCTIONS_VL FF_VL
, BIS_FUNCTIONAL_AREAS_VL BIS_FUNC
WHERE FF_VL.FUNCTION_NAME = FF_EXT_VL.OBJECT_NAME
AND BIS_FUNC.FUNCTIONAL_AREA_ID = FF_EXT_VL.FUNCTIONAL_AREA_ID
AND FF_VL.TYPE IS NOT NULL
AND FF_VL.WEB_HTML_CALL IS NOT NULL )
WHERE OBJECT_TYPE IS NOT NULL) GROUP BY FUNCTION_ID
, FUNCTION_NAME
, OBJECT_TYPE
, USER_FUNCTION_NAME
, DESCRIPTION
, WEB_HTML_CALL
, PARAMETERS
, TYPE
, ISSEED
, FUNCTIONAL_AREA_ID
, FUNCTIONAL_AREA_NAME
, FUNCTIONAL_AREA_SHORT_NAME
, APPLICATION_ID
, LAST_UPDATE_DATE
, CREATED_BY
, OBSOLETE