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 147: MTL_SYSTEM_ITEMS_B MSI

143: SELECT ROUND(SUM( 1 * -- 1 TO REPRESENT UNIT MAT QUANTITY
144: 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
145: INTO x_unit_mat_value
146: FROM CST_CG_ITEM_COSTS_VIEW CCICV,
147: MTL_SYSTEM_ITEMS_B MSI
148: WHERE CCICV.INVENTORY_ITEM_ID = p_inv_id
149: AND CCICV.ORGANIZATION_ID = p_org_id
150: AND CCICV.COST_GROUP_ID = DECODE(p_cost_method,1,1, p_cost_group_id)
151: AND MSI.ORGANIZATION_ID = p_org_id

Line 4558: FROM csi_item_instances cii, mtl_system_items_b msi

4554:
4555: BEGIN
4556: SELECT cii.inventory_item_id, msi.eam_item_type
4557: INTO l_item_id, l_eam_item
4558: FROM csi_item_instances cii, mtl_system_items_b msi
4559: WHERE cii.inventory_item_id = msi.inventory_item_id
4560: AND cii.last_vld_organization_id = msi.organization_id
4561: AND cii.instance_id = p_ce_line_rec.maintenance_object_id;
4562: