APPS.ICX_MARGIN_WEB_ANA_PKG dependencies on CST_MARGIN_BUILD

Line 21: CST_MARGIN_BUILD cmb

17: sum(invoiced_amount) sum_inv_amt,
18: sum(cogs_amount) sum_cogs_amt
19: FROM
20: CST_MARGIN_TEMP cmt,
21: CST_MARGIN_BUILD cmb
22: WHERE
23: cmt.build_id = cmb.build_id AND
24: cmt.gl_date >= cmb.to_date - 7 AND
25: cmt.build_id = (select max(build_id) from cst_margin_temp)

Line 48: CST_MARGIN_BUILD cmb

44: sum(invoiced_amount) sum_inv_amt,
45: sum(cogs_amount) sum_cogs_amt
46: FROM
47: CST_MARGIN_TEMP cmt,
48: CST_MARGIN_BUILD cmb
49: WHERE
50: cmt.build_id = cmb.build_id AND
51: cmt.gl_date >= cmb.to_date - 30 AND
52: cmt.build_id = (select max(build_id) from cst_margin_temp)

Line 75: CST_MARGIN_BUILD cmb

71: sum(invoiced_amount) sum_inv_amt,
72: sum(cogs_amount) sum_cogs_amt
73: FROM
74: CST_MARGIN_TEMP cmt,
75: CST_MARGIN_BUILD cmb
76: WHERE
77: cmt.build_id = cmb.build_id AND
78: cmt.gl_date >= cmb.to_date - 90 AND
79: cmt.build_id = (select max(build_id) from cst_margin_temp)