VIEW: APPS.XDO_DGF_RULE_CATALOG_VL

Source

View Text - Preformatted

SELECT XRG.RULE_CATALOG_ID      RULE_CATALOG_ID
,XRG.BLOCK_CONTEXT_ID                 BLOCK_CONTEXT_ID
,XRG.RULE_SHORT_NAME                 RULE_SHORT_NAME
,XRG.RULE_TYPE                                RULE_TYPE
,XRG.RULE_VARIABLE                       RULE_VARIABLE
,XRG.RULE_OPERATOR                      RULE_OPERATOR
,XRL.RULE_VALUES                           RULE_VALUES
,XRG.RULE_VALUES_DATATYPE      RULE_VALUES_DATATYPE
,XRL.RULE_DESCRIPTION                   RULE_DESCRIPTION
,XRG.DB_FUNCTION                           DB_FUNCTION
,XRG.ARG_NUMBER                          ARG_NUMBER
,XRG.ARG01                                      ARG01
,XRG.ARG02                                      ARG02
,XRG.ARG03                                      ARG03
,XRG.ARG04                                      ARG04
,XRG.ARG05                                      ARG05
,XRG.ARG06                                      ARG06
,XRG.ARG07                                      ARG07
,XRG.ARG08                                      ARG08
,XRG.ARG09                                      ARG09
,XRG.ARG10                                      ARG10
,XRG.ARG01_TYPE                           ARG01_TYPE
,XRG.ARG02_TYPE                           ARG02_TYPE
,XRG.ARG03_TYPE                           ARG03_TYPE
,XRG.ARG04_TYPE                           ARG04_TYPE
,XRG.ARG05_TYPE                           ARG05_TYPE
,XRG.ARG06_TYPE                           ARG06_TYPE
,XRG.ARG07_TYPE                           ARG07_TYPE
,XRG.ARG08_TYPE                           ARG08_TYPE
,XRG.ARG09_TYPE                           ARG09_TYPE
,XRG.ARG10_TYPE                           ARG10_TYPE
,XRG.OBJECT_VERSION_NUMBER    OBJECT_VERSION_NUMBER
,XRG.ATTRIBUTE_CATEGORY          ATTRIBUTE_CATEGORY
,XRG.ATTRIBUTE1                             ATTRIBUTE1
,XRG.ATTRIBUTE2                             ATTRIBUTE2
,XRG.ATTRIBUTE3                             ATTRIBUTE3
,XRG.ATTRIBUTE4                             ATTRIBUTE4
,XRG.ATTRIBUTE5                             ATTRIBUTE5
,XRG.ATTRIBUTE6                             ATTRIBUTE6
,XRG.ATTRIBUTE7                             ATTRIBUTE7
,XRG.ATTRIBUTE8                             ATTRIBUTE8
,XRG.ATTRIBUTE9                             ATTRIBUTE9
,XRG.ATTRIBUTE10                           ATTRIBUTE10
,XRG.ATTRIBUTE11                           ATTRIBUTE11
,XRG.ATTRIBUTE12                           ATTRIBUTE12
,XRG.ATTRIBUTE13                           ATTRIBUTE13
,XRG.ATTRIBUTE14                           ATTRIBUTE14
,XRG.ATTRIBUTE15                           ATTRIBUTE15
,XRG.CREATED_BY                           CREATED_BY
,XRG.CREATION_DATE                      CREATION_DATE
,XRG.LAST_UPDATED_BY                 LAST_UPDATED_BY
,XRG.LAST_UPDATE_DATE               LAST_UPDATE_DATE
,XRG.LAST_UPDATE_LOGIN              LAST_UPDATE_LOGIN
FROM    XDO_DGF_RULE_CATALOG_B   XRG
             ,XDO_DGF_RULE_CATALOG_TL XRL
WHERE  XRG.RULE_CATALOG_ID = XRL.RULE_CATALOG_ID
     AND  XRL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT XRG.RULE_CATALOG_ID RULE_CATALOG_ID
, XRG.BLOCK_CONTEXT_ID BLOCK_CONTEXT_ID
, XRG.RULE_SHORT_NAME RULE_SHORT_NAME
, XRG.RULE_TYPE RULE_TYPE
, XRG.RULE_VARIABLE RULE_VARIABLE
, XRG.RULE_OPERATOR RULE_OPERATOR
, XRL.RULE_VALUES RULE_VALUES
, XRG.RULE_VALUES_DATATYPE RULE_VALUES_DATATYPE
, XRL.RULE_DESCRIPTION RULE_DESCRIPTION
, XRG.DB_FUNCTION DB_FUNCTION
, XRG.ARG_NUMBER ARG_NUMBER
, XRG.ARG01 ARG01
, XRG.ARG02 ARG02
, XRG.ARG03 ARG03
, XRG.ARG04 ARG04
, XRG.ARG05 ARG05
, XRG.ARG06 ARG06
, XRG.ARG07 ARG07
, XRG.ARG08 ARG08
, XRG.ARG09 ARG09
, XRG.ARG10 ARG10
, XRG.ARG01_TYPE ARG01_TYPE
, XRG.ARG02_TYPE ARG02_TYPE
, XRG.ARG03_TYPE ARG03_TYPE
, XRG.ARG04_TYPE ARG04_TYPE
, XRG.ARG05_TYPE ARG05_TYPE
, XRG.ARG06_TYPE ARG06_TYPE
, XRG.ARG07_TYPE ARG07_TYPE
, XRG.ARG08_TYPE ARG08_TYPE
, XRG.ARG09_TYPE ARG09_TYPE
, XRG.ARG10_TYPE ARG10_TYPE
, XRG.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, XRG.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, XRG.ATTRIBUTE1 ATTRIBUTE1
, XRG.ATTRIBUTE2 ATTRIBUTE2
, XRG.ATTRIBUTE3 ATTRIBUTE3
, XRG.ATTRIBUTE4 ATTRIBUTE4
, XRG.ATTRIBUTE5 ATTRIBUTE5
, XRG.ATTRIBUTE6 ATTRIBUTE6
, XRG.ATTRIBUTE7 ATTRIBUTE7
, XRG.ATTRIBUTE8 ATTRIBUTE8
, XRG.ATTRIBUTE9 ATTRIBUTE9
, XRG.ATTRIBUTE10 ATTRIBUTE10
, XRG.ATTRIBUTE11 ATTRIBUTE11
, XRG.ATTRIBUTE12 ATTRIBUTE12
, XRG.ATTRIBUTE13 ATTRIBUTE13
, XRG.ATTRIBUTE14 ATTRIBUTE14
, XRG.ATTRIBUTE15 ATTRIBUTE15
, XRG.CREATED_BY CREATED_BY
, XRG.CREATION_DATE CREATION_DATE
, XRG.LAST_UPDATED_BY LAST_UPDATED_BY
, XRG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XRG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM XDO_DGF_RULE_CATALOG_B XRG
, XDO_DGF_RULE_CATALOG_TL XRL WHERE XRG.RULE_CATALOG_ID = XRL.RULE_CATALOG_ID
AND XRL.LANGUAGE = USERENV('LANG')