eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_DEPOT_MTTR_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 32: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

28: -- MEAN TIME TO REPAIR STATUS REPORT
29:
30: PROCEDURE GET_MTTR_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
31: x_custom_sql OUT NOCOPY VARCHAR2,
32: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
33: IS
34: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
35: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
36: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

Line 46: l_custom_rec BIS_QUERY_ATTRIBUTES;

42: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
43: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
44: l_mv_set VARCHAR2(50);
45: l_aggregation_flag NUMBER;
46: l_custom_rec BIS_QUERY_ATTRIBUTES;
47: l_mv_type VARCHAR2(10);
48: l_err_stage VARCHAR2(32767);
49: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
50: l_debug_mode VARCHAR2(1);

Line 125: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

121: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
122: END IF;
123:
124: -- prepare output for bind variables
125: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
126: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
127:
128: -- set the basic bind variables for the status SQL
129: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

Line 344: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

340: -- MEAN TIME TO REPAIR TREND REPORT
341:
342: PROCEDURE GET_MTTR_TRD_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
343: x_custom_sql OUT NOCOPY VARCHAR2,
344: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
345: IS
346:
347: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
348: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;

Line 359: l_custom_rec BIS_QUERY_ATTRIBUTES;

355: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
356: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
357: l_mv_set VARCHAR2(50);
358: l_aggregation_flag NUMBER;
359: l_custom_rec BIS_QUERY_ATTRIBUTES;
360: l_mv_type VARCHAR2(10);
361: l_err_stage VARCHAR2(32767);
362: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
363: l_debug_mode VARCHAR2(1);

Line 437: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

433: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TRD : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
434: END IF;
435:
436: -- prepare output for bind variables
437: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
438: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
439:
440: -- set the basic bind variables for the trend SQL
441: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,

Line 507: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

503: -- MEAN TIME TO REPAIR DETAIL REPORT
504:
505: PROCEDURE GET_MTTR_DTL_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
506: x_custom_sql OUT NOCOPY VARCHAR2,
507: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
508: IS
509:
510: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
511: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;

Line 522: l_custom_rec BIS_QUERY_ATTRIBUTES;

518: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
519: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
520: l_mv_set VARCHAR2(50);
521: l_aggregation_flag NUMBER;
522: l_custom_rec BIS_QUERY_ATTRIBUTES;
523: l_mv_type VARCHAR2(10);
524: l_err_stage VARCHAR2(32767);
525: l_debug_mode VARCHAR2(1);
526: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;

Line 659: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

655: -- MEAN TIME TO REPAIR DISTRIBUTION STATUS REPORT
656:
657: PROCEDURE GET_MTTR_DIST_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
658: x_custom_sql OUT NOCOPY VARCHAR2,
659: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
660: IS
661: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
662: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
663: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;

Line 673: l_custom_rec BIS_QUERY_ATTRIBUTES;

669: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
670: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
671: l_mv_set VARCHAR2(50);
672: l_aggregation_flag NUMBER;
673: l_custom_rec BIS_QUERY_ATTRIBUTES;
674: l_mv_type VARCHAR2(10);
675: l_err_stage VARCHAR2(32767);
676: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
677: l_debug_mode VARCHAR2(1);

Line 753: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

749: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
750: END IF;
751:
752: -- prepare output for bind variables
753: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
754: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
755:
756: -- set the basic bind variables for the status SQL
757: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

Line 912: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

908: -- MEAN TIME TO REPAIR DISTRIBUTION TREND REPORT
909:
910: PROCEDURE GET_MTTR_DIST_TRD_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
911: x_custom_sql OUT NOCOPY VARCHAR2,
912: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
913: IS
914:
915: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
916: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;

Line 927: l_custom_rec BIS_QUERY_ATTRIBUTES;

923: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
924: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
925: l_mv_set VARCHAR2(50);
926: l_aggregation_flag NUMBER;
927: l_custom_rec BIS_QUERY_ATTRIBUTES;
928: l_mv_type VARCHAR2(10);
929: l_err_stage VARCHAR2(32767);
930: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
931: l_debug_mode VARCHAR2(1);

Line 1004: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1000: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TRD : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
1001: END IF;
1002:
1003: -- prepare output for bind variables
1004: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1005: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1006:
1007: -- set the basic bind variables for the trend SQL
1008: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,

Line 1073: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1069: -- REPAIR ORDER SERVICE CODE SUMMARY REPORT
1070:
1071: PROCEDURE GET_SRVC_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1072: x_custom_sql OUT NOCOPY VARCHAR2,
1073: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1074: IS
1075: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
1076: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
1077: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;

Line 1087: l_custom_rec BIS_QUERY_ATTRIBUTES;

1083: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
1084: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
1085: l_mv_set VARCHAR2(50);
1086: l_aggregation_flag NUMBER;
1087: l_custom_rec BIS_QUERY_ATTRIBUTES;
1088: l_mv_type VARCHAR2(10);
1089: l_err_stage VARCHAR2(32767);
1090: l_debug_mode VARCHAR2(1);
1091: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;

Line 1155: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1151: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_SRVC_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
1152: END IF;
1153:
1154: -- prepare output for bind variables
1155: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1156: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1157:
1158: -- set the basic bind variables for the status SQL
1159: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);