DBA Data[Home] [Help]

APPS.ONT_PRT_MARGIN_ANA_PKG dependencies on CST_MARGIN_BUILD

Line 19: CST_MARGIN_BUILD cmb

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)

Line 47: CST_MARGIN_BUILD cmb

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)

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_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)