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.EAM_CONSTRUCTION_EST_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 142: MTL_SYSTEM_ITEMS_B MSI

138: SELECT ROUND(SUM( 1 * -- 1 TO REPRESENT UNIT MAT QUANTITY
139: DECODE(MSI.EAM_ITEM_TYPE, 3,DECODE(NULL,'Y',0, NVL(CCICV.ITEM_COST,0)), NVL(CCICV.ITEM_COST,0))), p_ext_precision) MAT_VALUE
140: INTO x_unit_mat_value
141: FROM CST_CG_ITEM_COSTS_VIEW CCICV,
142: MTL_SYSTEM_ITEMS_B MSI
143: WHERE CCICV.INVENTORY_ITEM_ID = p_inv_id
144: AND CCICV.ORGANIZATION_ID = p_org_id
145: AND CCICV.COST_GROUP_ID = DECODE(p_cost_method,1,1, p_cost_group_id)
146: AND MSI.ORGANIZATION_ID = p_org_id

Line 4371: FROM csi_item_instances cii, mtl_system_items_b msi

4367:
4368: BEGIN
4369: SELECT cii.inventory_item_id, msi.eam_item_type
4370: INTO l_item_id, l_eam_item
4371: FROM csi_item_instances cii, mtl_system_items_b msi
4372: WHERE cii.inventory_item_id = msi.inventory_item_id
4373: AND cii.last_vld_organization_id = msi.organization_id
4374: AND cii.instance_id = p_ce_line_rec.maintenance_object_id;
4375: