DBA Data[Home] [Help]

APPS.MRP_MSC_EXP_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1018: from wf_item_activity_statuses

1014: update wf_notifications
1015: set end_date = sysdate
1016: where group_id in
1017: (select notification_id
1018: from wf_item_activity_statuses
1019: where item_type = 'MRPEXWFS'
1020: and item_key = l_item_key
1021: union
1022: select notification_id

Line 1023: from wf_item_activity_statuses_h

1019: where item_type = 'MRPEXWFS'
1020: and item_key = l_item_key
1021: union
1022: select notification_id
1023: from wf_item_activity_statuses_h
1024: where item_type = 'MRPEXWFS'
1025: and item_key = l_item_key);
1026:
1027: update wf_items

Line 1032: update wf_item_activity_statuses

1028: set end_date = sysdate
1029: where item_type = 'MRPEXWFS'
1030: and item_key = l_item_key;
1031:
1032: update wf_item_activity_statuses
1033: set end_date = sysdate
1034: where item_type = 'MRPEXWFS'
1035: and item_key = l_item_key;
1036:

Line 1037: update wf_item_activity_statuses_h

1033: set end_date = sysdate
1034: where item_type = 'MRPEXWFS'
1035: and item_key = l_item_key;
1036:
1037: update wf_item_activity_statuses_h
1038: set end_date = sysdate
1039: where item_type = 'MRPEXWFS'
1040: and item_key = l_item_key;
1041: