Home » Applications » Oracle Fusion Apps & E-Business Suite » Hours Type in OTL
Hours Type in OTL [message #641608] Wed, 19 August 2015 01:57 Go to next message
nitishkumar
Messages: 1
Registered: August 2015
Location: bangalore
Junior Member
Hi,

I am not able to find where the Hours Type in OTL, value is getting stored in backend. Please let me know the table name and the joining condition with the HXC_TIME_BUILDING_BLOCKS table.

Thanks
Re: Hours Type in OTL [message #656074 is a reply to message #641608] Wed, 21 September 2016 15:03 Go to previous message
Priya999
Messages: 2
Registered: September 2016
Junior Member
Use attribute1 (alias_Definition_id)from hxc_resource_pref_v, to derive the preferences set for a resource for herirarchy_name as 'TIMEKEEPER TIMECARD LAYOUT'


select attribute1
from hxc_resource_pref_v
where resource_id = p_resource_id
and UPPER (hierarchy_name) = 'TIMEKEEPER TIMECARD LAYOUT'

----
select * from hxc.hxc_alias_values
where alias_definition_id = p_definition_id (Attribute1 from above query)

Thanks.
Previous Topic: RW-50010: Error has occured
Next Topic: Send log file as email attachment
Goto Forum:
  


Current Time: Mon Dec 23 01:09:32 CST 2024