[Home] [Help]
504: select (0 - sum(nvl(dist.base_amount,nvl(dist.amount,0))))
505: into amount_withheld
506: from ap_invoice_distributions_all dist,
507: ap_invoice_lines_all line,
508: ap_invoices_all inv
509: where dist.invoice_id = l_invoice_id
510: and inv.legal_entity_id = nvl(l_legal_entity_id, inv.legal_entity_id)
511: -- Bug 5207771 : Org_id is removed
512: -- and inv.org_id = nvl(l_org_id, inv.org_id)
530: select (0 - sum(nvl(dist.base_amount,nvl(dist.amount,0))))
531: into prepaid_amount
532: from ap_invoice_distributions_all dist,
533: ap_invoice_lines_all line,
534: ap_invoices_all inv
535: where dist.invoice_id = l_invoice_id
536: and inv.legal_entity_id = nvl(l_legal_entity_id, inv.legal_entity_id)
537: -- Bug 5207771 : Org_id is removed
538: -- and inv.org_id = nvl(l_org_id, inv.org_id)
559: SELECT NVL(SUM(nvl(dist.base_amount,NVL(dist.amount,0))),0)
560: INTO l_awt_net_total
561: FROM ap_invoice_distributions_all dist,
562: ap_invoice_lines_all line,
563: ap_invoices_all inv
564: WHERE dist.invoice_id = l_invoice_id
565: and inv.legal_entity_id = nvl(l_legal_entity_id, inv.legal_entity_id)
566: -- Bug 5207771 : Org_id is removed
567: -- and inv.org_id = nvl(l_org_id, inv.org_id)
690: nvl(dist.base_amount,dist.amount),0)) withholding_tax_amount
691: FROM po_vendors v,
692: po_vendor_sites_all vs,
693: fnd_lookups fl,
694: ap_invoices_all inv,
695: ap_invoice_lines_all line,
696: ap_invoice_distributions_all dist,
697: ap_tax_codes_all atc,
698: ap_awt_tax_rates_all awt,
791: po_vendors v,
792: po_vendor_sites_all vs,
793: ap_tax_codes_all atc,
794: ap_awt_tax_rates_all awt,
795: ap_invoices_all inv,
796: ap_invoice_lines_all line,
797: ap_invoice_distributions_all dist,
798: (SELECT distinct person_id
799: ,national_identifier
942: ap_checks_all checks,
943: ap_tax_codes_all atc,
944: ap_awt_tax_rates_all awt,
945: fnd_document_sequences seq,
946: ap_invoices_all inv,
947: ap_invoice_lines_all line,
948: ap_invoice_distributions_all dist,
949: (SELECT distinct person_id
950: ,national_identifier
1121: ap_checks_all checks,
1122: ap_tax_codes_all atc,
1123: ap_awt_tax_rates_all awt,
1124: fnd_document_sequences seq,
1125: ap_invoices_all inv,
1126: ap_invoice_lines_all line,
1127: ap_invoice_distributions_all dist,
1128: (SELECT distinct person_id
1129: ,national_identifier
1313: ap_checks_all checks,
1314: ap_tax_codes_all atc,
1315: ap_awt_tax_rates_all awt,
1316: fnd_document_sequences seq,
1317: ap_invoices_all inv,
1318: ap_invoice_lines_all line,
1319: ap_invoice_distributions_all dist,
1320: (SELECT distinct person_id
1321: ,national_identifier
1489: ap_checks_all checks,
1490: ap_tax_codes_all atc,
1491: ap_awt_tax_rates_all awt,
1492: fnd_document_sequences seq,
1493: ap_invoices_all inv,
1494: ap_invoice_lines_all line,
1495: ap_invoice_distributions_all dist,
1496: (SELECT distinct person_id
1497: ,national_identifier
1679: ap_checks_all checks,
1680: ap_tax_codes_all atc,
1681: ap_awt_tax_rates_all awt,
1682: fnd_document_sequences seq,
1683: ap_invoices_all inv,
1684: ap_invoice_lines_all line,
1685: ap_invoice_distributions_all dist,
1686: (SELECT distinct person_id
1687: ,national_identifier
1853: ap_checks_all checks,
1854: ap_tax_codes_all atc,
1855: ap_awt_tax_rates_all awt,
1856: fnd_document_sequences seq,
1857: ap_invoices_all inv,
1858: ap_invoice_lines_all line,
1859: ap_invoice_distributions_all dist,
1860: (SELECT distinct person_id
1861: ,national_identifier
2031: po_vendor_sites_all vs,
2032: ap_tax_codes_all atc,
2033: ap_awt_tax_rates_all awt,
2034: fnd_document_sequences seq,
2035: ap_invoices_all inv,
2036: ap_invoice_lines_all line,
2037: ap_invoice_distributions_all dist,
2038: (SELECT distinct person_id
2039: ,national_identifier
2166: po_vendor_sites_all vs,
2167: ap_tax_codes_all atc,
2168: ap_awt_tax_rates_all awt,
2169: fnd_document_sequences seq,
2170: ap_invoices_all inv,
2171: ap_invoice_lines_all line,
2172: ap_invoice_distributions_all dist,
2173: (SELECT distinct person_id
2174: ,national_identifier
2382: end if;
2383: exception
2384: when OTHERS then
2385: select invoice_num into l_invoice_num
2386: from ap_invoices_all
2387: where invoice_id = p_fetch_invoice_id
2388: and legal_entity_id = nvl(p_legal_entity_id, legal_entity_id);
2389: -- bug 5207771: Removed org_id condition
2390: --and inv.org_id = nvl(p_org_id,inv.org_id);
2405:
2406: exception
2407: when OTHERS then
2408: select invoice_num into l_invoice_num
2409: from ap_invoices_all
2410: where invoice_id = p_fetch_invoice_id
2411: and legal_entity_id = nvl(p_legal_entity_id,legal_entity_id);
2412: -- bug 5207771: Removed org_id condition
2413: --and inv.org_id = nvl(p_org_id,inv.org_id);