APPS.AP_WEB_PAYMENTS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 60: ap_invoice_distributions aid1,

56: ap_invoices ai,
57: ap_lookup_codes alc2,
58: ap_invoice_lines ail1,
59: ap_invoice_lines ail2,
60: ap_invoice_distributions aid1,
61: ap_invoice_distributions aid2
62: WHERE aip.invoice_id = ail2.invoice_id
63: AND ail1.invoice_id = l_invoice_id
64: AND aip.payment_num = l_payment_num

Line 61: ap_invoice_distributions aid2

57: ap_lookup_codes alc2,
58: ap_invoice_lines ail1,
59: ap_invoice_lines ail2,
60: ap_invoice_distributions aid1,
61: ap_invoice_distributions aid2
62: WHERE aip.invoice_id = ail2.invoice_id
63: AND ail1.invoice_id = l_invoice_id
64: AND aip.payment_num = l_payment_num
65: AND aid1.invoice_id = ail1.invoice_id

Line 204: ap_invoice_distributions aid1,

200: FROM ap_invoice_payments aip,
201: ap_checks ac,
202: ap_invoice_lines ail1,
203: ap_invoice_lines ail2,
204: ap_invoice_distributions aid1,
205: ap_invoice_distributions aid2
206: WHERE aip.check_id = ac.check_id
207: AND ail1.invoice_id = l_invoice_id
208: AND ail2.invoice_id = aip.invoice_id

Line 205: ap_invoice_distributions aid2

201: ap_checks ac,
202: ap_invoice_lines ail1,
203: ap_invoice_lines ail2,
204: ap_invoice_distributions aid1,
205: ap_invoice_distributions aid2
206: WHERE aip.check_id = ac.check_id
207: AND ail1.invoice_id = l_invoice_id
208: AND ail2.invoice_id = aip.invoice_id
209: AND aid1.invoice_id = ail1.invoice_id

Line 255: ap_invoice_distributions aid1,

251: FROM ap_invoice_payments aip,
252: ap_checks ac,
253: ap_invoice_lines ail1,
254: ap_invoice_lines ail2,
255: ap_invoice_distributions aid1,
256: ap_invoice_distributions aid2
257: WHERE aip.check_id = ac.check_id
258: AND ail1.invoice_id = l_invoice_id
259: AND ail2.invoice_id = aip.invoice_id

Line 256: ap_invoice_distributions aid2

252: ap_checks ac,
253: ap_invoice_lines ail1,
254: ap_invoice_lines ail2,
255: ap_invoice_distributions aid1,
256: ap_invoice_distributions aid2
257: WHERE aip.check_id = ac.check_id
258: AND ail1.invoice_id = l_invoice_id
259: AND ail2.invoice_id = aip.invoice_id
260: AND aid1.invoice_id = ail1.invoice_id

Line 302: FROM ap_invoice_distributions aid,ap_invoices ai

298: IF (nvl(FND_PROFILE.VALUE_SPECIFIC('OIE_CARRY_ADVANCES_FORWARD',NULL,p_resp_id,p_apps_id),'Y') = 'Y' )THEN
299:
300: SELECT SUM(nvl(prepay_amount_remaining,amount))
301: INTO l_prepay_amt_invoiced
302: FROM ap_invoice_distributions aid,ap_invoices ai
303: WHERE aid.invoice_id = P_invoice_id
304: AND aid.line_type_lookup_code IN ('ITEM','TAX')
305: AND nvl(aid.reversal_flag,'N') <> 'Y'
306: AND ai.invoice_id = P_invoice_id

Line 314: FROM ap_invoice_distributions aid,ap_invoices ai

310:
311: ELSE
312: SELECT SUM(nvl(prepay_amount_remaining,amount))
313: INTO l_prepay_amt_invoiced
314: FROM ap_invoice_distributions aid,ap_invoices ai
315: WHERE aid.invoice_id = P_invoice_id
316: AND aid.line_type_lookup_code IN ('ITEM','TAX')
317: AND nvl(aid.reversal_flag,'N') <> 'Y'
318: AND ai.invoice_id = P_invoice_id

Line 388: FROM ap_invoice_distributions aid,ap_invoices ai

384:
385: BEGIN
386: SELECT SUM(NVL(prepay_amount_remaining,amount))
387: INTO l_prepay_amt_invoiced
388: FROM ap_invoice_distributions aid,ap_invoices ai
389: WHERE aid.invoice_id = P_invoice_id
390: AND aid.line_type_lookup_code IN ('ITEM','TAX')
391: AND NVL(aid.reversal_flag,'N') <> 'Y'
392: AND ai.invoice_id = P_invoice_id

Line 437: FROM ap_invoice_distributions aid,ap_invoice_lines al

433:
434: BEGIN
435: SELECT SUM(NVL(aid.prepay_amount_remaining,aid.amount))
436: INTO l_prepay_amt_available
437: FROM ap_invoice_distributions aid,ap_invoice_lines al
438: WHERE aid.invoice_id = al.invoice_id
439: AND aid.invoice_line_number= al.line_number
440: and al.line_number=line_id
441: AND aid.line_type_lookup_code IN ('ITEM','TAX')