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.ONT_PRT_MARGIN_ANA_PKG dependencies on CST_MARGIN_SUMMARY

Line 5: sum_margin cst_margin_summary.margin%TYPE;

1: PACKAGE BODY ONT_PRT_MARGIN_ANA_PKG as
2: /* $Header: ONTCSMAB.pls 120.0 2005/06/01 01:59:00 appldev noship $ */
3: procedure BUILD_ONT_PRT_MARGIN_TABLE AS
4: records_processed number;
5: sum_margin cst_margin_summary.margin%TYPE;
6: CURSOR wkly_amt_cursor IS
7: SELECT
8: cms.build_id,
9: cms.customer_id,

Line 18: CST_MARGIN_SUMMARY cms,

14: cms.sold_to_customer_name,
15: sum(invoiced_amount) sum_inv_amt,
16: sum(cogs_amount) sum_cogs_amt
17: FROM
18: CST_MARGIN_SUMMARY cms,
19: CST_MARGIN_BUILD cmb
20: WHERE
21: cms.build_id = cmb.build_id AND
22: cms.gl_date >= cmb.to_date - 7 AND

Line 23: cms.build_id = (select max(build_id) from cst_margin_summary)

19: CST_MARGIN_BUILD cmb
20: WHERE
21: cms.build_id = cmb.build_id AND
22: cms.gl_date >= cmb.to_date - 7 AND
23: cms.build_id = (select max(build_id) from cst_margin_summary)
24: GROUP BY
25: cms.build_id,
26: cms.customer_id,
27: cms.primary_salesrep_id,

Line 46: CST_MARGIN_SUMMARY cms,

42: cms.sold_to_customer_name,
43: sum(invoiced_amount) sum_inv_amt,
44: sum(cogs_amount) sum_cogs_amt
45: FROM
46: CST_MARGIN_SUMMARY cms,
47: CST_MARGIN_BUILD cmb
48: WHERE
49: cms.build_id = cmb.build_id AND
50: cms.gl_date >= cmb.to_date - 30 AND

Line 51: cms.build_id = (select max(build_id) from cst_margin_summary)

47: CST_MARGIN_BUILD cmb
48: WHERE
49: cms.build_id = cmb.build_id AND
50: cms.gl_date >= cmb.to_date - 30 AND
51: cms.build_id = (select max(build_id) from cst_margin_summary)
52: GROUP BY
53: cms.build_id,
54: cms.customer_id,
55: cms.primary_salesrep_id,

Line 74: CST_MARGIN_SUMMARY cms,

70: cms.sold_to_customer_name,
71: sum(invoiced_amount) sum_inv_amt,
72: sum(cogs_amount) sum_cogs_amt
73: FROM
74: CST_MARGIN_SUMMARY cms,
75: CST_MARGIN_BUILD cmb
76: WHERE
77: cms.build_id = cmb.build_id AND
78: cms.gl_date >= cmb.to_date - 90 AND

Line 79: cms.build_id = (select max(build_id) from cst_margin_summary)

75: CST_MARGIN_BUILD cmb
76: WHERE
77: cms.build_id = cmb.build_id AND
78: cms.gl_date >= cmb.to_date - 90 AND
79: cms.build_id = (select max(build_id) from cst_margin_summary)
80: GROUP BY
81: cms.build_id,
82: cms.customer_id,
83: cms.primary_salesrep_id,

Line 101: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;

97: records_processed := 0;
98: FOR wkly_amt_rec IN wkly_amt_cursor LOOP
99: --
100: declare
101: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
102: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
103: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
104: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
105: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;

Line 102: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;

98: FOR wkly_amt_rec IN wkly_amt_cursor LOOP
99: --
100: declare
101: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
102: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
103: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
104: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
105: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;
106: --

Line 103: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;

99: --
100: declare
101: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
102: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
103: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
104: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
105: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;
106: --
107: begin

Line 104: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;

100: declare
101: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
102: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
103: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
104: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
105: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;
106: --
107: begin
108: tmp_build_id := wkly_amt_rec.build_id;

Line 105: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;

101: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
102: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
103: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
104: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
105: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;
106: --
107: begin
108: tmp_build_id := wkly_amt_rec.build_id;
109: tmp_customer_id := wkly_amt_rec.customer_id;

Line 207: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;

203: records_processed := 0;
204: FOR mnthly_amt_rec IN mnthly_amt_cursor LOOP
205: --
206: declare
207: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
208: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
209: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
210: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
211: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;

Line 208: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;

204: FOR mnthly_amt_rec IN mnthly_amt_cursor LOOP
205: --
206: declare
207: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
208: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
209: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
210: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
211: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;
212: --

Line 209: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;

205: --
206: declare
207: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
208: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
209: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
210: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
211: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;
212: --
213: begin

Line 210: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;

206: declare
207: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
208: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
209: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
210: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
211: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;
212: --
213: begin
214: tmp_build_id := mnthly_amt_rec.build_id;

Line 211: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;

207: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
208: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
209: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
210: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
211: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;
212: --
213: begin
214: tmp_build_id := mnthly_amt_rec.build_id;
215: tmp_customer_id := mnthly_amt_rec.customer_id;

Line 313: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;

309: records_processed := 0;
310: FOR qrtrly_amt_rec IN qrtrly_amt_cursor LOOP
311: --
312: declare
313: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
314: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
315: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
316: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
317: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;

Line 314: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;

310: FOR qrtrly_amt_rec IN qrtrly_amt_cursor LOOP
311: --
312: declare
313: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
314: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
315: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
316: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
317: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;
318: --

Line 315: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;

311: --
312: declare
313: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
314: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
315: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
316: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
317: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;
318: --
319: begin

Line 316: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;

312: declare
313: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
314: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
315: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
316: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
317: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;
318: --
319: begin
320: tmp_build_id := qrtrly_amt_rec.build_id;

Line 317: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;

313: tmp_build_id CST_MARGIN_SUMMARY.build_id%TYPE;
314: tmp_customer_id CST_MARGIN_SUMMARY.customer_id%TYPE;
315: tmp_pri_salesrep_id CST_MARGIN_SUMMARY.primary_salesrep_id%TYPE;
316: tmp_territory_id CST_MARGIN_SUMMARY.territory_id%TYPE;
317: tmp_inv_item_id CST_MARGIN_SUMMARY.inventory_item_id%TYPE;
318: --
319: begin
320: tmp_build_id := qrtrly_amt_rec.build_id;
321: tmp_customer_id := qrtrly_amt_rec.customer_id;

Line 419: -- CST_MARGIN_SUMMARY table based on the period passed in

415: end BUILD_ONT_PRT_MARGIN_TABLE;
416:
417:
418: -- GET_TOTAL_SALES ==> returns the sum of the invoiced_amounts from the
419: -- CST_MARGIN_SUMMARY table based on the period passed in
420: --
421: function get_total_sales (in_period in varchar2) return number as
422: tot_inv_amount number;
423: begin

Line 433: -- CST_MARGIN_SUMMARY table based on the period passed in

429: end get_total_sales;
430: --
431:
432: -- GET_TOTAL_MARGIN ==>returns the sum of the margins from the
433: -- CST_MARGIN_SUMMARY table based on the period passed in
434: --
435: function get_total_margin (in_period in varchar2) return number as
436: tot_margin_amount number;
437: begin