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_DBI_WMS_PTS_PKG dependencies on POA_DBI_UTIL_PKG

Line 11: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

7: /* No subinventory dimension --> need all measures
8: from isc_wms_000_mv and isc_wms_001_mv */
9: FUNCTION get_sel_clause1 (p_view_by_dim IN VARCHAR2,
10: p_join_tbl IN
11: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
12: RETURN VARCHAR2;
13:
14: /* Subinventory dimension --> don't need to retrieve pick release measures,
15: only measures from isc_wms_001_mv */

Line 18: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

14: /* Subinventory dimension --> don't need to retrieve pick release measures,
15: only measures from isc_wms_001_mv */
16: FUNCTION get_sel_clause2 (p_view_by_dim IN VARCHAR2,
17: p_join_tbl IN
18: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
19: RETURN VARCHAR2;
20:
21: /*------------------------------------------------
22: Report Query for Pick Release To Ship Cycle Time

Line 36: l_mv_tbl poa_dbi_util_pkg.POA_DBI_MV_TBL;

32: l_comparison_type VARCHAR2(1);
33: l_cur_suffix VARCHAR2(10);
34: l_custom_sql VARCHAR2 (10000);
35:
36: l_mv_tbl poa_dbi_util_pkg.POA_DBI_MV_TBL;
37: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
38: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
39: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
40: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

Line 37: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;

33: l_cur_suffix VARCHAR2(10);
34: l_custom_sql VARCHAR2 (10000);
35:
36: l_mv_tbl poa_dbi_util_pkg.POA_DBI_MV_TBL;
37: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
38: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
39: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
40: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
41:

Line 38: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;

34: l_custom_sql VARCHAR2 (10000);
35:
36: l_mv_tbl poa_dbi_util_pkg.POA_DBI_MV_TBL;
37: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
38: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
39: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
40: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
41:
42: l_where_clause1 VARCHAR2 (2000);

Line 39: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

35:
36: l_mv_tbl poa_dbi_util_pkg.POA_DBI_MV_TBL;
37: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
38: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
39: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
40: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
41:
42: l_where_clause1 VARCHAR2 (2000);
43: l_where_clause2 VARCHAR2 (2000);

Line 40: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

36: l_mv_tbl poa_dbi_util_pkg.POA_DBI_MV_TBL;
37: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
38: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
39: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
40: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
41:
42: l_where_clause1 VARCHAR2 (2000);
43: l_where_clause2 VARCHAR2 (2000);
44: l_mv1 VARCHAR2 (30);

Line 60: l_mv_tbl := poa_dbi_util_pkg.POA_DBI_MV_TBL ();

56: l_aggregation_level_flag1 := '0';
57: l_aggregation_level_flag2 := '0';
58:
59: -- clear out the tables.
60: l_mv_tbl := poa_dbi_util_pkg.POA_DBI_MV_TBL ();
61: l_col_tbl1 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
62: l_col_tbl2 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
63: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
64:

Line 61: l_col_tbl1 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

57: l_aggregation_level_flag2 := '0';
58:
59: -- clear out the tables.
60: l_mv_tbl := poa_dbi_util_pkg.POA_DBI_MV_TBL ();
61: l_col_tbl1 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
62: l_col_tbl2 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
63: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
64:
65: -- get all the query parameters

Line 62: l_col_tbl2 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

58:
59: -- clear out the tables.
60: l_mv_tbl := poa_dbi_util_pkg.POA_DBI_MV_TBL ();
61: l_col_tbl1 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
62: l_col_tbl2 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
63: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
64:
65: -- get all the query parameters
66:

Line 63: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

59: -- clear out the tables.
60: l_mv_tbl := poa_dbi_util_pkg.POA_DBI_MV_TBL ();
61: l_col_tbl1 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
62: l_col_tbl2 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
63: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
64:
65: -- get all the query parameters
66:
67: isc_dbi_sutil_pkg.process_parameters (

Line 87: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,

83: p_mv_flag_type => 'FLAG4',
84: p_in_join_tbl => l_in_join_tbl);
85:
86: -- Add measure columns that need to be aggregated
87: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,
88: p_col_name => 'ship_confirm_cnt',
89: p_alias_name => 'ship_confirm_cnt',
90: p_grand_total => 'Y',
91: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 91: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

87: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,
88: p_col_name => 'ship_confirm_cnt',
89: p_alias_name => 'ship_confirm_cnt',
90: p_grand_total => 'Y',
91: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
92: p_to_date_type => 'RLX');
93:
94: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,
95: p_col_name => 'release_to_ship',

Line 94: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,

90: p_grand_total => 'Y',
91: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
92: p_to_date_type => 'RLX');
93:
94: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,
95: p_col_name => 'release_to_ship',
96: p_alias_name => 'release_to_ship',
97: p_grand_total => 'Y',
98: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 98: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

94: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,
95: p_col_name => 'release_to_ship',
96: p_alias_name => 'release_to_ship',
97: p_grand_total => 'Y',
98: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
99: p_to_date_type => 'RLX');
100:
101:
102: IF l_view_by = 'ITEM+ENI_ITEM_ORG' THEN

Line 103: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,

99: p_to_date_type => 'RLX');
100:
101:
102: IF l_view_by = 'ITEM+ENI_ITEM_ORG' THEN
103: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,
104: p_col_name => 'ship_confirm_qty',
105: p_alias_name => 'ship_confirm_qty',
106: p_grand_total => 'N',
107: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

Line 107: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

103: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,
104: p_col_name => 'ship_confirm_qty',
105: p_alias_name => 'ship_confirm_qty',
106: p_grand_total => 'N',
107: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,
108: p_to_date_type => 'RLX');
109: END IF;
110:
111: IF (l_view_by <> 'ORGANIZATION+ORGANIZATION_SUBINVENTORY'

Line 133: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,

129: p_mv_flag_type => 'FLAG5',
130: p_in_join_tbl => l_in_join_tbl);
131:
132: -- Add measure columns that need to be aggregated
133: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
134: p_col_name => 'pick_release_cnt',
135: p_alias_name => 'pick_release_cnt',
136: p_grand_total => 'Y',
137: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 137: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

133: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
134: p_col_name => 'pick_release_cnt',
135: p_alias_name => 'pick_release_cnt',
136: p_grand_total => 'Y',
137: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
138: p_to_date_type => 'RLX');
139:
140: IF l_view_by = 'ITEM+ENI_ITEM_ORG' THEN
141: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,

Line 141: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,

137: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
138: p_to_date_type => 'RLX');
139:
140: IF l_view_by = 'ITEM+ENI_ITEM_ORG' THEN
141: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
142: p_col_name => 'pick_release_qty',
143: p_alias_name => 'pick_release_qty',
144: p_grand_total => 'N',
145: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

Line 145: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

141: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
142: p_col_name => 'pick_release_qty',
143: p_alias_name => 'pick_release_qty',
144: p_grand_total => 'N',
145: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,
146: p_to_date_type => 'RLX');
147: END IF;
148: END IF;
149:

Line 197: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

193: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
194: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
195:
196: -- set the basic bind variables for the status SQL
197: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
198: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output,l_xtd);
199:
200: -- Passing ISC_AGG_FLAGS to PMV
201: IF (l_view_by <> 'ORGANIZATION+ORGANIZATION_SUBINVENTORY'

Line 198: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output,l_xtd);

194: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
195:
196: -- set the basic bind variables for the status SQL
197: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
198: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output,l_xtd);
199:
200: -- Passing ISC_AGG_FLAGS to PMV
201: IF (l_view_by <> 'ORGANIZATION+ORGANIZATION_SUBINVENTORY'
202: AND l_where_clause2 NOT LIKE '%fact.subinventory%') THEN

Line 229: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

225: Description: builds the outer select clause
226: ---------------------------------------------------*/
227: FUNCTION get_sel_clause1(p_view_by_dim IN VARCHAR2,
228: p_join_tbl IN
229: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
230: RETURN VARCHAR2
231: IS
232: l_sel_clause VARCHAR2(32000);
233: l_view_by_col_name VARCHAR2(60);

Line 373: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

369: Description: builds the outer select clause
370: ---------------------------------------------------*/
371: FUNCTION get_sel_clause2(p_view_by_dim IN VARCHAR2,
372: p_join_tbl IN
373: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
374: RETURN VARCHAR2
375: IS
376: l_sel_clause VARCHAR2(32000);
377: l_view_by_col_name VARCHAR2(60);