Wednesday, 3 May 2017

Workflow tables in oracle apps

select * from wf_item_types where name = 'BWFINSER'

select * from wf_item_types_tl where name = 'BWFINSER'

select * from wf_items where item_type = 'BWFINSER'

select * from wf_item_attributes  where item_type = 'BWFINSER'

select * from wf_item_attributes_tl where item_type = 'BWFINSER'

select * from wf_activities where item_type = 'BWFINSER'

select * from wf_activities_tl

select * from wf_activity_attributes

select * from wf_activity_attributes_tl

select * from wf_activity_attr_values

select * from wf_messages

select * from wf_notifications where message_type = 'BWFINSER'

select * from wf_notification_Attributes

select * from wf_messages_tl

select * from wf_message_Attributes

select * from wf_message_Attributes_tl

select * from wf_process_Activities

select * from wf_lookup_types_tl

select * from wf_lookups_tl 

No comments:

Post a Comment

Interview Question in Oracle OTBI Report

What is Subject Area In OTBI, a Subject Area is a logical view of business data. Under a Subject Area, we have multiple folders , which are...