DBA Data[Home] [Help]

VIEW: APPS.AQ$WF_BPEL_QTAB_R

Source

View Text - Preformatted

SELECT queue_name QUEUE, s.name NAME , address ADDRESS , protocol PROTOCOL, rule_condition RULE, ruleset_name RULE_SET, trans_name TRANSFORMATION  FROM "AQ$_WF_BPEL_QTAB_S" s , sys.all_rules r WHERE (bitand(s.subscriber_type, 1) = 1) AND s.rule_name = r.rule_name and r.rule_owner = 'APPS'  WITH READ ONLY
View Text - HTML Formatted

SELECT QUEUE_NAME QUEUE
, S.NAME NAME
, ADDRESS ADDRESS
, PROTOCOL PROTOCOL
, RULE_CONDITION RULE
, RULESET_NAME RULE_SET
, TRANS_NAME TRANSFORMATION
FROM "AQ$_WF_BPEL_QTAB_S" S
, SYS.ALL_RULES R
WHERE (BITAND(S.SUBSCRIBER_TYPE
, 1) = 1)
AND S.RULE_NAME = R.RULE_NAME
AND R.RULE_OWNER = 'APPS' WITH READ ONLY