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.OPI_DBI_WMS_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 31: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

27: -- Description: Generate query for Picks and Exception Analysis Report
28: -- -------------------------------------------------------------------
29: PROCEDURE GET_PICK_EX_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
30: x_custom_sql OUT NOCOPY VARCHAR2,
31: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
32:
33: IS
34:
35: l_query VARCHAR2(15000);

Line 48: l_custom_rec BIS_QUERY_ATTRIBUTES;

44: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
45: l_where_clause VARCHAR2 (2000);
46: l_mv VARCHAR2 (30);
47: l_aggregation_level_flag VARCHAR2(10);
48: l_custom_rec BIS_QUERY_ATTRIBUTES;
49: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
50: l_filter_where VARCHAR2(120);
51: BEGIN
52: -- initialization block

Line 121: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

117: p_generate_viewby => 'Y',
118: p_in_join_tables => NULL);
119:
120: -- prepare output for bind variables
121: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
122: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
123:
124: -- set the basic bind variables for the status SQL
125: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

Line 353: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

349: -- Description: Generate query for Picks Exception By Reason Report
350: -- -------------------------------------------------------------------
351: PROCEDURE GET_EX_REASON_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
352: x_custom_sql OUT NOCOPY VARCHAR2,
353: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
354:
355: IS
356: l_query VARCHAR2(15000);
357: l_view_by VARCHAR2(120);

Line 369: l_custom_rec BIS_QUERY_ATTRIBUTES;

365: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
366: l_where_clause VARCHAR2 (2000);
367: l_mv VARCHAR2 (30);
368: l_aggregation_level_flag VARCHAR2(10);
369: l_custom_rec BIS_QUERY_ATTRIBUTES;
370: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
371:
372: BEGIN
373: -- initialization block

Line 424: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

420: p_generate_viewby => 'Y',
421: p_in_join_tables => NULL);
422:
423: -- prepare output for bind variables
424: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
425: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
426:
427: -- set the basic bind variables for the status SQL
428: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

Line 525: BIS_QUERY_ATTRIBUTES_TBL)

521: -- -------------------------------------------------------------
522: PROCEDURE get_pick_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
523: x_custom_sql OUT NOCOPY VARCHAR2,
524: x_custom_output OUT NOCOPY
525: BIS_QUERY_ATTRIBUTES_TBL)
526: IS
527: l_query VARCHAR2(32767);
528: l_view_by VARCHAR2(120);
529: l_view_by_col VARCHAR2 (120);

Line 540: l_custom_rec BIS_QUERY_ATTRIBUTES;

536: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
537: l_where_clause VARCHAR2 (2000);
538: l_mv VARCHAR2 (30);
539: l_aggregation_level_flag VARCHAR2(10);
540: l_custom_rec BIS_QUERY_ATTRIBUTES;
541: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
542: BEGIN
543: -- initialization block
544: l_comparison_type := 'Y';

Line 608: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

604: p_fact_hint => poa_dbi_sutil_pkg.get_fact_hint(l_mv)
605: );
606:
607: -- prepare output for bind variables
608: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
609: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
610:
611: -- set the basic bind variables for the trend SQL
612: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,

Line 699: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

695: -- Description: Generate query for Picks and Exception Analysis Report
696: -- -------------------------------------------------------------------
697: PROCEDURE GET_OPP_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
698: x_custom_sql OUT NOCOPY VARCHAR2,
699: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
700:
701: IS
702: l_query VARCHAR2(15000);
703: l_view_by VARCHAR2(120);

Line 715: l_custom_rec BIS_QUERY_ATTRIBUTES;

711: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
712: l_where_clause VARCHAR2 (2000);
713: l_mv VARCHAR2 (30);
714: l_aggregation_level_flag VARCHAR2(10);
715: l_custom_rec BIS_QUERY_ATTRIBUTES;
716: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
717: l_filter_where VARCHAR2(120);
718: BEGIN
719: -- initialization block

Line 796: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

792: p_generate_viewby => 'Y',
793: p_in_join_tables => NULL);
794:
795: -- prepare output for bind variables
796: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
797: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
798:
799: -- set the basic bind variables for the status SQL
800: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

Line 978: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

974: -- Description: Generate query for Op Plan Exception by Reason Report
975: -- -------------------------------------------------------------------
976: PROCEDURE GET_OP_EX_REASON_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
977: x_custom_sql OUT NOCOPY VARCHAR2,
978: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
979:
980: IS
981: l_query VARCHAR2(15000);
982: l_view_by VARCHAR2(120);

Line 994: l_custom_rec BIS_QUERY_ATTRIBUTES;

990: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
991: l_where_clause VARCHAR2 (2000);
992: l_mv VARCHAR2 (30);
993: l_aggregation_level_flag VARCHAR2(10);
994: l_custom_rec BIS_QUERY_ATTRIBUTES;
995: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
996: l_filter_where VARCHAR2(120);
997: BEGIN
998: -- initialization block

Line 1050: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1046: p_filter_where => l_filter_where,
1047: p_generate_viewby => 'Y',
1048: p_in_join_tables => NULL);
1049: -- prepare output for bind variables
1050: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1051: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1052:
1053: -- set the basic bind variables for the status SQL
1054: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);