DBA Data[Home] [Help]

APPS.AR_CREDIT_MEMO_API_PUB dependencies on WF_ACTIVITIES_VL

Line 735: wf_activities_vl ac,

731: ias.activity_result_code result_code,
732: ias.assigned_user -- user
733: FROM wf_item_activity_statuses ias,
734: wf_process_activities pa,
735: wf_activities_vl ac,
736: wf_activities_vl ap,
737: wf_items i
738: WHERE ias.item_type = 'ARCMREQ'
739: AND ias.item_key = p_request_id

Line 736: wf_activities_vl ap,

732: ias.assigned_user -- user
733: FROM wf_item_activity_statuses ias,
734: wf_process_activities pa,
735: wf_activities_vl ac,
736: wf_activities_vl ap,
737: wf_items i
738: WHERE ias.item_type = 'ARCMREQ'
739: AND ias.item_key = p_request_id
740: AND ias.process_activity = pa.instance_id

Line 926: wf_activities_vl ac,

922: SELECT count(*)
923: INTO l_count_activities
924: FROM wf_item_activity_statuses ias,
925: wf_process_activities pa,
926: wf_activities_vl ac,
927: wf_activities_vl ap,
928: wf_items i
929: WHERE ias.item_type = 'ARCMREQ'
930: AND ias.item_key = p_request_id

Line 927: wf_activities_vl ap,

923: INTO l_count_activities
924: FROM wf_item_activity_statuses ias,
925: wf_process_activities pa,
926: wf_activities_vl ac,
927: wf_activities_vl ap,
928: wf_items i
929: WHERE ias.item_type = 'ARCMREQ'
930: AND ias.item_key = p_request_id
931: AND ias.process_activity = pa.instance_id