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.MSD_SR_UTIL dependencies on FII_TIME_RPT_STRUCT_V

Line 1326: fii_time_rpt_struct_v cal

1322: SELECT c_onhand_qty
1323: FROM (select fact.item_org_id,
1324: sum(decode(cal.report_date, p_transaction_date, onhand_qty, null)) c_onhand_qty
1325: from opi_inv_val_sum_mv fact,
1326: fii_time_rpt_struct_v cal
1327: where fact.time_id = cal.time_id
1328: and fact.item_org_id = (p_inventory_item_id||'-'||p_organization_id)
1329: and fact.organization_id = p_organization_id
1330: and fact.aggregation_level_flag = 0