DBA Data[Home] [Help]

APPS.PQH_SS_WORKFLOW dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 3545: FROM wf_item_activity_statuses_h ias

3541: AND name = 'WF_NOTE'
3542: ) h_comment
3543: ,nvl (ias.end_date
3544: ,ias.begin_date) h_action_date
3545: FROM wf_item_activity_statuses_h ias
3546: ,wf_activities a
3547: ,wf_process_activities pa
3548: ,wf_items i
3549: ,WF_ITEM_TYPES IT

Line 3585: FROM wf_item_activity_statuses_h ias

3581: ,c.from_role h_from_role
3582: ,wf_core.translate (c.action) h_action
3583: ,c.user_comment h_comment
3584: ,c.comment_date h_action_date
3585: FROM wf_item_activity_statuses_h ias
3586: ,wf_comments c
3587: WHERE ias.item_type = x_item_type
3588: AND ias.item_key = x_item_key
3589: -- AND ias.process_activity = x_actid