Element Link report for balances and costing

Query to check get the Element name, Costing, Balancing

select petf.ELEMENT_NAME,pcak1.concatenated_segments COSTING,pcak2.concatenated_segments BALANCING from pay_element_links_f pelf,      pay_element_types_f petf,      PAY_COST_ALLOCATION_KEYFLEX PCAK1,       PAY_COST_ALLOCATION_KEYFLEX PCAK2 where pelf.element_type_id = petf.element_type_id and pelf.COST_ALLOCATION_KEYFLEX_ID = pcak1.COST_ALLOCATION_KEYFLEX_ID and pelf.BALANCING_KEYFLEX_ID = pcak2.COST_ALLOCATION_KEYFLEX_ID and sysdate between petf.EFFECTIVE_START_DATE and petf.EFFECTIVE_END_DATE and sysdate between pelf.EFFECTIVE_START_DATE and pelf.EFFECTIVE_END_DATE

About pacesettergraam

A good and realistic person

Posted on July 8, 2014, in Oracle, oracle apps. Bookmark the permalink. 1 Comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: