3:
4: PROCEDURE GET_TBL_SQL(
5: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
6: x_custom_sql OUT NOCOPY VARCHAR2,
7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
8: ) IS
9: l_formula_sql VARCHAR2(4000) := '';
10: l_inner_sql VARCHAR2(8000) := '';
11: l_stmt VARCHAR2(10240) := '';
131: l_item_cat_flag := 0; -- item
132: END IF;
133:
134: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
135: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
136:
137: l_formula_sql :='CURR_PLANNED_QUANTITY OPI_MEASURE1,
138: PREV_PLANNED_STANDARD_VALUE OPI_MEASURE2,
139: CURR_PLANNED_STANDARD_VALUE OPI_MEASURE3,
373:
374: PROCEDURE GET_TRD_SQL(
375: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
376: x_custom_sql OUT NOCOPY VARCHAR2,
377: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
378: ) IS
379:
380: l_formula_sql VARCHAR2(4000) := '';
381: l_inner_sql VARCHAR2(6000) := '';
502: END IF;
503: END IF;
504:
505: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
506: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
507:
508: l_stmt :=
509: 'SELECT
510: fii.NAME VIEWBY,
771:
772: PROCEDURE GET_CMLTV_TRD_SQL(
773: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
774: x_custom_sql OUT NOCOPY VARCHAR2,
775: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
776: ) IS
777: l_formula_sql VARCHAR2(4000) := '';
778: l_inner_sql VARCHAR2(6000) := '';
779: l_stmt VARCHAR2(8000) := '';
928: END IF;
929: END IF;
930:
931: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
932: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
933:
934: l_stmt :='SELECT fact.name VIEWBY,
935: CURR_ACTUAL_STANDARD_VALUE OPI_MEASURE1,
936: CURR_PLANNED_STANDARD_VALUE OPI_MEASURE2,