APPS.AZW_ARCHIVE dependencies on AZ_TASKS_V

Line 127: FROM az_tasks_v atv

123: assigned_user_display_name
124: ,atv.begin_date
125: ,atv.end_date
126: ,atv.duration
127: FROM az_tasks_v atv
128: ,az_processes_all_v apv
129: ,fnd_lookups fl
130: WHERE atv.item_type = apv.item_type
131: AND atv.root_activity = apv.process_name

Line 246: l_item_type az_tasks_v.item_type%TYPE;

242: * Private procedure. To be called by Run to copy the task steps information
243: * into the archive table, az_archive_task_steps.
244: *-----------------------------------------------------------------------*/
245: PROCEDURE Task_Steps IS
246: l_item_type az_tasks_v.item_type%TYPE;
247: l_item_key az_tasks_v.item_key%TYPE;
248: CURSOR all_tasks_cursor IS
249: SELECT atv.item_type||'.'||atv.root_activity||'.'||atv.context_id||'.'||
250: TO_CHAR(TO_NUMBER(atv.item_key), '00000') node_id,

Line 247: l_item_key az_tasks_v.item_key%TYPE;

243: * into the archive table, az_archive_task_steps.
244: *-----------------------------------------------------------------------*/
245: PROCEDURE Task_Steps IS
246: l_item_type az_tasks_v.item_type%TYPE;
247: l_item_key az_tasks_v.item_key%TYPE;
248: CURSOR all_tasks_cursor IS
249: SELECT atv.item_type||'.'||atv.root_activity||'.'||atv.context_id||'.'||
250: TO_CHAR(TO_NUMBER(atv.item_key), '00000') node_id,
251: atv.item_type item_type,

Line 253: FROM az_tasks_v atv;

249: SELECT atv.item_type||'.'||atv.root_activity||'.'||atv.context_id||'.'||
250: TO_CHAR(TO_NUMBER(atv.item_key), '00000') node_id,
251: atv.item_type item_type,
252: atv.item_key item_key
253: FROM az_tasks_v atv;
254:
255: CURSOR all_steps_cursor IS
256: SELECT wiasv.activity_type_code type
257: --,wiasv.activity_type_display_name