[Home] [Help]
503: BEGIN
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
528: BEGIN
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
555: BEGIN
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
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,
689: (SELECT distinct person_id
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
773: FROM PER_ALL_PEOPLE_F) papf
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
902: FROM PER_ALL_PEOPLE_F) papf
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
1050: FROM PER_ALL_PEOPLE_F) papf
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
1212: FROM PER_ALL_PEOPLE_F) papf
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
1326: FROM PER_ALL_PEOPLE_F) papf
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
1457: FROM PER_ALL_PEOPLE_F) papf
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
1601: FROM PER_ALL_PEOPLE_F) papf
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
1751: FROM PER_ALL_PEOPLE_F) papf
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
1856: FROM PER_ALL_PEOPLE_F) papf