DBA Data[Home] [Help]

APPS.WF_ROUTE dependencies on WF_MESSAGE_ATTRIBUTES_VL

Line 927: WF_MESSAGE_ATTRIBUTES_VL WMA,

923: WMA.DATE_DEFAULT) DATE_VALUE,
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

Line 1177: WF_MESSAGE_ATTRIBUTES_VL WMA,

1173: end if;
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

Line 1770: WF_MESSAGE_ATTRIBUTES_VL WMA,

1766: -- Check existing of response
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

Line 1794: WF_MESSAGE_ATTRIBUTES_VL WMA,

1790: */
1791: select WL.MEANING
1792: into att_tvalue
1793: from WF_LOOKUPS WL,
1794: WF_MESSAGE_ATTRIBUTES_VL WMA,
1795: WF_ROUTING_RULES WRR,
1796: WF_ROUTING_RULE_ATTRIBUTES WRA
1797: where WRA.RULE_ID = rule.rule_id
1798: and WRA.NAME = 'RESULT'