[Home] [Help]
1767: IS
1768: SELECT apsi.invoice_id invoice_id,
1769: apsi.payment_num payment_num,
1770: apin.invoice_currency_code invoice_curr_code
1771: FROM ap_selected_invoices apsi,
1772: ap_selected_invoice_checks apsic,
1773: unique_ref2 invoice_id,
1774: docs.calling_app_doc_uniq
1775: ap_invoices apin
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,
2184: jl_zz_ap_awt_types jlty
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
3296: -- AND apsi.pay_selected_check_id = P_Selected_Check_Id
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
3324: -- AND apsi.pay_selected_check_id = P_Selected_Check_Id
4769: apsi.payment_num payment_num,
4770: apsi.payment_amount payment_amount,
4771: nvl(apsi.invoice_exchange_rate, 1) invoice_exchange_rate,
4772: nvl(apsi.payment_cross_rate, 1) payment_cross_rate
4773: FROM ap_selected_invoices apsi
4774: WHERE apsi.pay_selected_check_id = P_Selected_Check_id
4775: AND nvl(apsi.ok_to_pay_flag, 'Y') = 'Y'
4776: AND apsi.original_invoice_id IS NULL
4777: FOR UPDATE;
4782: docs.document_amount payment_amount ,
4783: nvl(apsi.invoice_exchange_rate, 1) invoice_exchange_rate,
4784: nvl(apsi.payment_cross_rate, 1) payment_cross_rate
4785: FROM iby_hook_docs_in_pmt_t docs,
4786: ap_selected_invoices apsi
4787: WHERE docs.payment_id = P_Selected_Check_id
4788: AND docs.calling_app_id = 200
4789: AND apsi.invoice_id = docs.calling_app_doc_unique_ref2
4790: AND nvl(docs.dont_pay_flag,'N')='N';
4848: -----------------------------------------------------------------------------
4849: SELECT count(*)
4850: INTO l_count_inv
4851: FROM iby_hook_docs_in_pmt_t docs,
4852: -- RG ap_selected_invoices apsi,
4853: ap_awt_temp_distributions awtd
4854: WHERE docs.payment_id = P_Selected_Check_Id
4855: AND nvl(docs.dont_pay_flag,'N') ='N'
4856: AND docs.calling_app_doc_unique_ref2 = awtd.invoice_id
4871: return;
4872: END IF;
4873:
4874: -- Bug2175168. Store the the Proposed Payment Amount so that this can be utilized to correct
4875: -- the check amount. Since the standard AP build only updates the AP_SELECTED_INVOICES while
4876: -- updating the check amount we need to consider this rather than the existing check amount.
4877: -- This would however be redundant when we Rebuild the batch.
4878:
4879: SELECT SUM(docs.document_amount)
4878:
4879: SELECT SUM(docs.document_amount)
4880: INTO l_prop_payment_amount
4881: FROM iby_hook_docs_in_pmt_t docs
4882: -- ap_selected_invoices apsi
4883: WHERE docs.payment_id = P_Selected_Check_Id
4884: AND nvl(docs.dont_pay_flag,'N') ='N'
4885: AND docs.calling_app_id =200;
4886:
4975: -- using the local variable instead.
4976: -------------------------------------------------------
4977:
4978: -- RG Update Documents in PMT table
4979: -- As discussed with Ryan , we will keep updating ap selected invoices
4980:
4981: UPDATE ap_selected_invoices apsi
4982: SET apsi.proposed_payment_amount = ap_utilities_pkg.ap_round_currency(
4983: apsi.proposed_payment_amount - l_withholding_amount,
4977:
4978: -- RG Update Documents in PMT table
4979: -- As discussed with Ryan , we will keep updating ap selected invoices
4980:
4981: UPDATE ap_selected_invoices apsi
4982: SET apsi.proposed_payment_amount = ap_utilities_pkg.ap_round_currency(
4983: apsi.proposed_payment_amount - l_withholding_amount,
4984: l_payment_currency_code),
4985: apsi.payment_amount = ap_utilities_pkg.ap_round_currency(
5276: nvl(apsi.payment_cross_rate, 1) *
5277: nvl(apsi.invoice_exchange_rate, 1)), 0)
5278: INTO l_payment_amount
5279: FROM iby_hook_docs_in_pmt_t docs,
5280: ap_selected_invoices apsi
5281: WHERE docs.payment_id = P_Selected_Check_id
5282: AND apsi.invoice_id = docs.calling_app_doc_unique_ref2
5283: AND docs.dont_pay_flag = 'N'
5284: -- AND apsi.pay_selected_check_id = P_Selected_Check_id
5297: asi.vendor_site_code
5298: INTO l_vendor_name,
5299: l_vendor_site_code
5300: FROM IBY_HOOK_DOCS_IN_PMT_T docs,
5301: ap_selected_invoices_all asi
5302: WHERE docs.payment_id = P_Selected_Check_id
5303: AND docs.calling_app_doc_unique_ref2 = asi.invoice_id
5304: AND docs.calling_app_id=200;
5305: */
5478: -- apsi.ok_to_pay_flag ok_to_pay_flag,
5479: -- apsi.dont_pay_reason_code dont_pay_reason_code,
5480: -- apsi.dont_pay_description dont_pay_description
5481: FROM iby_hook_docs_in_pmt_t docs
5482: -- ap_selected_invoices apsi
5483: WHERE docs.payment_id = P_Selected_Check_id
5484: AND docs.dont_pay_flag = 'N'
5485: AND docs.calling_app_id = 200
5486: -- apsi.pay_selected_check_id = P_Selected_Check_id
5519: SET docs.dont_pay_flag = 'Y',
5520: docs.dont_pay_reason_code = AWT_ERROR
5521: WHERE CURRENT OF c_selected_invoices;
5522:
5523: UPDATE ap_selected_invoices
5524: SET ok_to_pay_flag = 'N',
5525: dont_pay_reason_code = AWT_ERROR
5526: WHERE invoice_id = l_invoice_id;
5527: