DBA Data[Home] [Help]

APPS.WF_ROUTE dependencies on WF_ITEM_TYPES_VL

Line 897: from WF_ROUTING_RULES WRR, WF_ITEM_TYPES_VL WIT, WF_MESSAGES_VL WM,

893: WRR.ACTION_ARGUMENT,
894: WRR.RULE_COMMENT,
895: WIT.DISPLAY_NAME TYPE_DISPLAY,
896: WM.SUBJECT
897: from WF_ROUTING_RULES WRR, WF_ITEM_TYPES_VL WIT, WF_MESSAGES_VL WM,
898: WF_LOOKUPS WL
899: where WRR.RULE_ID = nruleid
900: and WRR.MESSAGE_TYPE = WIT.NAME (+)
901: and WRR.MESSAGE_TYPE = WM.TYPE (+)

Line 1591: from WF_ROUTING_RULES WRR, WF_ITEM_TYPES_VL WIT, WF_MESSAGES_VL WM,

1587: WIT.DISPLAY_NAME TYPE_DISPLAY,
1588: WM.DISPLAY_NAME MSG_DISPLAY,
1589: WM.SUBJECT,
1590: WL.MEANING ACTION_DISPLAY
1591: from WF_ROUTING_RULES WRR, WF_ITEM_TYPES_VL WIT, WF_MESSAGES_VL WM,
1592: WF_LOOKUPS WL
1593: where WRR.ROLE = username
1594: and WRR.MESSAGE_TYPE = WIT.NAME (+)
1595: and WRR.MESSAGE_TYPE = WM.TYPE (+)