Answer Posted / natthu matte
invoice_distribution_id from ap_invoice_distributions_all
and po_distribution_id from po_distributions_all,
eq:-
SELECT *
FROM ap_invoice_distributions_all
WHERE invoice_distribution_id IN (SELECT po_distribution_id
FROM
po_distributions_all);
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Tell me how to debug the report?
Are you familiar with internet architecture of oracle apps 11i?
Tell me where we find the status of order information?
How to create a purchase order without a requisition?
In sequence i want to 11 and 15th values how we will write?
what is pay run id ?
what are the different transaction clauses in AR?
Explain what are the tables of auto invoice?
What are the different components you should consider while defining a responsibility in oracle apps?
What are the different components of soa suite?
Can we create tables in apps schema?
Explain oracle apps architecture.
can we use look up type instead of a pofile option?or valueset?is it possible how?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?