APPS.ISC_FS_TRV_TIM_DIS_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 438: from ' || poa_dbi_template_pkg.status_sql

434: , 'N'
435: ) || '
436: , p_tot_trv_dur_min_total ISC_MEASURE_15
437: , p_tot_trv_dist_total ISC_MEASURE_18
438: from ' || poa_dbi_template_pkg.status_sql
439: ( p_fact_name => l_mv
440: , p_where_clause => l_where_clause
441: , p_join_tables => l_join_tbl
442: , p_use_windowing => 'Y'

Line 913: from ' || poa_dbi_template_pkg.trend_sql

909: )
910: , 'ISC_MEASURE_6'
911: , 'N'
912: ) || '
913: from ' || poa_dbi_template_pkg.trend_sql
914: ( p_xtd => l_xtd
915: , p_comparison_type => l_comparison_type
916: , p_fact_name => l_mv
917: , p_where_clause => l_where_clause

Line 1093: from ' || poa_dbi_template_pkg.trend_sql

1089: , 'p_tot_trv_dist'
1090: , 'ISC_MEASURE_6'
1091: , 'N'
1092: ) || '
1093: from ' || poa_dbi_template_pkg.trend_sql
1094: ( p_xtd => l_xtd
1095: , p_comparison_type => l_comparison_type
1096: , p_fact_name => l_mv
1097: , p_where_clause => l_where_clause

Line 1345: from ' || poa_dbi_template_pkg.status_sql

1341: , p_prefix => 'nvl(c_'
1342: , p_suffix => ',0)/abs(decode(c_count_dur_task_total,0,null,c_count_dur_task_total))*100'
1343: , p_total_flag => 'Y'
1344: ) || '
1345: from ' || poa_dbi_template_pkg.status_sql
1346: ( p_fact_name => l_mv
1347: , p_where_clause => l_where_clause
1348: , p_join_tables => l_join_tbl
1349: , p_use_windowing => 'Y' --'N'

Line 1585: from ' || poa_dbi_template_pkg.status_sql

1581: , p_prefix => 'nvl(c_'
1582: , p_suffix => ',0)/abs(decode(c_count_dist_task_total,0,null,c_count_dist_task_total))*100'
1583: , p_total_flag => 'Y'
1584: ) || '
1585: from ' || poa_dbi_template_pkg.status_sql
1586: ( p_fact_name => l_mv
1587: , p_where_clause => l_where_clause
1588: , p_join_tables => l_join_tbl
1589: , p_use_windowing => 'Y' --'N'