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.OPI_DBI_RES_OPM_PKG dependencies on DUAL

Line 49: INTO g_global_start_date FROM dual;

45: l_list(2) := 'BIS_GLOBAL_START_DATE';
46:
47: IF (bis_common_parameters.check_global_parameters(l_list)) THEN
48: SELECT Trunc(bis_common_parameters.get_global_start_date)
49: INTO g_global_start_date FROM dual;
50:
51: SELECT bis_common_parameters.get_currency_code
52: INTO g_global_currency_code FROM dual;
53:

Line 52: INTO g_global_currency_code FROM dual;

48: SELECT Trunc(bis_common_parameters.get_global_start_date)
49: INTO g_global_start_date FROM dual;
50:
51: SELECT bis_common_parameters.get_currency_code
52: INTO g_global_currency_code FROM dual;
53:
54: select sysdate into l_to_date from dual;
55:
56: -- check_missing_date

Line 54: select sysdate into l_to_date from dual;

50:
51: SELECT bis_common_parameters.get_currency_code
52: INTO g_global_currency_code FROM dual;
53:
54: select sysdate into l_to_date from dual;
55:
56: -- check_missing_date
57: /*
58: fii_time_api.check_missing_date( l_from_date, l_to_date, l_missing_day_flag,

Line 162: AND NVL(ravail.resource_instance_id,0) = 0 -- exclude individual resource instances

158: AND pol.co_code = plant.co_code
159: AND whse.whse_code = plant.resource_whse_code
160: AND ravail.plant_code = rdtl.orgn_code
161: AND ravail.resource_id = rdtl.resource_id
162: AND NVL(ravail.resource_instance_id,0) = 0 -- exclude individual resource instances
163: AND ravail.shift_date BETWEEN g_global_start_date AND SYSDATE
164: AND ravail.shift_date >= trunc(rdtl.creation_date)
165: GROUP BY
166: rdtl.orgn_code,

Line 695: AND NVL(ravail.resource_instance_id,0) = 0 -- exclude individual resource instances

691: AND pol.co_code = plant.co_code
692: AND whse.whse_code = plant.resource_whse_code
693: AND ravail.plant_code = rdtl.orgn_code
694: AND ravail.resource_id = rdtl.resource_id
695: AND NVL(ravail.resource_instance_id,0) = 0 -- exclude individual resource instances
696: AND ravail.shift_date BETWEEN l_last_collection_date AND SYSDATE
697: AND ravail.shift_date >= trunc(rdtl.creation_date)
698: GROUP BY
699: rdtl.orgn_code,