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_AR_VALIDATE_DATA_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 32: p_error_table(1).error_description := 'Difference in tax records in ra_customer_trx_lines_all and ja_in_ra_customer_trx_lines_all';

28: FOR i in 1..13 LOOP
29: p_error_table(i).type_of_error := 'Common';
30: END LOOP;
31:
32: p_error_table(1).error_description := 'Difference in tax records in ra_customer_trx_lines_all and ja_in_ra_customer_trx_lines_all';
33: p_error_table(1).enable := 'Y';
34:
35: p_error_table(2).error_description := 'Difference in tax records in ra_cust_trx_line_gl_dist_all and JAI_AR_TRX_TAX_LINES';
36: p_error_table(2).enable := 'Y';

Line 59: p_error_table(11).error_description := 'Tax/Freight in GL Dist <> tax/freight in ra_customer_trx_lines_all';

55:
56: p_error_table(10).error_description := 'Status = OP and gl_date_closed <> 31-DEC-4712';
57: p_error_table(10).enable := 'Y';
58:
59: p_error_table(11).error_description := 'Tax/Freight in GL Dist <> tax/freight in ra_customer_trx_lines_all';
60: p_error_table(11).enable := 'Y';
61:
62: p_error_table(12).error_description := 'Sum of taxes for a line <> Tax amount of the line';
63: p_error_table(12).enable := 'Y';

Line 453: FROM ra_customer_trx_lines_all rctl,

449: IS
450: CURSOR cur_chk_non_il_taxes(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
451: IS
452: SELECT 1
453: FROM ra_customer_trx_lines_all rctl,
454: ar_vat_tax_all avtl
455: WHERE rctl.vat_tax_id = avtl.vat_tax_id
456: AND rctl.org_id = avtl.org_id
457: AND rctl.customer_trx_id = cp_customer_trx_id

Line 479: ra_customer_trx_lines_all rctla,

475: CURSOR cur_chk_revrec_run_cm(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
476: IS
477: SELECT count(*)
478: FROM ra_customer_trx_all rcta,
479: ra_customer_trx_lines_all rctla,
480: ra_cust_trx_types_all rctta
481: WHERE rcta.customer_trx_id = rctla.customer_trx_id
482: AND rcta.cust_trx_type_id = rctta.cust_trx_type_id
483: AND rctta.type = 'CM'

Line 661: ra_customer_trx_lines_all rctl

657: jrcttl.customer_trx_line_id,
658: jrcttl.tax_amount
659: FROM JAI_AR_TRX_TAX_LINES jrcttl,
660: JAI_AR_TRX_LINES jrctl,
661: ra_customer_trx_lines_all rctl
662: WHERE jrcttl.link_to_cust_trx_line_id = jrctl.customer_trx_line_id
663: AND jrcttl.customer_Trx_line_id = rctl.customer_trx_line_id
664: AND nvl(jrcttl.tax_amount,0) <> nvl(rctl.extended_amount,0)
665: AND rctl.customer_trx_id = jrctl.customer_trx_id

Line 696: ra_customer_trx_lines_all rctl

692: SELECT
693: gl_dist.customer_trx_line_id ,
694: gl_dist.amount amount
695: FROM ra_cust_trx_line_gl_dist_all gl_dist,
696: ra_customer_trx_lines_all rctl
697: WHERE gl_dist.customer_trx_id = rctl.customer_trx_id
698: AND gl_dist.customer_trx_line_id = rctl.customer_trx_line_id
699: AND gl_dist.account_class IN ('TAX','FREIGHT')
700: AND rctl.line_type IN ('TAX','FREIGHT')

Line 1044: --To check if the data in ja_in_ra_cust_trx_tax_lines is in sync with 'TAX'/'FREIGHT' records in ra_customer_trx_lines_all

1040:
1041: --Record has not been posted hence process
1042:
1043: ln_err_num := 1;
1044: --To check if the data in ja_in_ra_cust_trx_tax_lines is in sync with 'TAX'/'FREIGHT' records in ra_customer_trx_lines_all
1045: IF lt_error_table(ln_err_num).enable = 'Y' THEN
1046: IF rec_il_tax_amount.customer_trx_line_id IS NOT NULL THEN
1047: lv_process_status := jai_constants.expected_error;
1048: lv_process_message := lt_error_table(ln_err_num).error_description;

Line 1070: UPDATE ra_customer_trx_lines_all

1066: ln_error_cnt := 1;
1067:
1068: FOR i IN cur_il_tax_amount(rec_get_cust_trx.customer_trx_id)
1069: LOOP
1070: UPDATE ra_customer_trx_lines_all
1071: SET extended_amount = i.tax_amount,
1072: last_update_date = sysdate,
1073: last_updated_by = gn_bug_no
1074: WHERE customer_trx_line_id = i.customer_trx_line_id

Line 1078: 'UPDATE ra_customer_trx_lines_all'||fnd_global.local_chr(10)||

1074: WHERE customer_trx_line_id = i.customer_trx_line_id
1075: AND customer_trx_id = i.customer_trx_id;
1076:
1077: lv_sql_statement := fnd_global.local_chr(10)||
1078: 'UPDATE ra_customer_trx_lines_all'||fnd_global.local_chr(10)||
1079: 'SET extended_amount = '||i.tax_amount||','||fnd_global.local_chr(10)||
1080: ' last_update_date = sysdate,'||fnd_global.local_chr(10)||
1081: ' last_updated_by = '||gn_bug_no||fnd_global.local_chr(10)||
1082: 'WHERE customer_trx_line_id = '||i.customer_trx_line_id||fnd_global.local_chr(10)||

Line 1213: --Check that ra_customer_Trx_lines_all is in sync with gl_dist

1209: CLOSE cur_chk_gl_dist_rctl;
1210:
1211: ln_err_num := 11;
1212:
1213: --Check that ra_customer_Trx_lines_all is in sync with gl_dist
1214: IF lt_error_table(ln_err_num).enable = 'Y' THEN
1215: IF rec_chk_gl_dist_rctl.customer_trx_line_id IS NOT NULL THEN
1216: lv_process_status := jai_constants.expected_error;
1217: lv_process_message := lt_error_table(ln_err_num).error_description;

Line 1240: UPDATE ra_customer_trx_lines_all

1236: ln_error_cnt := 1;
1237:
1238: FOR rec_gl_dist_rctl in cur_chk_gl_dist_rctl (cp_customer_trx_id => rec_get_cust_trx.customer_trx_id)
1239: LOOP
1240: UPDATE ra_customer_trx_lines_all
1241: SET extended_amount = rec_gl_dist_rctl.amount,
1242: last_update_date = sysdate,
1243: last_updated_by = gn_bug_no
1244: WHERE customer_trx_id = rec_get_cust_trx.customer_trx_id

Line 1248: 'UPDATE ra_customer_trx_lines_all

1244: WHERE customer_trx_id = rec_get_cust_trx.customer_trx_id
1245: AND customer_trx_line_id = rec_gl_dist_rctl.customer_trx_line_id;
1246:
1247: lv_sql_statement := fnd_global.local_chr(10)||
1248: 'UPDATE ra_customer_trx_lines_all
1249: SET extended_amount = '||rec_gl_dist_rctl.amount||',
1250: last_update_date = sysdate,
1251: last_updated_by = '||gn_bug_no||'
1252: WHERE customer_trx_id = '||rec_get_cust_trx.customer_trx_id||'