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_CMCOMMON dependencies on GMF_LOT_COSTS

Line 1196: gmf_lot_costs h

1192: )
1193: IS
1194: SELECT sum(component_cost)
1195: FROM gmf_lot_cost_details d,
1196: gmf_lot_costs h
1197: WHERE h.header_id = v_header_id
1198: AND h.header_id = d.header_id
1199: AND h.lot_number = nvl(v_lot_number ,h.lot_number);
1200:

Line 1222: FROM gmf_lot_costs

1218: v_organization_id IN VARCHAR2
1219: )
1220: IS
1221: SELECT MAX(header_id)
1222: FROM gmf_lot_costs
1223: WHERE inventory_item_id = p_inventory_item_id
1224: AND cost_type_id = v_cost_type_id
1225: AND lot_number = v_lot_number
1226: AND cost_date <= v_trans_date

Line 1246: FROM gmf_lot_costs

1242: PARTITION BY lot_number
1243: ORDER BY cost_date desc,
1244: header_id desc
1245: ) as rank
1246: FROM gmf_lot_costs
1247: WHERE cost_date <= v_trans_date
1248: AND inventory_item_id = v_item_id
1249: AND organization_id = v_organization_id
1250: AND cost_type_id = v_cost_type_id