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.JAI_AP_ST_REVERSE_PROCESS dependencies on AP_INVOICES_ALL

Line 2072: FROM ap_invoices_all aia_in

2068: --Added by Chong for reverse charge service tax ER bug#14385555 2012/08/06 Start
2069: ---------------------------------------------------------------------------------
2070: AND NOT EXISTS(
2071: SELECT 1
2072: FROM ap_invoices_all aia_in
2073: WHERE jcdt.source_table_name = 'JAI_AP_INVOICE_LINES'
2074: AND jcdt.source_doc_id = aia_in.invoice_id
2075: AND aia_in.invoice_type_lookup_code in ('CREDIT' ,'DEBIT')
2076: )

Line 2138: FROM ap_invoices_all aia_in

2134: --Added by Chong for reverse charge service tax ER bug#14385555 2012/08/06 Start
2135: ---------------------------------------------------------------------------------
2136: AND NOT EXISTS(
2137: SELECT 1
2138: FROM ap_invoices_all aia_in
2139: WHERE jcdt.source_table_name = 'JAI_AP_INVOICE_LINES'
2140: AND jcdt.source_doc_id = aia_in.invoice_id
2141: AND aia_in.invoice_type_lookup_code in ('CREDIT' ,'DEBIT')
2142: )

Line 3085: FROM ap_invoices_all

3081: IS
3082: CURSOR get_ven_info(v_invoice_id NUMBER) IS
3083: SELECT vendor_id, vendor_site_id, org_id, cancelled_date, invoice_num, set_of_books_id, -- added for bug#3354932
3084: legal_entity_id /* rallamse bug#4448789 */
3085: FROM ap_invoices_all
3086: WHERE invoice_id = v_invoice_id;
3087:
3088: Cursor get_discard_info (ln_invoice_id number) is /*Added by nprashar for bug # 12832424*/
3089: Select nvl(discarded_flag,'N') from ap_invoice_lines_all

Line 3142: FROM ap_invoices_all api,

3138: api.created_by,
3139: api.last_update_date,
3140: api.last_updated_by,
3141: api.invoice_date
3142: FROM ap_invoices_all api,
3143: ap_invoice_distributions_all apd,
3144: po_distributions_all pod,
3145: po_headers_all poh
3146: WHERE apd.invoice_id = api.invoice_id

Line 3357: FROM ap_invoices_all

3353: WHERE tax_id = t_id;
3354:
3355: CURSOR c_inv(inv_id NUMBER) IS
3356: SELECT batch_id,source
3357: FROM ap_invoices_all
3358: WHERE invoice_id = inv_id;
3359:
3360: CURSOR for_org_id(inv_id NUMBER) IS
3361: SELECT org_id, vendor_id, NVL(exchange_rate, 1) exchange_rate, invoice_currency_code

Line 3362: FROM ap_invoices_all

3358: WHERE invoice_id = inv_id;
3359:
3360: CURSOR for_org_id(inv_id NUMBER) IS
3361: SELECT org_id, vendor_id, NVL(exchange_rate, 1) exchange_rate, invoice_currency_code
3362: FROM ap_invoices_all
3363: WHERE invoice_id = inv_id;
3364:
3365: CURSOR for_acct_id(orgn_id NUMBER) IS
3366: SELECT accts_pay_code_combination_id

Line 3561: from ap_invoices_all

3557: /*Bug 8866084 - Added cursor to fetch Source of Invoice*/
3558: cursor c_get_ap_invoice_src (p_inv_id NUMBER)
3559: is
3560: select source
3561: from ap_invoices_all
3562: where invoice_id = p_inv_id;
3563:
3564: ln_source VARCHAR2(50);
3565:

Line 3602: apccid ap_invoices_all.ACCTS_PAY_CODE_COMBINATION_ID%TYPE;

3598: v_functional_currency gl_sets_of_books.currency_code%type; -- bug#3354932
3599: v_batch_id NUMBER;
3600: c_tax_rec c_tax%ROWTYPE;
3601: v_source VARCHAR2(25);
3602: apccid ap_invoices_all.ACCTS_PAY_CODE_COMBINATION_ID%TYPE;
3603: cur_items_rec cur_items%ROWTYPE;
3604: from_po_distributions_rec from_po_distributions%ROWTYPE;
3605: for_dist_insertion_rec for_dist_insertion%ROWTYPE;
3606: cum_tax_amt NUMBER := -1;--modified by kunkumar for 5593895

Line 3731: FROM ap_invoices_all aia

