[Home] [Help]
1250: SELECT apin.invoice_id invoice_id,
1251: apin.invoice_currency_code invoice_currency_code,
1252: apip.payment_num payment_num
1253: FROM ap_invoice_payments apip,
1254: ap_invoices apin
1255: WHERE apin.invoice_id = apip.invoice_id
1256: AND apip.check_id = P_Check_Id;
1257:
1258:
1844: FROM ap_selected_invoices apsi,
1845: ap_selected_invoice_checks apsic,
1846: unique_ref2 invoice_id,
1847: docs.calling_app_doc_uniq
1848: ap_invoices apin
1849: WHERE apsic.checkrun_name = P_Checkrun_Name
1850: AND apsi.checkrun_name = P_Checkrun_Name
1851: AND (apsic.status_lookup_code = 'NEGOTIABLE'
1852: OR apsic.status_lookup_code = 'ISSUED')
2152: apip.payment_num payment_num,
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,
2199: to_number(docs.calling_app_doc_unique_ref3) payment_num,
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,
2258: to_number(docs.calling_app_doc_unique_ref3) payment_num,
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
3431: -- nvl(apip.invoice_base_amount,apip.amount) payment_amount,
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
3453: -- apsi.payment_amount*nvl(apsi.invoice_exchange_rate,1) payment_amount,
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
3487: -- docs.document_amount* nvl(apsi.invoice_exchange_rate,1) payment_amount,
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
4851: apin.payment_currency_code
4852: INTO l_inv_exchange_rate,
4853: l_payment_cross_rate,
4854: l_payment_currency_code -- Bug 2886571
4855: FROM ap_invoices apin,
4856: ap_payment_schedules apps
4857: WHERE apin.invoice_id = l_invoice_id
4858: AND apps.invoice_id = l_invoice_id
4859: AND apps.payment_num = l_payment_num;
4886: ------------------------------------------
4887: -- Updates the amount paid of the invoice
4888: -- amount_paid does not affect MRC
4889: ------------------------------------------
4890: UPDATE ap_invoices
4891: SET amount_paid = ap_utilities_pkg.ap_round_currency(
4892: nvl(amount_paid, 0) +
4893: (l_withhold_amount *
4894: nvl(l_payment_cross_rate, 1)),l_payment_currency_code),
4891: SET amount_paid = ap_utilities_pkg.ap_round_currency(
4892: nvl(amount_paid, 0) +
4893: (l_withhold_amount *
4894: nvl(l_payment_cross_rate, 1)),l_payment_currency_code),
4895: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)
4896: WHERE invoice_id = l_invoice_id;
4897:
4898: --------------------------------------------------------------
4899: -- Updates the payment amount
5169: ------------------------------------
5170: /* RG
5171: SELECT payment_currency_code
5172: INTO l_payment_currency_code
5173: FROM ap_invoices_all
5174: WHERE invoice_id = rec_sel_inv.invoice_id;
5175: */
5176:
5177: SELECT document_currency_code
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
6018: AND aid.invoice_id = P_Invoice_Id
6019: AND aid.awt_invoice_payment_id = aip.invoice_payment_id
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
6032: AND aid.invoice_id = P_Invoice_Id
6033: AND aid.awt_invoice_payment_id = aip.invoice_payment_id
6110: SELECT apin.exchange_rate,
6111: apps.payment_cross_rate
6112: INTO l_inv_exchange_rate,
6113: l_payment_cross_rate
6114: FROM ap_invoices apin,
6115: ap_payment_schedules apps
6116: WHERE apin.invoice_id = l_invoice_id
6117: AND apps.invoice_id = l_invoice_id
6118: AND apps.payment_num = l_payment_num;
6143: ------------------------------------------
6144: -- Updates the amount paid of the invoice
6145: -- amount_paid does not affect MRC
6146: ------------------------------------------
6147: UPDATE ap_invoices
6148: SET amount_paid = nvl(amount_paid, 0) -
6149: (l_withhold_amount *
6150: nvl(l_payment_cross_rate, 1)),
6151: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)
6147: UPDATE ap_invoices
6148: SET amount_paid = nvl(amount_paid, 0) -
6149: (l_withhold_amount *
6150: nvl(l_payment_cross_rate, 1)),
6151: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)
6152: WHERE invoice_id = l_invoice_id;
6153:
6154: --------------------------------------------------------------
6155: -- Updates the payment amount