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_CMN_RGM_PROCESSING_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 300: FROM ap_invoice_payments_all a, ap_checks_all b

296: a.org_id, b.status_lookup_code, b.check_date, b.void_date, b.future_pay_due_date,
297: a.accounting_date, a.reversal_inv_pmt_id, discount_taken,
298: -- Added the following for Bug 8294236
299: b.currency_code, b.exchange_rate, b.exchange_date, b.exchange_rate_type
300: FROM ap_invoice_payments_all a, ap_checks_all b
301: WHERE a.check_id = b.check_id
302: AND a.invoice_payment_id = cp_invoice_payment_id;
303:
304: -- code ported from BL12.1.3 by zhiwei.xin on 23-JAN-2013 begin

Line 670: lv_source_table := 'AP_INVOICE_PAYMENTS_ALL';

666: lv_repository_name := 'invoice_distribution_id';
667: ELSE --'CLAIM'
668: lv_source_trx_type := 'CLAIM_ACCOUNTING';
669: lv_called_from := 'CLAIM_ACCOUNTING' ;
670: lv_source_table := 'AP_INVOICE_PAYMENTS_ALL';
671: lv_repository_name := 'invoice_payment_id';
672: END IF;
673:
674: OPEN get_regime_cur;

Line 967: FROM ap_invoice_payments_all aipa

