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_STOR_UTZ_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 316: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

312:
313: -- initialization block
314: x_custom_sql := NULL;
315: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();
316: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
317: l_query := NULL;
318: l_custom_sql := NULL;
319: l_view_by := NULL;
320: l_view_by_col := NULL;

Line 411: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

407:
408: -- Subinventory aggregation level flag.
409: l_custom_rec.attribute_name := ':OPI_WMS_STOR_UTZ_FLAG';
410: l_custom_rec.attribute_value := l_aggr_level_flag;
411: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
412: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
413: x_custom_output.extend;
414: x_custom_output(x_custom_output.count) := l_custom_rec;
415:

Line 412: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

408: -- Subinventory aggregation level flag.
409: l_custom_rec.attribute_name := ':OPI_WMS_STOR_UTZ_FLAG';
410: l_custom_rec.attribute_value := l_aggr_level_flag;
411: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
412: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
413: x_custom_output.extend;
414: x_custom_output(x_custom_output.count) := l_custom_rec;
415:
416: x_custom_sql := l_query;

Line 529: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

525:
526: -- initialization block
527: x_custom_sql := NULL;
528: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();
529: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
530: l_query := NULL;
531: l_custom_sql := NULL;
532: l_view_by := NULL;
533: l_view_by_col := NULL;

Line 614: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

610:
611: -- Subinventory aggregation level flag.
612: l_custom_rec.attribute_name := ':OPI_WMS_STOR_UTZ_FLAG';
613: l_custom_rec.attribute_value := l_aggr_level_flag;
614: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
615: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
616: x_custom_output.extend;
617: x_custom_output(x_custom_output.count) := l_custom_rec;
618:

Line 615: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

611: -- Subinventory aggregation level flag.
612: l_custom_rec.attribute_name := ':OPI_WMS_STOR_UTZ_FLAG';
613: l_custom_rec.attribute_value := l_aggr_level_flag;
614: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
615: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
616: x_custom_output.extend;
617: x_custom_output(x_custom_output.count) := l_custom_rec;
618:
619: x_custom_sql := l_query;

Line 998: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

994:
995: -- Common
996: x_custom_sql := NULL;
997: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();
998: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
999: l_view_by := NULL;
1000: l_view_by_col := NULL;
1001: l_xtd := NULL;
1002: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

Line 1347: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1343:
1344: -- Item aggregation level flag.
1345: l_custom_rec.attribute_name := ':OPI_WMS_CURR_UTZ_ITEM_FLAG';
1346: l_custom_rec.attribute_value := l_item_aggr_level_flag;
1347: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1348: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1349: x_custom_output.extend;
1350: x_custom_output(x_custom_output.count) := l_custom_rec;
1351:

Line 1348: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1344: -- Item aggregation level flag.
1345: l_custom_rec.attribute_name := ':OPI_WMS_CURR_UTZ_ITEM_FLAG';
1346: l_custom_rec.attribute_value := l_item_aggr_level_flag;
1347: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1348: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1349: x_custom_output.extend;
1350: x_custom_output(x_custom_output.count) := l_custom_rec;
1351:
1352: -- Subinventory aggregation level flag.

Line 1355: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1351:
1352: -- Subinventory aggregation level flag.
1353: l_custom_rec.attribute_name := ':OPI_WMS_CURR_UTZ_SUB_FLAG';
1354: l_custom_rec.attribute_value := l_sub_aggr_level_flag;
1355: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1356: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1357: x_custom_output.extend;
1358: x_custom_output(x_custom_output.count) := l_custom_rec;
1359:

Line 1356: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1352: -- Subinventory aggregation level flag.
1353: l_custom_rec.attribute_name := ':OPI_WMS_CURR_UTZ_SUB_FLAG';
1354: l_custom_rec.attribute_value := l_sub_aggr_level_flag;
1355: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1356: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1357: x_custom_output.extend;
1358: x_custom_output(x_custom_output.count) := l_custom_rec;
1359:
1360: -- Return the entire SQL query.