APPS.ISC_FS_TRV_TIM_DIS_VAR_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 331: from ' || poa_dbi_template_pkg.status_sql

327: , p_prefix => 'c_'
328: , p_suffix => '/abs(decode(c_count_dur_task_total,0,null,c_count_dur_task_total))*100'
329: , p_total_flag => 'Y'
330: ) || '
331: from ' || poa_dbi_template_pkg.status_sql
332: ( p_fact_name => l_mv
333: , p_where_clause => l_where_clause
334: , p_join_tables => l_join_tbl
335: , p_use_windowing => 'Y' --'N'

Line 608: from ' || poa_dbi_template_pkg.status_sql

604: , p_prefix => 'c_'
605: , p_suffix => '/abs(decode(c_count_dist_task_total,0,null,c_count_dist_task_total))*100'
606: , p_total_flag => 'Y'
607: ) || '
608: from ' || poa_dbi_template_pkg.status_sql
609: ( p_fact_name => l_mv
610: , p_where_clause => l_where_clause
611: , p_join_tables => l_join_tbl
612: , p_use_windowing => 'Y' --'N'

Line 745: ( select * from ( ' || poa_dbi_template_pkg.status_sql

741: , nvl(avg(c_count_dur_task_total) over(),0) ISC_MEASURE_4
742: , decode(avg(c_count_dur_task_total) over(),null,null,100) ISC_MEASURE_5
743: , ''pFunctionName=ISC_FS_TRV_TIM_DIS_RPT_REP&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' ISC_ATTRIBUTE_1
744: from
745: ( select * from ( ' || poa_dbi_template_pkg.status_sql
746: ( p_fact_name => l_mv
747: , p_where_clause => l_where_clause
748: , p_join_tables => l_join_tbl
749: , p_use_windowing => 'N'

Line 888: ( select * from ( ' || poa_dbi_template_pkg.status_sql

884: , nvl(avg(c_count_dist_task_total) over(),0) ISC_MEASURE_4
885: , decode (avg(c_count_dist_task_total) over(),null,null,100) ISC_MEASURE_5
886: , ''pFunctionName=ISC_FS_TRV_TIM_DIS_RPT_REP&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' ISC_ATTRIBUTE_1
887: from
888: ( select * from ( ' || poa_dbi_template_pkg.status_sql
889: ( p_fact_name => l_mv
890: , p_where_clause => l_where_clause
891: , p_join_tables => l_join_tbl
892: , p_use_windowing => 'N'