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.ISC_DBI_MSC_OBJECTS_C dependencies on FII_TIME_DAY

Line 1660: fii_time_day time

1656: ids.uom_code UOM_CODE
1657: FROM isc_dbi_tmp_plans tmp,
1658: isc_dbi_supplies_f ids,
1659: isc_dbi_plan_curr_rates curr,
1660: fii_time_day time
1661: WHERE tmp.plan_id = ids.plan_id
1662: AND bitand(tmp.plan_usage, 2) = 2
1663: AND ids.organization_id = curr.organization_id
1664: AND ids.time_new_sch_date_id = time.report_date

Line 1784: fii_time_day time

1780: GROUP BY tmp.snapshot_id, id.organization_id, id.uom_code, id.demand_id, id.time_dmd_date_id, id.sr_inventory_item_id,
1781: reason.organization_type, reason.sr_inventory_item_id, reason.sr_supplier_id, reason.sr_supplier_site_id,
1782: reason.organization_id, reason.resource_id, reason.department_id, reason.reason_type) f,
1783: isc_dbi_plan_curr_rates curr,
1784: fii_time_day time
1785: WHERE f.time_dmd_date_id = time.report_date
1786: AND f.organization_id = curr.organization_id
1787: GROUP BY f.snapshot_id, f.organization_id, f.dmd_item_id, f.uom_code, f.organization_type, f.reason_type,
1788: f.r_item_id, f.r_supplier_id, f.r_supplier_site_id, f.r_resource_id, f.r_org_id, f.r_department_id,

Line 1900: fii_time_day time

1896: GROUP BY tmp.snapshot_id, id.organization_id, id.uom_code, id.demand_id, id.time_dmd_date_id, id.sr_inventory_item_id,
1897: iex.number1, reason.organization_type, reason.sr_inventory_item_id, reason.sr_supplier_id, reason.sr_supplier_site_id,
1898: reason.organization_id, reason.resource_id, reason.department_id, reason.reason_type) f,
1899: isc_dbi_plan_curr_rates curr,
1900: fii_time_day time
1901: WHERE f.time_dmd_date_id = time.report_date
1902: AND f.organization_id = curr.organization_id
1903: GROUP BY f.snapshot_id, f.organization_id, f.dmd_item_id, f.uom_code, f.organization_type, f.reason_type,
1904: f.r_item_id, f.r_supplier_id, f.r_supplier_site_id, f.r_resource_id, f.r_org_id, f.r_department_id,

Line 1998: fii_time_day time1

1994: 0 UNION2_FLAG
1995: FROM isc_dbi_tmp_plans tmp,
1996: isc_dbi_inv_detail_f iinv,
1997: isc_dbi_periods per,
1998: fii_time_day time1
1999: WHERE tmp.plan_id = iinv.plan_id
2000: AND bitand(tmp.plan_usage, 2) = 2
2001: AND iinv.organization_id = per.organization_id
2002: AND per.adjustment_period_flag = 'N'

Line 2070: fii_time_day time

2066: sum(nvl(available_hours,0)/(per.end_date-per.start_date+1)) AVAILABLE_HOURS
2067: FROM isc_dbi_tmp_plans tmp,
2068: isc_dbi_res_summary_f ires,
2069: isc_dbi_periods per,
2070: fii_time_day time
2071: WHERE tmp.plan_id = ires.plan_id
2072: AND bitand(tmp.plan_usage, 2) = 2
2073: AND ires.organization_id = per.organization_id
2074: AND per.adjustment_period_flag = 'N'