APPS.JAI_AR_VALIDATE_DATA_PKG dependencies on JAI_AR_TRXS

Line 576: JAI_AR_TRXS jrcta ,

572: rcta.previous_customer_trx_id,
573: rcta.set_of_books_id ,
574: rctta.type
575: FROM ra_customer_trx_all rcta ,
576: JAI_AR_TRXS jrcta ,
577: ra_cust_trx_types_all rctta /* added by aiyer to check that only INV and CM type of transactions are picked up */
578: WHERE rcta.customer_trx_id = jrcta.customer_trx_id
579: AND rcta.cust_trx_type_id = rctta.cust_trx_type_id
580: AND nvl(rctta.type,'###') IN ('INV','CM')

Line 789: JAI_AR_TRXS jtrx

785: IS
786: SELECT jtrx.customer_trx_id ,
787: NVL(SUM(jrctl.tax_amount),0) tax_amount
788: FROM JAI_AR_TRX_LINES jrctl,
789: JAI_AR_TRXS jtrx
790: WHERE jrctl.customer_trx_id = cp_customer_trx_id
791: AND jrctl.customer_trx_id = jtrx.customer_trx_id
792: GROUP BY jtrx.customer_trx_id
793: HAVING ROUND(NVL(SUM(jrctl.tax_amount),0)) <> ( SELECT ROUND(NVL(tax_amount,0))

Line 794: FROM JAI_AR_TRXS a

790: WHERE jrctl.customer_trx_id = cp_customer_trx_id
791: AND jrctl.customer_trx_id = jtrx.customer_trx_id
792: GROUP BY jtrx.customer_trx_id
793: HAVING ROUND(NVL(SUM(jrctl.tax_amount),0)) <> ( SELECT ROUND(NVL(tax_amount,0))
794: FROM JAI_AR_TRXS a
795: WHERE a.customer_trx_id = jtrx.customer_trx_id);
796:
797: lv_utl_location VARCHAR2(512);
798: ln_file_hdl UTL_FILE.FILE_TYPE;

Line 2319: UPDATE JAI_AR_TRXS

2315: END IF;
2316:
2317: ln_error_cnt := 1;
2318:
2319: UPDATE JAI_AR_TRXS
2320: SET tax_amount = rec_sync_il_hdr_tax.tax_amount ,
2321: total_amount = line_amount + rec_sync_il_hdr_tax.tax_amount,
2322: last_update_date = sysdate,
2323: last_updated_by = gn_bug_no

Line 2327: 'UPDATE JAI_AR_TRXS

2323: last_updated_by = gn_bug_no
2324: WHERE CUSTOMER_TRX_ID = rec_sync_il_hdr_tax.customer_trx_id;
2325:
2326: lv_sql_statement := fnd_global.local_chr(10)||
2327: 'UPDATE JAI_AR_TRXS
2328: SET tax_amount = '||rec_sync_il_hdr_tax.tax_amount||' ,
2329: total_amount = line_amount + '||rec_sync_il_hdr_tax.tax_amount||',
2330: last_update_date = sysdate,
2331: last_updated_by = '||gn_bug_no||'