APPS.AP_AUTOSELECT_PKG dependencies on AP_INVOICE_LINES_ALL

Line 3170: ' AND NOT EXISTS (select 1 from ap_invoice_lines_all ail '||

3166: ' (''NOT REQUIRED'',''WFAPPROVED'',''MANUALLY APPROVED'') '||
3167: ' ) '||
3168: */
3169: ' AND ai.wfapproval_status in (''NOT REQUIRED'',''WFAPPROVED'',''MANUALLY APPROVED'') '||
3170: ' AND NOT EXISTS (select 1 from ap_invoice_lines_all ail '||
3171: ' where ai.invoice_id = ail.invoice_id '||
3172: ' and ail.wfapproval_status in (''NEEDS WFREAPPROVAL'',''REJECTED'',''INITIATED'')) '||
3173: -- Bug 7265013 ends
3174: -- Bug 11816573. Removed the push predicates.

Line 3186: ' FROM ap_invoice_lines_all ail '||

3182: ' WHERE D2.invoice_id = ai.invoice_id '||
3183: ' AND NVL(D2.match_status_flag, ''N'') in (''N'', ''S'', ''T'')) '||
3184: /* Bug 12799362. Start. */
3185: ' AND NOT EXISTS (SELECT ''Line without distribution'' '||
3186: ' FROM ap_invoice_lines_all ail '||
3187: ' WHERE ail.invoice_id = ai.invoice_id '||
3188: ' AND ail.amount <> 0 ' ||
3189: ' AND NOT EXISTS (SELECT ''No Distributions'' '||
3190: ' FROM ap_invoice_distributions_all aid '||

Line 3987: ' AND NOT EXISTS (select 1 from ap_invoice_lines_all ail '||

3983: ' (''NOT REQUIRED'',''WFAPPROVED'',''MANUALLY APPROVED'') '||
3984: ' ) '|| */
3985: /* Bug 13901772 */
3986: ' AND ai.wfapproval_status in (''NOT REQUIRED'',''WFAPPROVED'',''MANUALLY APPROVED'') '||
3987: ' AND NOT EXISTS (select 1 from ap_invoice_lines_all ail '||
3988: ' where ai.invoice_id = ail.invoice_id '||
3989: ' and ail.wfapproval_status in (''NEEDS WFREAPPROVAL'',''REJECTED'',''INITIATED'')) '||
3990: -- Bug 7265013 ends
3991: -- Bug 11816573. Removed the push predicates.

Line 4002: ' FROM ap_invoice_lines_all ail '||

3998: ' WHERE D2.invoice_id = ai.invoice_id '||
3999: ' AND NVL(D2.match_status_flag, ''N'') in (''N'', ''S'')) '||
4000: /* Bug 12799362. Start. */
4001: ' AND NOT EXISTS (SELECT ''Line without distribution'' '||
4002: ' FROM ap_invoice_lines_all ail '||
4003: ' WHERE ail.invoice_id = ai.invoice_id '||
4004: ' AND ail.amount <> 0 ' ||
4005: ' AND NOT EXISTS (SELECT ''No Distributions'' '||
4006: ' FROM ap_invoice_distributions_all aid '||

Line 6395: FROM ap_invoice_lines_all ail,ap_invoices_all ai

6391: l_prepay_with_tax NUMBER;
6392: BEGIN
6393: SELECT ((0 - SUM(NVL(ail.amount,0)))*ai.payment_cross_rate)
6394: INTO l_prepay_with_tax
6395: FROM ap_invoice_lines_all ail,ap_invoices_all ai
6396: WHERE ail.invoice_id = p_invoice_id
6397: AND ail.invoice_id=ai.invoice_id
6398: AND ail.prepay_invoice_id is not null
6399: AND ail.line_type_lookup_code in ('TAX', 'PREPAY')