[Home] [Help]
View: XDP_PROC_BODY_VL
Product: | XDP - Provisioning |
Description: | This View shows all the User defined Procedures in SFM |
Implementation/DBA Data: |
APPS.XDP_PROC_BODY_VL
|
View Text
SELECT B.ROWID ROW_ID
, B.PROC_NAME
, B.PROC_BODY
, B.PROC_TYPE
, B.PROTECTED_FLAG
, B.CREATION_DATE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, T.DISPLAY_NAME
, T.DESCRIPTION
, B.PROC_SPEC
FROM XDP_PROC_BODY_TL T
, XDP_PROC_BODY B
WHERE B.PROC_NAME = T.PROC_NAME
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
PROC_NAME |
PROC_BODY |
PROC_TYPE |
PROTECTED_FLAG |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
LAST_UPDATE_LOGIN |
DISPLAY_NAME |
DESCRIPTION |
PROC_SPEC |