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
23: cms.build_id = (select max(build_id) from cst_margin_summary)
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
51: cms.build_id = (select max(build_id) from cst_margin_summary)
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
79: cms.build_id = (select max(build_id) from cst_margin_summary)