VIEW: APPS.BIS_DISPLAY_FORM_FUNC_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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