Answer / gangadhar

po_distribution_id in the tables
po_distributions_all and ap_invoice_distributions is the
link btwn ap and po.

Answer / vipul maheshwari

PO_DISTRIBUTIONS_ALL
AP_INVOICE_DISTRIBUTIONS

LINK BY : PO_DISTRIBUTION_ID

Answer / nithya

when u place a po to the supplier he will return the items u
needed along with an invoice. Now u r liable to pay the amt
specified (accounts payable) in the invoice which is covered
in ap module.

Answer / 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);

Answer / srinivas.r

Here we are having the table which is in PO module
po_distributions_all;
and table in AP module ap_invoice_distrinutions_all
in these two tables there is a common column
i.e., PO_DISTRIBUTION_ID;

while running a interface if we get 100 records as erors. how to debug it.

2 Answers   Zensar,

Can we customize a form with out template.fmb

5 Answers   Zensar,

do you know is it possible to run the interface without using oracle apps?

0 Answers  

what is the defference between credit memo and debit memo

2 Answers  

why r u transer the data base tables to flat file and what is use

2 Answers  

Where we can write a PL/SQL code in report triggers?

2 Answers   IBM,

What are the benefits of using soa architecture?

0 Answers  

what is the difference between multiorg views and multiorg tables

2 Answers   Immense Source, Intelligroup, TCS,

A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.

0 Answers   Accenture,

what are the difference between 11.5.7 and 11.5.9 in oracle apps

4 Answers  

What is count(*) from po_vendors(any table)?

0 Answers  

please explain open interface import

2 Answers