DBA Data[Home] [Help]

APPS.WF_MONITOR dependencies on WF_MESSAGE_ATTRIBUTES_VL

Line 846: wf_message_attributes_vl ma

842: 'LOOKUP', wf_core.activity_result(ma.format, na.text_value),
843: na.text_value) value
844: from wf_notifications n,
845: wf_notification_attributes na,
846: wf_message_attributes_vl ma
847: where n.group_id = nid
848: and n.message_type = ma.message_type
849: and n.message_name = ma.message_name
850: and ma.name = na.name

Line 3044: WF_MESSAGE_ATTRIBUTES_VL MA,

3040:
3041: cursor attrs(mnid in number) is
3042: select MA.NAME
3043: from WF_NOTIFICATION_ATTRIBUTES NA,
3044: WF_MESSAGE_ATTRIBUTES_VL MA,
3045: WF_NOTIFICATIONS N
3046: where N.NOTIFICATION_ID = mnid
3047: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
3048: and MA.MESSAGE_NAME = N.MESSAGE_NAME

Line 3389: wf_message_attributes_vl ma,

3385: 1
3386: INTO x_notification_result,
3387: x_notification_response
3388: FROM wf_notification_attributes na,
3389: wf_message_attributes_vl ma,
3390: wf_notifications n
3391: WHERE n.group_id = x_notification_id
3392: AND n.message_type = ma.message_type
3393: AND n.message_name = ma.message_name

Line 3425: wf_message_attributes_vl ma,

3421: BEGIN
3422: SELECT count(*)
3423: INTO x_notification_response
3424: FROM wf_notification_attributes na,
3425: wf_message_attributes_vl ma,
3426: wf_notifications n
3427: WHERE n.group_id = x_notification_id
3428: AND n.message_type = ma.message_type
3429: AND n.message_name = ma.message_name