APPS.ISC_FS_TASK_ETL_PKG dependencies on ISC_FS_TASKS_F

Line 342: -- truncate the isc_fs_tasks_f fact table

338: end if;
339:
340: bis_collection_utilities_log( 'Event logging enabled', 1 );
341:
342: -- truncate the isc_fs_tasks_f fact table
343: l_stmt_id := 70;
344: if truncate_table
345: ( l_isc_schema
346: , 'ISC_FS_TASKS_F'

Line 346: , 'ISC_FS_TASKS_F'

342: -- truncate the isc_fs_tasks_f fact table
343: l_stmt_id := 70;
344: if truncate_table
345: ( l_isc_schema
346: , 'ISC_FS_TASKS_F'
347: , l_error_message ) <> 0 then
348: logger( l_proc_name, l_stmt_id, l_error_message );
349: raise l_exception;
350: end if;

Line 393: parallel(isc_fs_tasks_f)

389:
390: -- insert into base fact tables
391: l_stmt_id := 100;
392: insert /*+ append
393: parallel(isc_fs_tasks_f)
394: parallel(isc_fs_task_assignmnts_f)
395: parallel(isc_fs_capacity_f)
396: */
397: ALL

Line 399: isc_fs_tasks_f

395: parallel(isc_fs_capacity_f)
396: */
397: ALL
398: when source_object_type_code = 'SR' and task_rn = 1 then into
399: isc_fs_tasks_f
400: ( task_id
401: , task_number
402: , task_type_id
403: , task_type_rule

Line 686: -- simple columns for isc_fs_tasks_f

682: parallel(x)
683: */
684: x.task_id
685: --
686: -- simple columns for isc_fs_tasks_f
687: --
688: , x.task_rn
689: , x.task_number
690: , x.task_type_id

Line 719: -- complex columns for isc_fs_tasks_f

715: , x.task_completed_flag
716: , x.task_closed_flag
717: , x.task_deleted_flag
718: --
719: -- complex columns for isc_fs_tasks_f
720: --
721: -- returns the date of the first created (not cancelled) assignment for the task
722: -- R12 impact
723: , min( x.asgn_creation_date_unc )

Line 1548: -- to break join with isc_fs_tasks_f later

1544: merge into isc_fs_task_assignmnts_f o
1545: using (
1546: select /*+ ordered use_nl(TA,TS,T_SCH,T_ACT,E_ACT,DGA) */
1547: -- deleted task assignments are moved to negative task_id
1548: -- to break join with isc_fs_tasks_f later
1549: nvl(ta.task_id,0-e.task_id) task_id
1550: , e.task_assignment_id
1551: , decode(ta.task_id,null,'Y','N') deleted_flag
1552: , nvl(ts.cancelled_flag,'N') cancelled_flag

Line 1709: -- do the merge into isc_fs_tasks_f

1705: l_rowcount := sql%rowcount;
1706:
1707: bis_collection_utilities_log( l_rowcount || ' rows merged into task assignments base summary', 1 );
1708:
1709: -- do the merge into isc_fs_tasks_f
1710: l_stmt_id := 80;
1711: merge into isc_fs_tasks_f o
1712: using (
1713: select

Line 1711: merge into isc_fs_tasks_f o

1707: bis_collection_utilities_log( l_rowcount || ' rows merged into task assignments base summary', 1 );
1708:
1709: -- do the merge into isc_fs_tasks_f
1710: l_stmt_id := 80;
1711: merge into isc_fs_tasks_f o
1712: using (
1713: select
1714: task_id
1715: , task_number