eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on IBY_HOOK_DOCS_IN_PMT_T

Line 904: FROM IBY_Hook_Docs_in_PMT_T ihd

900: P_Payment_Num IN Number,
901: P_Checkrun_Name IN Varchar2)
902: IS
903: SELECT Ihd.Payment_id selected_check_id
904: FROM IBY_Hook_Docs_in_PMT_T ihd
905: WHERE ihd.calling_app_doc_unique_ref2 = P_Invoice_Id
906: AND ihd.calling_app_doc_unique_ref3 = P_Payment_Num
907: AND ihd.calling_App_doc_unique_ref1 = P_Checkrun_ID
908: AND ihd.calling_app_id = 200 ;

Line 2123: iby_hook_docs_in_pmt_t docs,

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
2127: WHERE docs.payment_id = P_Check_Id

Line 2181: iby_hook_docs_in_pmt_t docs,

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
2185: WHERE docs.payment_id = P_Selected_Check_Id

Line 3293: iby_hook_docs_in_pmt_t docs

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
3297: and docs.payment_id = P_Check_Id

Line 3321: iby_hook_docs_in_pmt_t docs

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
3325: and docs.payment_id = P_Selected_Check_Id

Line 4785: FROM iby_hook_docs_in_pmt_t docs,

4781: docs.CALLING_APP_DOC_UNIQUE_REF3 payment_num,
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

Line 4851: FROM iby_hook_docs_in_pmt_t docs,

4847: -- Bug Number: 1480825 -- Just update the invoices in the same payment check.
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'

Line 4881: FROM iby_hook_docs_in_pmt_t docs

4877: -- This would however be redundant when we Rebuild the batch.
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;

Line 4938: FROM IBY_HOOK_DOCS_IN_PMT_T

4934: */
4935:
4936: SELECT document_currency_code
4937: INTO l_payment_currency_code
4938: FROM IBY_HOOK_DOCS_IN_PMT_T
4939: WHERE payment_id = P_Selected_Check_Id
4940: AND document_payable_id = rec_sel_inv.document_payable_id;
4941: -----------------------------------------------------
4942: -- Calculates the withholding amount for the invoice

Line 4997: UPDATE iby_hook_docs_in_pmt_t docs

4993: WHERE invoice_id = rec_sel_inv.invoice_id ;
4994: -- WHERE CURRENT OF c_selected_invoices;
4995:
4996:
4997: UPDATE iby_hook_docs_in_pmt_t docs
4998: SET docs.document_amount = ap_utilities_pkg.ap_round_currency(
4999: docs.document_amount - l_withholding_amount,
5000: l_payment_currency_code),
5001: docs.amount_withheld = ap_utilities_pkg.ap_round_currency(

Line 5279: FROM iby_hook_docs_in_pmt_t docs,

5275: SELECT nvl(sum(docs.document_amount/
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'

Line 5300: FROM IBY_HOOK_DOCS_IN_PMT_T docs,

5296: SELECT asi.vendor_name,
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;

Line 5481: FROM iby_hook_docs_in_pmt_t docs

5477: docs.calling_app_doc_unique_ref2 invoice_id
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

Line 5518: UPDATE iby_hook_docs_in_pmt_t docs

5514: l_dont_pay_reason_code,
5515: l_invoice_id;
5516:
5517: EXIT WHEN c_selected_invoices%NOTFOUND;
5518: UPDATE iby_hook_docs_in_pmt_t docs
5519: SET docs.dont_pay_flag = 'Y',
5520: docs.dont_pay_reason_code = AWT_ERROR
5521: WHERE CURRENT OF c_selected_invoices;
5522: