[Home] [Help]
View: AR_BPA_RULES_VL
View Text
SELECT B.ROWID ROW_ID
, B.SAME_PRINTING_TEMPLATE_FLAG
, B.RULE_ID
, B.PRIMARY_APP_ID
, B.SECONDARY_APP_ID
, B.RULE_SEARCH_ORDER
, B.MATCH_ALL_ATTRIBUTES
, B.SEEDED_FLAG
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.RULE_NAME
, T.RULE_DESCRIPTION
, B.PRINT_RULE_SEARCH_ORDER
, B.CM_SAME_PRT_TMPLT_FLAG
, B.DM_SAME_PRT_TMPLT_FLAG
, B.CB_SAME_PRT_TMPLT_FLAG
, B.DEP_SAME_PRT_TMPLT_FLAG
, B.GUAR_SAME_PRT_TMPLT_FLAG
FROM AR_BPA_RULES_TL T
, AR_BPA_RULES_B B
WHERE B.RULE_ID = T.RULE_ID
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
SAME_PRINTING_TEMPLATE_FLAG |
RULE_ID |
PRIMARY_APP_ID |
SECONDARY_APP_ID |
RULE_SEARCH_ORDER |
MATCH_ALL_ATTRIBUTES |
SEEDED_FLAG |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
RULE_NAME |
RULE_DESCRIPTION |
PRINT_RULE_SEARCH_ORDER |
CM_SAME_PRT_TMPLT_FLAG |
DM_SAME_PRT_TMPLT_FLAG |
CB_SAME_PRT_TMPLT_FLAG |
DEP_SAME_PRT_TMPLT_FLAG |
GUAR_SAME_PRT_TMPLT_FLAG |