OTL_Tables_Links

HXC_TIMECARD_SUMMARY-->(timecard_id)-->HXC_TC_AP_LINKS-->(Application_period_Id)--> HXC_TIMECARD_SUMMARY-->(Approval_Item_Key)-->WF_ITEM_ATTRIBUTE_VALUES-->(item_key.)

QUERRY-

select Segment1 Project_code,name from apps.pa_projects_All where project_id in(

select distinct attribute1 from apps.HXC_TIME_ATTRIBUTES where time_attribute_id in(

(select Time_Attribute_ID from apps.HXC_TIME_ATTRIBUTE_USAGES a,

(select TIME_BUILDING_BLOCK_ID,TIME_BUILDING_BLOCK_OVN from apps.HXC_AP_DETAIL_LINKS

where APPLICATION_PERIOD_ID in(

select application_period_id from apps.HXC_APP_PERIOD_SUMMARY where APPLICATION_PERIOD_ID in

(select application_period_id from apps.HXC_TC_AP_LINKS

where timecard_id in(select timecard_id from apps.hxc_timecard_summary

where RESOURCE_ID=19596 and trunc(stop_time)='15-OCT-06'))))b

where a.TIME_BUILDING_BLOCK_ID=b.TIME_BUILDING_BLOCK_ID

and a.TIME_BUILDING_BLOCK_OVN=b.TIME_BUILDING_BLOCK_OVN)))

and PROJECT_id <>42

 

The Above Chart Shows the relation between Various important tables in Oracle Time and Labor

select * From apps.HXC_TIME_BUILDING_BLOCKS

(SCOPE=’DETAIL’, TIME_BUILDING_BLOCK_ID:OBJECT_VERSION_NUMBER)

TIME_BUILDING_BLOCK_ID:OBJECT_VERSION_NUMBER=

pa.expenditure_items_al. ORIG_TRANSACTION_REFERENCE