[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)
529: select (0 - sum(nvl(dist.base_amount,nvl(dist.amount,0))))
530: into prepaid_amount
531: from ap_invoice_distributions_all dist,
532: ap_invoice_lines_all line,
533: ap_invoices_all inv
534: where dist.invoice_id = l_invoice_id
535: and inv.legal_entity_id = nvl(l_legal_entity_id, inv.legal_entity_id)
536: -- Bug 5207771 : Org_id is removed
537: -- and inv.org_id = nvl(l_org_id, inv.org_id)
556: SELECT NVL(SUM(nvl(dist.base_amount,NVL(dist.amount,0))),0)
557: INTO l_awt_net_total
558: FROM ap_invoice_distributions_all dist,
559: ap_invoice_lines_all line,
560: ap_invoices_all inv
561: WHERE dist.invoice_id = l_invoice_id
562: and inv.legal_entity_id = nvl(l_legal_entity_id, inv.legal_entity_id)
563: -- Bug 5207771 : Org_id is removed
564: -- and inv.org_id = nvl(l_org_id, inv.org_id)
680: nvl(dist.base_amount,dist.amount),0)) withholding_tax_amount
681: FROM po_vendors v,
682: po_vendor_sites_all vs,
683: fnd_lookups fl,
684: ap_invoices_all inv,
685: ap_invoice_lines_all line,
686: ap_invoice_distributions_all dist,
687: ap_tax_codes_all atc,
688: ap_awt_tax_rates_all awt,
764: po_vendors v,
765: po_vendor_sites_all vs,
766: ap_tax_codes_all atc,
767: ap_awt_tax_rates_all awt,
768: ap_invoices_all inv,
769: ap_invoice_lines_all line,
770: ap_invoice_distributions_all dist,
771: (SELECT distinct person_id
772: ,national_identifier
893: ap_checks_all checks,
894: ap_tax_codes_all atc,
895: ap_awt_tax_rates_all awt,
896: fnd_document_sequences seq,
897: ap_invoices_all inv,
898: ap_invoice_lines_all line,
899: ap_invoice_distributions_all dist,
900: (SELECT distinct person_id
901: ,national_identifier
1041: ap_checks_all checks,
1042: ap_tax_codes_all atc,
1043: ap_awt_tax_rates_all awt,
1044: fnd_document_sequences seq,
1045: ap_invoices_all inv,
1046: ap_invoice_lines_all line,
1047: ap_invoice_distributions_all dist,
1048: (SELECT distinct person_id
1049: ,national_identifier
1203: ap_checks_all checks,
1204: ap_tax_codes_all atc,
1205: ap_awt_tax_rates_all awt,
1206: fnd_document_sequences seq,
1207: ap_invoices_all inv,
1208: ap_invoice_lines_all line,
1209: ap_invoice_distributions_all dist,
1210: (SELECT distinct person_id
1211: ,national_identifier
1317: ap_checks_all checks,
1318: ap_tax_codes_all atc,
1319: ap_awt_tax_rates_all awt,
1320: fnd_document_sequences seq,
1321: ap_invoices_all inv,
1322: ap_invoice_lines_all line,
1323: ap_invoice_distributions_all dist,
1324: (SELECT distinct person_id
1325: ,national_identifier
1448: ap_checks_all checks,
1449: ap_tax_codes_all atc,
1450: ap_awt_tax_rates_all awt,
1451: fnd_document_sequences seq,
1452: ap_invoices_all inv,
1453: ap_invoice_lines_all line,
1454: ap_invoice_distributions_all dist,
1455: (SELECT distinct person_id
1456: ,national_identifier
1592: ap_checks_all checks,
1593: ap_tax_codes_all atc,
1594: ap_awt_tax_rates_all awt,
1595: fnd_document_sequences seq,
1596: ap_invoices_all inv,
1597: ap_invoice_lines_all line,
1598: ap_invoice_distributions_all dist,
1599: (SELECT distinct person_id
1600: ,national_identifier
1742: po_vendor_sites_all vs,
1743: ap_tax_codes_all atc,
1744: ap_awt_tax_rates_all awt,
1745: fnd_document_sequences seq,
1746: ap_invoices_all inv,
1747: ap_invoice_lines_all line,
1748: ap_invoice_distributions_all dist,
1749: (SELECT distinct person_id
1750: ,national_identifier
1847: po_vendor_sites_all vs,
1848: ap_tax_codes_all atc,
1849: ap_awt_tax_rates_all awt,
1850: fnd_document_sequences seq,
1851: ap_invoices_all inv,
1852: ap_invoice_lines_all line,
1853: ap_invoice_distributions_all dist,
1854: (SELECT distinct person_id
1855: ,national_identifier
1992: end if;
1993: exception
1994: when OTHERS then
1995: select invoice_num into l_invoice_num
1996: from ap_invoices_all
1997: where invoice_id = p_fetch_invoice_id
1998: and legal_entity_id = nvl(p_legal_entity_id, legal_entity_id);
1999: -- bug 5207771: Removed org_id condition
2000: --and inv.org_id = nvl(p_org_id,inv.org_id);
2011: and nvl(awt.end_date,l_accounting_date);
2012: exception
2013: when OTHERS then
2014: select invoice_num into l_invoice_num
2015: from ap_invoices_all
2016: where invoice_id = p_fetch_invoice_id
2017: and legal_entity_id = nvl(p_legal_entity_id,legal_entity_id);
2018: -- bug 5207771: Removed org_id condition
2019: --and inv.org_id = nvl(p_org_id,inv.org_id);