DBA Data[Home] [Help]

APPS.AR_CREDIT_MEMO_API_PUB dependencies on WF_ACTIVITIES_VL

Line 778: wf_activities_vl ac,

774: ias.activity_result_code result_code,
775: ias.assigned_user -- user
776: FROM wf_item_activity_statuses ias,
777: wf_process_activities pa,
778: wf_activities_vl ac,
779: wf_activities_vl ap,
780: wf_items i
781: WHERE ias.item_type = 'ARCMREQ'
782: AND ias.item_key = p_request_id

Line 779: wf_activities_vl ap,

775: ias.assigned_user -- user
776: FROM wf_item_activity_statuses ias,
777: wf_process_activities pa,
778: wf_activities_vl ac,
779: wf_activities_vl ap,
780: wf_items i
781: WHERE ias.item_type = 'ARCMREQ'
782: AND ias.item_key = p_request_id
783: AND ias.process_activity = pa.instance_id

Line 969: wf_activities_vl ac,

965: SELECT count(*)
966: INTO l_count_activities
967: FROM wf_item_activity_statuses ias,
968: wf_process_activities pa,
969: wf_activities_vl ac,
970: wf_activities_vl ap,
971: wf_items i
972: WHERE ias.item_type = 'ARCMREQ'
973: AND ias.item_key = p_request_id

Line 970: wf_activities_vl ap,

966: INTO l_count_activities
967: FROM wf_item_activity_statuses ias,
968: wf_process_activities pa,
969: wf_activities_vl ac,
970: wf_activities_vl ap,
971: wf_items i
972: WHERE ias.item_type = 'ARCMREQ'
973: AND ias.item_key = p_request_id
974: AND ias.process_activity = pa.instance_id