963: AND jsir.tax_to_be_adjusted > 0;
964:
965: CURSOR get_claim_amt_cur(pn_invoice_id IN NUMBER, pn_max_payment_id IN NUMBER) IS
966: SELECT nvl(aipa.amount, 0) claim_amt, aipa.invoice_payment_id, aipa.accounting_date
967: FROM ap_invoice_payments_all aipa
968: WHERE aipa.invoice_id = pn_invoice_id
969: AND aipa.invoice_payment_id > nvl(pn_max_payment_id, 0)
970: AND aipa.accounting_date <= pd_to_date
971: AND NOT EXISTS (SELECT 1

Line 973: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'

969: AND aipa.invoice_payment_id > nvl(pn_max_payment_id, 0)
970: AND aipa.accounting_date <= pd_to_date
971: AND NOT EXISTS (SELECT 1
972: FROM jai_rgm_trx_records jrtr
973: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
974: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
975: AND jrtr.source = 'AP_CLAIM'
976: AND jrtr.source_document_id = aipa.invoice_payment_id)
977: AND EXISTS (SELECT 1

Line 985: ap_invoice_payments_all aipa

981: aida.accounting_date, 'AP') = 'Y')
982: UNION ALL
983: SELECT abs(nvl(aila.amount, 0)) claim_amt, aipa.invoice_payment_id, aila.accounting_date
984: FROM ap_invoice_lines_all aila,
985: ap_invoice_payments_all aipa
986: WHERE aila.invoice_id = pn_invoice_id
987: AND aila.line_type_lookup_code = 'PREPAY'
988: AND aila.prepay_invoice_id = aipa.invoice_id
989: AND (aipa.invoice_payment_id > nvl(pn_max_payment_id, 0)

Line 993: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'

989: AND (aipa.invoice_payment_id > nvl(pn_max_payment_id, 0)
990: OR (aipa.invoice_payment_id < nvl(pn_max_payment_id, 0)
991: AND NOT EXISTS (SELECT 1
992: FROM jai_rgm_trx_records jrtr
993: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
994: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
995: AND jrtr.source = 'AP_CLAIM'
996: AND jrtr.source_document_id = aipa.invoice_payment_id)))
997: AND aila.accounting_date <= pd_to_date

Line 1001: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'

997: AND aila.accounting_date <= pd_to_date
998: AND nvl(aila.amount, 0) <> 0
999: AND NOT EXISTS (SELECT 1
1000: FROM jai_rgm_trx_records jrtr
1001: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
1002: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
1003: AND jrtr.source = 'AP_CLAIM'
1004: AND jrtr.source_document_id = aipa.invoice_payment_id)
1005: AND EXISTS (SELECT 1

Line 2151: FROM ap_invoice_payments_all a, ap_checks_all b

2147:
2148: CURSOR c_previous_payments_of_inv(cp_invoice_id IN NUMBER, cp_start_date IN DATE) IS
2149: SELECT a.invoice_payment_id, a.check_id, a.amount, a.payment_base_amount, a.reversal_flag,
2150: a.reversal_inv_pmt_id, a.org_id
2151: FROM ap_invoice_payments_all a, ap_checks_all b
2152: WHERE a.invoice_id = cp_invoice_id
2153: AND a.check_id = b.check_id
2154: AND a.creation_date < cp_start_date
2155: AND nvl(b.future_pay_due_date, v_today) <= v_today

Line 2196: ap_invoice_payments_all apinvp,

2192: apinvp.amount,
2193: apinvp.org_id,
2194: ainvd.accounting_date -- Xiao for POT change, reg bug#12533434
2195: FROM
2196: ap_invoice_payments_all apinvp,
2197: ap_checks_all apc ,
2198: ap_invoice_distributions_all ainvd ,
2199: jai_rgm_trx_refs jrtr /* second table is used for join just to take IL records */
2200: WHERE

Line 4751: AND jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'

4747: AND NOT EXISTS (SELECT 1
4748: FROM jai_rgm_trx_records jrtr,
4749: jai_rgm_trx_refs jrtf --Added by Qiong for bug13439861
4750: WHERE jrtr.SOURCE = 'AP_CLAIM'
4751: AND jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
4752: AND jrtr.source_document_id = pn_invoice_payment_id
4753: --Added by Qiong for bug13439861 begin
4754: -------------------------------------------
4755: AND jrtr.reference_id = jrtf.reference_id

Line 4786: AND jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'

4782: AND NOT EXISTS (SELECT 1
4783: FROM jai_rgm_trx_records jrtr,
4784: jai_rgm_trx_refs jrtf--Added by Qiong for bug13439861
4785: WHERE jrtr.SOURCE = 'AP_CLAIM'
4786: AND jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
4787: AND jrtr.source_document_id = pn_invoice_payment_id
4788: --Added by Qiong for bug13439861 begin
4789: -----------------------------------------
4790: AND jrtr.reference_id = jrtf.reference_id

Line 4821: FROM ap_invoice_payments_all aipa

4817: AND jsir.date_of_reversal BETWEEN p_from_date AND p_to_date;
4818:
4819: CURSOR get_claim_amt_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER, pn_max_payment_id IN NUMBER) IS
4820: SELECT nvl(aipa.amount, 0) claim_amt, aipa.invoice_payment_id, aipa.accounting_date
4821: FROM ap_invoice_payments_all aipa
4822: WHERE aipa.invoice_id = pn_invoice_id
4823: AND aipa.accounting_date <= p_to_date
4824: -- AND aipa.invoice_payment_id > nvl(pn_max_payment_id, 0) Commented by Chong for bug#13259755 on 27-OCT-2011
4825: AND NOT EXISTS (SELECT 1

Line 4828: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'

4824: -- AND aipa.invoice_payment_id > nvl(pn_max_payment_id, 0) Commented by Chong for bug#13259755 on 27-OCT-2011
4825: AND NOT EXISTS (SELECT 1
4826: FROM jai_rgm_trx_records jrtr,
4827: jai_rgm_trx_refs jrtf--Added by Qiong for bug13439861
4828: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
4829: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
4830: AND jrtr.source = 'AP_CLAIM'
4831: AND jrtr.source_document_id = aipa.invoice_payment_id
4832: --Added by Qiong for bug13439861 begin

Line 4848: ap_invoice_payments_all aipa

4844: aida.accounting_date, 'AP') = 'Y')
4845: UNION ALL
4846: SELECT abs(nvl(aila.amount, 0)) claim_amt, aipa.invoice_payment_id, aipa.accounting_date
4847: FROM ap_invoice_lines_all aila,
4848: ap_invoice_payments_all aipa
4849: WHERE aila.invoice_id = pn_invoice_id
4850: AND aila.line_type_lookup_code = 'PREPAY'
4851: AND aila.prepay_invoice_id = aipa.invoice_id
4852: AND aila.accounting_date <= p_to_date

Line 4859: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'

4855: AND (aipa.invoice_payment_id > nvl(pn_max_payment_id, 0)
4856: OR (aipa.invoice_payment_id < nvl(pn_max_payment_id, 0)
4857: AND NOT EXISTS (SELECT 1
4858: FROM jai_rgm_trx_records jrtr
4859: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
4860: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
4861: AND jrtr.source = 'AP_CLAIM'
4862: AND jrtr.source_document_id = aipa.invoice_payment_id)))
4863: Commented by Chong for bug#13259755 on 09-NOV-2011 End*/

Line 4867: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'

4863: Commented by Chong for bug#13259755 on 09-NOV-2011 End*/
4864: AND NOT EXISTS (SELECT 1
4865: FROM jai_rgm_trx_records jrtr,
4866: jai_rgm_trx_refs jrtf--Added by Qiong for bug13439861
4867: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
4868: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
4869: AND jrtr.source = 'AP_CLAIM'
4870: AND jrtr.source_document_id = aipa.invoice_payment_id
4871: --Added by Qiong for bug13439861 begin

Line 5275: p_source_table_name => 'AP_INVOICE_PAYMENTS_ALL',

5271: p_location_id => ln_location_id,
5272: p_service_type_code => lv_service_type_code,
5273: p_source => 'AP_CLAIM',
5274: p_source_trx_type => 'CLAIM_ACCOUNTING',
5275: p_source_table_name => 'AP_INVOICE_PAYMENTS_ALL',
5276: p_source_document_id => rec_claim_line.invoice_payment_id,
5277: p_transaction_date => ld_accounting_date,
5278: p_account_name => NULL,
5279: p_charge_account_id => NULL,