7: */
8: PROCEDURE inv_val_status_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
9: x_custom_sql OUT NOCOPY VARCHAR2,
10: x_custom_output OUT NOCOPY
11: BIS_QUERY_ATTRIBUTES_TBL);
12:
13: PROCEDURE onhand_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
14: x_custom_sql OUT NOCOPY VARCHAR2,
15: x_custom_output OUT NOCOPY
12:
13: PROCEDURE onhand_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
14: x_custom_sql OUT NOCOPY VARCHAR2,
15: x_custom_output OUT NOCOPY
16: BIS_QUERY_ATTRIBUTES_TBL);
17:
18: PROCEDURE intransit_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
19: x_custom_sql OUT NOCOPY VARCHAR2,
20: x_custom_output OUT NOCOPY
17:
18: PROCEDURE intransit_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
19: x_custom_sql OUT NOCOPY VARCHAR2,
20: x_custom_output OUT NOCOPY
21: BIS_QUERY_ATTRIBUTES_TBL);
22:
23: /*
24: Report query for viewby = Time
25: */
25: */
26: PROCEDURE inv_val_trend_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
27: x_custom_sql OUT NOCOPY VARCHAR2,
28: x_custom_output OUT NOCOPY
29: BIS_QUERY_ATTRIBUTES_TBL);
30:
31:
32: /* Report query for inventory value by type report */
33: PROCEDURE inv_val_type_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
32: /* Report query for inventory value by type report */
33: PROCEDURE inv_val_type_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
34: x_custom_sql OUT NOCOPY VARCHAR2,
35: x_custom_output OUT NOCOPY
36: BIS_QUERY_ATTRIBUTES_TBL);
37:
38:
39:
40: END OPI_DBI_INV_MGMT_RPT_PKG;