[Home] [Help]
739: -----------------------------------------------
740: -- Reverse Exemption_Amount (Global Attribute5)
741: -----------------------------------------------
742:
743: UPDATE ap_invoice_distributions
744: SET Global_Attribute5 = 0
745: WHERE invoice_id = l_invoice_id
746: and nvl(to_number(Global_Attribute5),0) > 0;
747:
2074: jlty.taxable_base_amount_basis tax_base_amount_basis
2075: FROM
2076: jl_zz_ap_inv_dis_wh jlwh,
2077: ap_invoices apin,
2078: ap_invoice_distributions apid,
2079: ap_invoice_payments apip,
2080: jl_zz_ap_supp_awt_types jlst,
2081: jl_zz_ap_sup_awt_cd jlsc,
2082: jl_zz_ap_awt_types jlty
2118: jlty.taxable_base_amount_basis tax_base_amount_basis
2119: FROM
2120: jl_zz_ap_inv_dis_wh jlwh,
2121: ap_invoices apin,
2122: ap_invoice_distributions apid,
2123: iby_hook_docs_in_pmt_t docs,
2124: jl_zz_ap_supp_awt_types jlst,
2125: jl_zz_ap_sup_awt_cd jlsc,
2126: jl_zz_ap_awt_types jlty
2175: jlty.taxable_base_amount_basis tax_base_amount_basis
2176: FROM
2177: jl_zz_ap_inv_dis_wh jlwh,
2178: ap_invoices apin,
2179: ap_invoice_distributions apid,
2180: -- ap_selected_invoices apsi,
2181: iby_hook_docs_in_pmt_t docs,
2182: jl_zz_ap_supp_awt_types jlst,
2183: jl_zz_ap_sup_awt_cd jlsc,
3265: nvl(apid.global_attribute4, 0) tax_inclusive_amount,
3266: nvl(apip.invoice_base_amount,apip.amount) payment_amount,
3267: apip.invoice_payment_id invo_payment_id
3268: FROM ap_invoices apin,
3269: ap_invoice_distributions apid,
3270: ap_invoice_payments apip
3271: WHERE apin.invoice_id = apid.invoice_id
3272: AND apin.invoice_id = apip.invoice_id
3273: AND apip.check_id = P_Check_Id
3287: -- ,apsi.payment_num payment_num
3288: docs.document_amount* nvl(apsi.invoice_exchange_rate,1) payment_amount,
3289: docs.calling_app_doc_unique_ref3 payment_num
3290: FROM ap_invoices apin,
3291: ap_invoice_distributions apid,
3292: ap_selected_invoices apsi,
3293: iby_hook_docs_in_pmt_t docs
3294: WHERE apin.invoice_id = apid.invoice_id
3295: AND apin.invoice_id = apsi.invoice_id
3315: nvl(apid.global_attribute4, 0) tax_inclusive_amount,
3316: docs.document_amount* nvl(apsi.invoice_exchange_rate,1) payment_amount,
3317: docs.calling_app_doc_unique_ref3 payment_num
3318: FROM ap_invoices apin,
3319: ap_invoice_distributions apid,
3320: ap_selected_invoices apsi,
3321: iby_hook_docs_in_pmt_t docs
3322: WHERE apin.invoice_id = apid.invoice_id
3323: AND apin.invoice_id = apsi.invoice_id
4591: -- Obtains withheld amount for the invoice
4592: -------------------------------------------
4593: SELECT nvl(sum(apid.amount), 0)
4594: INTO l_withhold_amount
4595: FROM ap_invoice_distributions apid
4596: WHERE apid.invoice_id = l_invoice_id
4597: AND apid.awt_invoice_payment_id = l_invoice_payment_id
4598: -- added recently
4599: AND NVL(apid.REVERSAL_FLAG,'N') <> 'Y';
5138: -- Checks for real distribution lines
5139: --------------------------------------
5140: SELECT nvl(sum(apid.amount), 0)
5141: INTO l_withheld_amount
5142: FROM ap_invoice_distributions apid
5143: WHERE apid.invoice_id = P_Invoice_Id
5144: AND apid.line_type_lookup_code = 'AWT'
5145: AND apid.withholding_tax_code_id = P_Tax_Id
5146: -- added recently
5679: CURSOR c_withheld_amount(P_Old_Check_Id Number,
5680: P_Invoice_Id Number)
5681: IS
5682: SELECT sum(aid.amount)
5683: FROM ap_invoice_distributions aid,
5684: ap_invoice_payments aip,
5685: ap_invoices ai
5686: WHERE aid.invoice_id = aip.invoice_id
5687: AND ai.invoice_id = aid.invoice_id
5693: -- added recently
5694: AND NVL(aid.REVERSAL_FLAG,'N') <> 'Y'
5695: UNION
5696: SELECT sum(aid.amount)
5697: FROM ap_invoice_distributions aid,
5698: ap_invoice_payments aip,
5699: ap_invoices ai
5700: WHERE aid.invoice_id = aip.invoice_id
5701: AND ai.invoice_id = aid.invoice_id