APPS.AHL_UA_UNIT_SCHEDULES_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 147: ahl_unit_config_headers u,

143: select
144: u.unit_config_header_id uc_header_id,
145: u.name uc_name
146: from
147: ahl_unit_config_headers u,
148: mtl_system_items_kfv i,
149: csi_item_instances c
150: where
151: --priyan Bug# 5303188

Line 166: from ahl_unit_config_headers_v

162: order by uc_name desc;
163: -- Added sorting on DESC since OAF VO.insertRow inserts a row before the current row, effectively reversing the sort sequence in the UI
164: /*
165: select uc_header_id, uc_name
166: from ahl_unit_config_headers_v
167: where upper(uc_name) like nvl(upper(p_unit_schedules_search.unit_name), '%')
168: and upper(item_number) like nvl(upper(p_unit_schedules_search.item_number), '%')
169: and upper(serial_number) like nvl(upper(p_unit_schedules_search.serial_number), '%')
170: and uc_status_code IN ('COMPLETE', 'INCOMPLETE')

Line 790: AHL_UNIT_CONFIG_HEADERS U,

786: U.NAME,
787: I.CONCATENATED_SEGMENTS ITEM_NUMBER,
788: C.SERIAL_NUMBER
789: FROM
790: AHL_UNIT_CONFIG_HEADERS U,
791: CSI_ITEM_INSTANCES C,
792: MTL_SYSTEM_ITEMS_KFV I
793: WHERE
794: U.CSI_ITEM_INSTANCE_ID = C.INSTANCE_ID

Line 2054: from ahl_unit_config_headers

2050: p_unit_config_id number
2051: )
2052: is
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');