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 AP_INVOICES

Line 1198: ap_invoices apin

1194: SELECT apin.invoice_id invoice_id,
1195: apin.invoice_currency_code invoice_currency_code,
1196: apip.payment_num payment_num
1197: FROM ap_invoice_payments apip,
1198: ap_invoices apin
1199: WHERE apin.invoice_id = apip.invoice_id
1200: AND apip.check_id = P_Check_Id;
1201:
1202:

Line 1775: ap_invoices apin

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
1776: WHERE apsic.checkrun_name = P_Checkrun_Name
1777: AND apsi.checkrun_name = P_Checkrun_Name
1778: AND (apsic.status_lookup_code = 'NEGOTIABLE'
1779: OR apsic.status_lookup_code = 'ISSUED')

Line 2077: ap_invoices apin,

2073: apip.payment_num payment_num,
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,

Line 2121: ap_invoices apin,

2117: to_number(docs.calling_app_doc_unique_ref3) payment_num,
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,

Line 2178: ap_invoices apin,

2174: to_number(docs.calling_app_doc_unique_ref3) payment_num,
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,

Line 3268: FROM ap_invoices apin,

3264: nvl(apid.base_amount, apid.amount) amount,
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

Line 3290: FROM ap_invoices apin,

3286: -- apsi.payment_amount*nvl(apsi.invoice_exchange_rate,1) payment_amount,
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

Line 3318: FROM ap_invoices apin,

3314: nvl(apid.base_amount, apid.amount) amount,
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

Line 4618: FROM ap_invoices apin,

4614: apin.payment_currency_code
4615: INTO l_inv_exchange_rate,
4616: l_payment_cross_rate,
4617: l_payment_currency_code -- Bug 2886571
4618: FROM ap_invoices apin,
4619: ap_payment_schedules apps
4620: WHERE apin.invoice_id = l_invoice_id
4621: AND apps.invoice_id = l_invoice_id
4622: AND apps.payment_num = l_payment_num;

Line 4653: UPDATE ap_invoices

4649: ------------------------------------------
4650: -- Updates the amount paid of the invoice
4651: -- amount_paid does not affect MRC
4652: ------------------------------------------
4653: UPDATE ap_invoices
4654: SET amount_paid = ap_utilities_pkg.ap_round_currency(
4655: nvl(amount_paid, 0) +
4656: (l_withhold_amount *
4657: nvl(l_payment_cross_rate, 1)),l_payment_currency_code),

Line 4658: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)

4654: SET amount_paid = ap_utilities_pkg.ap_round_currency(
4655: nvl(amount_paid, 0) +
4656: (l_withhold_amount *
4657: nvl(l_payment_cross_rate, 1)),l_payment_currency_code),
4658: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)
4659: WHERE invoice_id = l_invoice_id;
4660:
4661: --------------------------------------------------------------
4662: -- Updates the payment amount

Line 4932: FROM ap_invoices_all

4928: ------------------------------------
4929: /* RG
4930: SELECT payment_currency_code
4931: INTO l_payment_currency_code
4932: FROM ap_invoices_all
4933: WHERE invoice_id = rec_sel_inv.invoice_id;
4934: */
4935:
4936: SELECT document_currency_code

Line 5685: ap_invoices ai

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
5688: AND aid.invoice_id = P_Invoice_Id
5689: AND aid.awt_invoice_payment_id = aip.invoice_payment_id

Line 5699: ap_invoices ai

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
5702: AND aid.invoice_id = P_Invoice_Id
5703: AND aid.awt_invoice_payment_id = aip.invoice_payment_id

Line 5783: FROM ap_invoices apin,

5779: SELECT apin.exchange_rate,
5780: apps.payment_cross_rate
5781: INTO l_inv_exchange_rate,
5782: l_payment_cross_rate
5783: FROM ap_invoices apin,
5784: ap_payment_schedules apps
5785: WHERE apin.invoice_id = l_invoice_id
5786: AND apps.invoice_id = l_invoice_id
5787: AND apps.payment_num = l_payment_num;

Line 5816: UPDATE ap_invoices

5812: ------------------------------------------
5813: -- Updates the amount paid of the invoice
5814: -- amount_paid does not affect MRC
5815: ------------------------------------------
5816: UPDATE ap_invoices
5817: SET amount_paid = nvl(amount_paid, 0) -
5818: (l_withhold_amount *
5819: nvl(l_payment_cross_rate, 1)),
5820: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)

Line 5820: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)

5816: UPDATE ap_invoices
5817: SET amount_paid = nvl(amount_paid, 0) -
5818: (l_withhold_amount *
5819: nvl(l_payment_cross_rate, 1)),
5820: payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status(l_invoice_id)
5821: WHERE invoice_id = l_invoice_id;
5822:
5823: --------------------------------------------------------------
5824: -- Updates the payment amount