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.GMF_ITEMCOST_PVT dependencies on CM_CMPT_MST

Line 46: --| Code modified in PROCEDURE Get_Item_Cost. Joined cm_cmpt_mst and |

42: --| number to find the fixes. |
43: --| 24/DEC/2002 Uday Moogala Bug# 2722404 |
44: --| Removed creation_date and created_by from update stmts. |
45: --| 16-APR-2009 Uday Phadtare Bug 7631080. |
46: --| Code modified in PROCEDURE Get_Item_Cost. Joined cm_cmpt_mst and |
47: --| cm_cmpt_dtl tables to avoid cartesian product. |
48: --+==========================================================================+
49: -- End of comments
50:

Line 1253: --| CURSOR cm_cmpt_dtl modified. Joined cm_cmpt_mst and cm_cmpt_dtl |

1249: --| HISTORY |
1250: --| 01-Mar-01 Uday Moogala - Created |
1251: --| |
1252: --| 16-APR-2009 Uday Phadtare Bug 7631080. |
1253: --| CURSOR cm_cmpt_dtl modified. Joined cm_cmpt_mst and cm_cmpt_dtl |
1254: --| tables to avoid cartesian product. |
1255: --+========================================================================+
1256: -- End of comments
1257: PROCEDURE Get_Item_Cost

Line 1295: FROM cm_cmpt_mst cm, cm_cmpt_dtl cd

1291: cd.attribute16, cd.attribute17, cd.attribute18, cd.attribute19,
1292: cd.attribute20, cd.attribute21, cd.attribute22, cd.attribute23,
1293: cd.attribute24, cd.attribute25, cd.attribute26, cd.attribute27,
1294: cd.attribute28, cd.attribute29, cd.attribute30, cd.attribute_category
1295: FROM cm_cmpt_mst cm, cm_cmpt_dtl cd
1296: WHERE cd.inventory_item_id = p_header_rec.inventory_item_id
1297: AND cd.organization_id = p_header_rec.organization_id
1298: AND cd.period_id = p_header_rec.period_id
1299: AND cd.cost_type_id = p_header_rec.cost_type_id