DBA Data[Home] [Help]

APPS.WF_ROUTE dependencies on WF_ITEM_ATTRIBUTES

Line 928: WF_ITEM_ATTRIBUTES WIA

924: WMA.TYPE,
925: WMA.FORMAT
926: from WF_ROUTING_RULES WRR,
927: WF_MESSAGE_ATTRIBUTES_VL WMA,
928: WF_ITEM_ATTRIBUTES WIA
929: where WRR.RULE_ID = nruleid
930: and WRR.MESSAGE_TYPE = WMA.MESSAGE_TYPE
931: and WRR.MESSAGE_NAME = WMA.MESSAGE_NAME
932: and WMA.SUBTYPE = 'RESPOND'

Line 1178: WF_ITEM_ATTRIBUTES WIA

1174: -- Check existing of response
1175: select count(WMA.NAME) into rowcount
1176: from WF_ROUTING_RULES WRR,
1177: WF_MESSAGE_ATTRIBUTES_VL WMA,
1178: WF_ITEM_ATTRIBUTES WIA
1179: where WRR.RULE_ID = nruleid
1180: and WRR.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1181: and WRR.MESSAGE_NAME = WMA.MESSAGE_NAME
1182: and WMA.SUBTYPE = 'RESPOND'

Line 1771: WF_ITEM_ATTRIBUTES WIA

1767: select count(WMA.NAME)
1768: into rowcount
1769: from WF_ROUTING_RULES WRR,
1770: WF_MESSAGE_ATTRIBUTES_VL WMA,
1771: WF_ITEM_ATTRIBUTES WIA
1772: where WRR.RULE_ID = rule.rule_id
1773: and WRR.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1774: and WRR.MESSAGE_NAME = WMA.MESSAGE_NAME
1775: and WMA.SUBTYPE = 'RESPOND'