APPS.AP_PAY_IN_FULL_PKG dependencies on AP_INVOICES_ALL

Line 124: -- Go to base table AP_INVOICES_ALL to reduce shared memory usage

120:
121:
122:
123: -- Perf bugfix 5052493
124: -- Go to base table AP_INVOICES_ALL to reduce shared memory usage
125: SELECT a.payment_currency_code,
126: b.payment_method_code, --4552701
127: a.vendor_id,
128: a.vendor_site_id,

Line 161: FROM ap_invoices_all a, ap_payment_schedules_all b --Bug 7662240

157: P_remit_vendor_site_id,
158: p_remit_vendor_name,
159: p_remit_vendor_site_name,
160: p_relationship_id
161: FROM ap_invoices_all a, ap_payment_schedules_all b --Bug 7662240
162: WHERE a.invoice_id = l_invoice_id
163: and a.invoice_id = b.invoice_id
164: and rownum<2;
165:

Line 270: FROM ap_invoices_all

266: (p_remit_vendor_site_id = p_vendor_site_id) ) THEN
267:
268: SELECT party_id, party_site_id
269: INTO p_remit_party_id, p_remit_party_site_id
270: FROM ap_invoices_all
271: WHERE invoice_id = l_invoice_id;
272:
273: end if; --7860631
274:

Line 1097: FROM ap_invoice_distributions_all aid,ap_invoice_lines_all ail,ap_invoices_all ai

1093: WHERE aip.invoice_id = p_invoice_id;
1094:
1095: SELECT nvl(SUM(aid.amount),0)
1096: INTO l_prepay_amt
1097: FROM ap_invoice_distributions_all aid,ap_invoice_lines_all ail,ap_invoices_all ai
1098: WHERE ail.invoice_id=aid.invoice_id
1099: AND ail.invoice_id=ai.invoice_id
1100: AND ail.line_number=aid.invoice_line_number
1101: AND ai.invoice_id=p_invoice_id

Line 1111: FROM ap_invoices_all ai

1107: l_count:=0;
1108:
1109: SELECT count(ai.invoice_id)
1110: INTO l_count
1111: FROM ap_invoices_all ai
1112: WHERE ai.invoice_id=p_invoice_id
1113: GROUP BY ai.invoice_id,ai.invoice_amount
1114: ,ai.discount_amount_taken, decode(ai.net_of_retainage_flag,'Y',0,
1115: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id,ai.org_id),0))