OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » join between 2 tables (R12)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

join between 2 tables [message #445832]

Thu, 04 March 2010 05:15

amr_gad
Messages: 11
Registered: May 2009
Location: egypt

Junior Member

please can any one help me
i want join between the 2 tables po_headers_all and po_requsition_headres_all

Report message to a moderator

Re: join between 2 tables [message #446693 is a reply to message #445832]

Wed, 10 March 2010 00:34

sokmen
Messages: 6
Registered: October 2006
Location: Turkey

Junior Member

You can not join po_headers_all and po_requsition_headres_all tables. You can join po_distributions_all and po_req_distributions_all tables. Related columns are req_header_reference_num, req_line_reference_num, req_distribution_id on po_distributions_all table. If req_header_reference_num and req_line_reference_num columns have data, you should join by po_number and po_line_number. If req_distribution_id column has data you should join by distribution_id.

Report message to a moderator

Re: join between 2 tables [message #446717 is a reply to message #445832]

Wed, 10 March 2010 01:59

amr_gad
Messages: 11
Registered: May 2009
Location: egypt

Junior Member

Thanks sokmen for your reply.
I found this tables and join all tables and all table have data
it gives me data in toad and report builder but when I put it on the apps did not give me any thing
so i try to know if we have another tables can I use it to had the requisition
I solved this problem but using function
and its give me data now

Thanks for your help once again.

Report message to a moderator

Re: join between 2 tables [message #446723 is a reply to message #446717]

Wed, 10 March 2010 02:40

sokmen
Messages: 6
Registered: October 2006
Location: Turkey

Junior Member

In EBS forms you can enter po number and po line number manually, there is no validation. If you create po by requisition, it uses req_distribution_id column for the relation. So you can use a form personalization for validating po number and po line number, and then you can join the tables either reference_num columns or req_distribution_id column. Do not forget to put outer join for purchase orders that have no requisitions.

Report message to a moderator

Previous Topic:	XBRL reporting using FSG
Next Topic:	migrate oracle EBS 12.1.1 from windows 2003 to windows 2008

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 17:35:05 CDT 2025