3727: -- Added by Jason Liu for retroactive price on 2008/01/09
3728: -----------------------------------------------------------
3729: CURSOR get_source_csr IS
3730: SELECT aia.source
3731: FROM ap_invoices_all aia
3732: WHERE aia.invoice_id = inv_id;
3733: lv_source ap_invoices_all.source%TYPE;
3734: -----------------------------------------------------------
3735: rec_max_ap_lines_all CUR_GET_MAX_AP_INV_LINE%ROWTYPE;

Line 3733: lv_source ap_invoices_all.source%TYPE;

3729: CURSOR get_source_csr IS
3730: SELECT aia.source
3731: FROM ap_invoices_all aia
3732: WHERE aia.invoice_id = inv_id;
3733: lv_source ap_invoices_all.source%TYPE;
3734: -----------------------------------------------------------
3735: rec_max_ap_lines_all CUR_GET_MAX_AP_INV_LINE%ROWTYPE;
3736:
3737: ln_max_lnno NUMBER;

Line 4027: FROM ap_invoices_all

4023: /* ends here addition by ssumaith */
4024:
4025: SELECT accts_pay_code_combination_id
4026: INTO apccid
4027: FROM ap_invoices_all
4028: WHERE invoice_id = inv_id;
4029:
4030: -- Using pn_invoice_line_number instead of dist_line_no for Bug#4445989
4031: OPEN for_dist_insertion(inv_id,pn_invoice_line_number, ln_min_dist_line_num);

Line 5379: FROM ap_invoices_all

5375: SELECT vendor_id, vendor_site_id, org_id, cancelled_date -- cancelled date added by bug#3206083
5376: ,set_of_books_id -- added for bug#3354932
5377: ,legal_entity_id -- added rallamse for bug#
5378: ,invoice_num -- added by pramasub FP
5379: FROM ap_invoices_all
5380: WHERE invoice_id = v_invoice_id;
5381:
5382: CURSOR c_functional_currency(p_sob NUMBER) IS -- cursor added for bug#3354932
5383: SELECT currency_code

Line 5412: FROM ap_invoices_all api,

5408: api.created_by,
5409: api.last_update_date,
5410: api.last_updated_by,
5411: api.invoice_date
5412: FROM ap_invoices_all api,
5413: ap_invoice_distributions_all apd,
5414: po_distributions_all pod,
5415: po_headers_all poh
5416: WHERE api.invoice_id = inv_id

Line 5479: FROM ap_invoices_all

5475: WHERE tax_id = t_id;
5476:
5477: CURSOR c_inv(inv_id NUMBER) IS
5478: SELECT batch_id,source
5479: FROM ap_invoices_all
5480: WHERE invoice_id = inv_id;
5481:
5482: CURSOR for_org_id(inv_id NUMBER) IS
5483: SELECT org_id, vendor_id, NVL(exchange_rate, 1) exchange_rate, invoice_currency_code

Line 5484: FROM ap_invoices_all

5480: WHERE invoice_id = inv_id;
5481:
5482: CURSOR for_org_id(inv_id NUMBER) IS
5483: SELECT org_id, vendor_id, NVL(exchange_rate, 1) exchange_rate, invoice_currency_code
5484: FROM ap_invoices_all
5485: WHERE invoice_id = inv_id;
5486:
5487: /*CURSOR for_acct_id(orgn_id NUMBER) IS
5488: SELECT accts_pay_code_combination_id

Line 7046: UPDATE ap_invoices_all

7042: 'update_payment_schedule(cum_tax_amt): amount add' || cum_tax_amt);
7043:
7044: v_update_payment_schedule:=update_payment_schedule(cum_tax_amt);
7045:
7046: UPDATE ap_invoices_all
7047: SET invoice_amount = invoice_amount + cum_tax_amt,
7048: approved_amount = approved_amount + cum_tax_amt,
7049: pay_curr_invoice_amount = pay_curr_invoice_amount + cum_tax_amt,
7050: amount_applicable_to_discount = amount_applicable_to_discount + cum_tax_amt,

Line 7056: update ap_invoices_all

7052: WHERE invoice_id = inv_id;
7053:
7054: if for_org_id_rec.invoice_currency_code <> v_functional_currency then
7055: -- invoice currency is not the functional currency.
7056: update ap_invoices_all
7057: set base_amount = invoice_amount * exchange_rate
7058: where invoice_id = inv_id;
7059: end if;
7060: end if; -- v_dist_reversal_cnt = 0