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.AHL_UA_UNIT_SCHEDULES_PVT dependencies on AHL_UTIL_UC_PKG

Line 152: --ahl_util_uc_pkg.get_uc_status_code (u.unit_config_header_id) IN ('COMPLETE', 'INCOMPLETE') and

148: mtl_system_items_kfv i,
149: csi_item_instances c
150: where
151: --priyan Bug# 5303188
152: --ahl_util_uc_pkg.get_uc_status_code (u.unit_config_header_id) IN ('COMPLETE', 'INCOMPLETE') and
153: -- fix for bug number 5528416
154: ahl_util_uc_pkg.get_uc_status_code (u.unit_config_header_id) NOT IN ('DRAFT', 'EXPIRED') and
155: --u.unit_config_status_code in ('COMPLETE', 'INCOMPLETE') and
156: u.csi_item_instance_id = c.instance_id and

Line 154: ahl_util_uc_pkg.get_uc_status_code (u.unit_config_header_id) NOT IN ('DRAFT', 'EXPIRED') and

150: where
151: --priyan Bug# 5303188
152: --ahl_util_uc_pkg.get_uc_status_code (u.unit_config_header_id) IN ('COMPLETE', 'INCOMPLETE') and
153: -- fix for bug number 5528416
154: ahl_util_uc_pkg.get_uc_status_code (u.unit_config_header_id) NOT IN ('DRAFT', 'EXPIRED') and
155: --u.unit_config_status_code in ('COMPLETE', 'INCOMPLETE') and
156: u.csi_item_instance_id = c.instance_id and
157: c.inventory_item_id = i.inventory_item_id and
158: c.last_vld_organization_id = i.organization_id and

Line 2057: --and ahl_util_uc_pkg.get_uc_status_code (p_unit_config_id) IN ('COMPLETE', 'INCOMPLETE');

2053: select 'x'
2054: from ahl_unit_config_headers
2055: where unit_config_header_id = p_unit_config_id
2056: --priyan Bug # 5303188
2057: --and ahl_util_uc_pkg.get_uc_status_code (p_unit_config_id) IN ('COMPLETE', 'INCOMPLETE');
2058: --and unit_config_status_code IN ('COMPLETE', 'INCOMPLETE');
2059: -- fix for bug #5528416 - must include quarantined units
2060: and ahl_util_uc_pkg.get_uc_status_code (p_unit_config_id) NOT IN ('DRAFT', 'EXPIRED');
2061:

Line 2060: and ahl_util_uc_pkg.get_uc_status_code (p_unit_config_id) NOT IN ('DRAFT', 'EXPIRED');

2056: --priyan Bug # 5303188
2057: --and ahl_util_uc_pkg.get_uc_status_code (p_unit_config_id) IN ('COMPLETE', 'INCOMPLETE');
2058: --and unit_config_status_code IN ('COMPLETE', 'INCOMPLETE');
2059: -- fix for bug #5528416 - must include quarantined units
2060: and ahl_util_uc_pkg.get_uc_status_code (p_unit_config_id) NOT IN ('DRAFT', 'EXPIRED');
2061:
2062: BEGIN
2063: -- Standard call to check for call compatibility
2064: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)