[Home] [Help]
751: -----------------------------------------------
752: -- Reverse Exemption_Amount (Global Attribute5)
753: -----------------------------------------------
754:
755: UPDATE ap_invoice_distributions
756: SET Global_Attribute5 = 0
757: WHERE invoice_id = l_invoice_id
758: and nvl(to_number(Global_Attribute5),0) > 0;
759:
2153: jlty.taxable_base_amount_basis tax_base_amount_basis
2154: FROM
2155: jl_zz_ap_inv_dis_wh jlwh,
2156: ap_invoices apin,
2157: ap_invoice_distributions apid,
2158: ap_invoice_payments apip,
2159: jl_zz_ap_supp_awt_types jlst,
2160: jl_zz_ap_sup_awt_cd jlsc,
2161: jl_zz_ap_awt_types jlty
2200: jlty.taxable_base_amount_basis tax_base_amount_basis
2201: FROM
2202: jl_zz_ap_inv_dis_wh jlwh,
2203: ap_invoices apin,
2204: ap_invoice_distributions apid,
2205: iby_hook_docs_in_pmt_t docs,
2206: jl_zz_ap_supp_awt_types jlst,
2207: jl_zz_ap_sup_awt_cd jlsc,
2208: jl_zz_ap_awt_types jlty
2259: jlty.taxable_base_amount_basis tax_base_amount_basis
2260: FROM
2261: jl_zz_ap_inv_dis_wh jlwh,
2262: ap_invoices apin,
2263: ap_invoice_distributions apid,
2264: -- Payment Exchange Rate ER 8648739 Start 3
2265: ap_selected_invoices apsi,
2266: -- Payment Exchange Rate ER 8648739 End 3
2267: iby_hook_docs_in_pmt_t docs,
3432: (apip.amount * nvl(apip.exchange_rate,1)) payment_amount,
3433: -- Payment Exchange Rate ER 8648739 End 6
3434: apip.invoice_payment_id invo_payment_id
3435: FROM ap_invoices apin,
3436: ap_invoice_distributions apid,
3437: ap_invoice_payments apip
3438: WHERE apin.invoice_id = apid.invoice_id
3439: AND apin.invoice_id = apip.invoice_id
3440: AND apip.check_id = P_Check_Id
3454: -- ,apsi.payment_num payment_num
3455: docs.document_amount* nvl(apsi.invoice_exchange_rate,1) payment_amount,
3456: docs.calling_app_doc_unique_ref3 payment_num
3457: FROM ap_invoices apin,
3458: ap_invoice_distributions apid,
3459: ap_selected_invoices apsi,
3460: iby_hook_docs_in_pmt_t docs
3461: WHERE apin.invoice_id = apid.invoice_id
3462: AND apin.invoice_id = apsi.invoice_id
3488: (docs.document_amount * nvl(apsi.payment_exchange_rate,1)) payment_amount,
3489: -- Payment Exchange Rate ER 8648739 End 8
3490: docs.calling_app_doc_unique_ref3 payment_num
3491: FROM ap_invoices apin,
3492: ap_invoice_distributions apid,
3493: ap_selected_invoices apsi,
3494: iby_hook_docs_in_pmt_t docs
3495: WHERE apin.invoice_id = apid.invoice_id
3496: AND apin.invoice_id = apsi.invoice_id
4828: -- Obtains withheld amount for the invoice
4829: -------------------------------------------
4830: SELECT nvl(sum(apid.amount), 0)
4831: INTO l_withhold_amount
4832: FROM ap_invoice_distributions apid
4833: WHERE apid.invoice_id = l_invoice_id
4834: AND apid.awt_invoice_payment_id = l_invoice_payment_id
4835: -- added recently
4836: AND NVL(apid.REVERSAL_FLAG,'N') <> 'Y';
5399: -- Checks for real distribution lines
5400: --------------------------------------
5401: SELECT nvl(sum(apid.amount), 0)
5402: INTO l_withheld_amount
5403: FROM ap_invoice_distributions apid
5404: WHERE apid.invoice_id = P_Invoice_Id
5405: AND apid.line_type_lookup_code = 'AWT'
5406: AND apid.withholding_tax_code_id = P_Tax_Id
5407: -- added recently
6009: CURSOR c_withheld_amount(P_Old_Check_Id Number,
6010: P_Invoice_Id Number)
6011: IS
6012: SELECT sum(aid.amount)
6013: FROM ap_invoice_distributions aid,
6014: ap_invoice_payments aip,
6015: ap_invoices ai
6016: WHERE aid.invoice_id = aip.invoice_id
6017: AND ai.invoice_id = aid.invoice_id
6023: -- added recently
6024: --bug 12335657 AND NVL(aid.REVERSAL_FLAG,'N') <> 'Y'
6025: UNION
6026: SELECT sum(aid.amount)
6027: FROM ap_invoice_distributions aid,
6028: ap_invoice_payments aip,
6029: ap_invoices ai
6030: WHERE aid.invoice_id = aip.invoice_id
6031: AND ai.invoice_id = aid.invoice_id