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_RCTLA_TRIGGER_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 113: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

109: v_trans_type Varchar2(30);
110:
111: /*Cursor transaction_type_cur IS
112: Select a.type
113: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
114: Where a.cust_trx_type_id = b.cust_trx_type_id
115: And b.customer_trx_id = v_customer_trx_id
116: And NVL(a.org_id,0) = NVL(pr_old.org_id,0);
117: */

Line 128: FROM RA_CUSTOMER_TRX_ALL

124: Where cust_trx_type_id
125: in
126: (
127: SELECT cust_trx_type_id
128: FROM RA_CUSTOMER_TRX_ALL
129: WHERE CUSTOMER_TRX_ID = v_customer_trx_id
130: AND org_id = pr_old.ORG_ID /* Modified by Ramananda for removal of SQL LITERALs */
131: --AND org_id = NVL(pr_old.ORG_ID,0)
132: )

Line 323: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

319:
320:
321: Cursor transaction_type_cur IS
322: Select a.type
323: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
324: Where a.cust_trx_type_id = b.cust_trx_type_id
325: And b.customer_trx_id = v_header_id
326: And NVL(a.org_id,0) = NVL(pr_new.org_id,0);
327:

Line 357: FROM RA_CUSTOMER_TRX_ALL

353:
354:
355: Cursor header_info_cur IS
356: SELECT created_from, set_of_books_id, invoice_currency_code, exchange_rate_type, nvl(exchange_date,trx_date), exchange_rate
357: FROM RA_CUSTOMER_TRX_ALL
358: WHERE customer_trx_id = v_header_id;
359:
360: Cursor localization_header_info_cur IS
361: SELECT organization_id

Line 388: Manual Credit memo with reference to invoice has ra_customer_trx_all.created_from as ARXTWCMI

384: The reason this was happening is because this trigger has code to copy the
385: taxes from the invoice against which the credit memo is applied.
386:
387: Added code to return control when a manual credit memo without reference is created.
388: Manual Credit memo with reference to invoice has ra_customer_trx_all.created_from as ARXTWCMI
389: Manual Credit memo without reference to invoice has ra_customer_trx_all.created_from as ARXTWMAI
390: 3. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
391: DB Entity as required for CASE COMPLAINCE. Version 116.1
392:

Line 389: Manual Credit memo without reference to invoice has ra_customer_trx_all.created_from as ARXTWMAI

385: taxes from the invoice against which the credit memo is applied.
386:
387: Added code to return control when a manual credit memo without reference is created.
388: Manual Credit memo with reference to invoice has ra_customer_trx_all.created_from as ARXTWCMI
389: Manual Credit memo without reference to invoice has ra_customer_trx_all.created_from as ARXTWMAI
390: 3. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
391: DB Entity as required for CASE COMPLAINCE. Version 116.1
392:
393: 4. 10-Jun-2005 File Version: 116.2

Line 714: FROM RA_CUSTOMER_TRX_ALL

710: SELECT bill_to_customer_id,
711: bill_to_site_use_id,
712: trx_number,
713: batch_source_id
714: FROM RA_CUSTOMER_TRX_ALL
715: WHERE customer_trx_id = pr_new.customer_trx_id;
716: CURSOR GET_SITE(P_TRX_NUMBER VARCHAR2) IS
717: SELECT customer_site
718: FROM JAI_AR_SUP_HDRS_ALL

Line 723: FROM ra_customer_trx_all

719: WHERE supplementary_num = TO_NUMBER(p_trx_number);
720: -------------- cursor for st forms tracking -------------
721: CURSOR GET_EXCHANGE_RATE IS
722: SELECT exchange_rate
723: FROM ra_customer_trx_all
724: WHERE customer_trx_id = pr_new.customer_trx_id;
725: CURSOR CREATED_FROM_CUR IS
726: SELECT created_from, trx_number, batch_source_id, set_of_books_id, primary_salesrep_id,
727: invoice_currency_code, exchange_rate_type, exchange_date, exchange_rate

Line 728: FROM ra_customer_trx_all

724: WHERE customer_trx_id = pr_new.customer_trx_id;
725: CURSOR CREATED_FROM_CUR IS
726: SELECT created_from, trx_number, batch_source_id, set_of_books_id, primary_salesrep_id,
727: invoice_currency_code, exchange_rate_type, exchange_date, exchange_rate
728: FROM ra_customer_trx_all
729: WHERE customer_trx_id = v_header_id;
730:
731: CURSOR SO_PICKING_HDR_INFO IS
732: SELECT A.organization_id, A.location_id

Line 784: RA_CUSTOMER_TRX_ALL C

780: SELECT A.organization_id,
781: A.Location_id
782: FROM JAI_AR_TRXS A,
783: JAI_AR_SUP_HDRS_ALL B,
784: RA_CUSTOMER_TRX_ALL C
785: WHERE pr_new.customer_trx_id = c.customer_trx_id
786: AND c.trx_number = TO_CHAR(B.SUPPLEMENTARY_NUM)
787: AND B.customer_trx_id = A.customer_trx_id;
788:

Line 811: ra_customer_trx_all b,

807: (NVL(A.excise_diff_amt,0)+NVL(A.other_diff_amt,0)) TAX_AMT,
808: NVL(A.excise_diff_amt,0) excise_diff,
809: A.new_assessable_value
810: FROM JAI_AR_SUP_LINES A,
811: ra_customer_trx_all b,
812: ra_cust_trx_types_all c
813: WHERE B.CUST_TRX_TYPE_ID = C.CUST_TRX_TYPE_ID
814: AND A.SUP_INV_TYPE = DECODE(C.TYPE,'DM','DB','CM','CR','INV','SI')
815: AND A.customer_trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3)

Line 824: ra_customer_trx_all c,

820: NVL(A.excise_diff_amt,0) excise_diff,
821: A.new_assessable_value
822: FROM JAI_AR_SUP_LINES A,
823: JAI_AR_SUP_HDRS_ALL b,
824: ra_customer_trx_all c,
825: ra_cust_trx_types_all e
826: WHERE pr_new.customer_trx_id = c.customer_trx_id
827: AND c.trx_number = TO_CHAR( b.SUPPLEMENTARY_NUM)
828: AND B.customer_trx_id = A.customer_trx_id

Line 841: ra_customer_trx_all c,

837: CURSOR SUPPLEMENT_LINES_INFO_Tax_catg IS
838: SELECT A.tax_category_id
839: FROM JAI_AR_SUP_LINES A,
840: JAI_AR_SUP_HDRS_ALL b,
841: ra_customer_trx_all c,
842: ra_cust_trx_types_all D
843: WHERE pr_new.customer_trx_id = c.customer_trx_id
844: AND c.trx_number =TO_CHAR( b.SUPPLEMENTARY_NUM)
845: AND B.customer_trx_id = A.customer_trx_id

Line 908: ra_customer_trx_all C,

904: t.tax_type,
905: t.stform_type
906: FROM JAI_AR_SUP_TAXES A,
907: JAI_AR_SUP_LINES b,
908: ra_customer_trx_all C,
909: ra_cust_trx_types_all D,
910: JAI_CMN_TAXES_ALL t
911: WHERE A.link_to_cust_trx_line_id = b.customer_trx_line_id
912: AND A.sup_inv_type = b.sup_inv_type

Line 933: ra_customer_trx_all D,

929: t.stform_type
930: FROM JAI_AR_SUP_TAXES A,
931: JAI_AR_SUP_LINES b,
932: JAI_AR_SUP_HDRS_ALL c,
933: ra_customer_trx_all D,
934: ra_cust_trx_types_all e,
935: JAI_CMN_TAXES_ALL t
936: WHERE pr_new.customer_trx_id = D.customer_trx_id
937: AND D.trx_number = TO_CHAR(c.SUPPLEMENTARY_NUM)

Line 982: RA_CUSTOMER_TRX_ALL C,

978: CURSOR SUPPLEMENT_LINES_CHECK_CNSLDT IS
979: SELECT 1
980: FROM JAI_AR_SUP_LINES A,
981: JAI_AR_SUP_HDRS_ALL B,
982: RA_CUSTOMER_TRX_ALL C,
983: RA_CUST_TRX_TYPES_ALL D
984: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id
985: AND c.cust_trx_type_id = D.cust_trx_type_id
986: AND c.trx_number = TO_CHAR(b.SUPPLEMENTARY_NUM)

Line 1009: RA_CUSTOMER_TRX_ALL C,

1005: CURSOR SUPPLEMENT_TAX_LINES_CHECK_CNS IS
1006: SELECT 1
1007: FROM JAI_AR_SUP_LINES A,
1008: JAI_AR_SUP_HDRS_ALL B,
1009: RA_CUSTOMER_TRX_ALL C,
1010: RA_CUST_TRX_TYPES_ALL D,
1011: JAI_AR_SUP_TAXES E
1012: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id
1013: AND c.cust_trx_type_id = D.cust_trx_type_id

Line 1023: FROM ra_customer_trx_all

1019: AND A.sup_inv_type = e.sup_inv_type;
1020:
1021: CURSOR complete_flag_cur IS
1022: SELECT complete_flag
1023: FROM ra_customer_trx_all
1024: WHERE customer_trx_id = v_header_id;
1025: v_trans_type VARCHAR2(30);
1026:
1027: CURSOR transaction_type_cur IS

Line 1029: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

1025: v_trans_type VARCHAR2(30);
1026:
1027: CURSOR transaction_type_cur IS
1028: SELECT A.TYPE
1029: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
1030: WHERE A.cust_trx_type_id = b.cust_trx_type_id
1031: AND b.customer_trx_id = v_header_id
1032: AND NVL(A.org_id,0) = NVL(pr_new.org_id,0);
1033: /* Code Added For Service Module */

Line 1253: FROM ra_customer_trx_all

1249: v_part_i_register_id NUMBER ;
1250:
1251: CURSOR site_cur IS
1252: SELECT SHIP_TO_CUSTOMER_ID,SHIP_TO_SITE_USE_ID
1253: FROM ra_customer_trx_all
1254: WHERE customer_trx_id = pr_new.customer_trx_id
1255: AND org_id = pr_new.org_id;
1256:
1257:

Line 1331: FROM RA_CUSTOMER_TRX_ALL

1327: FUNCTION get_legal_entity_id RETURN NUMBER IS
1328:
1329: CURSOR cur_legal_entity_id IS
1330: SELECT legal_entity_id
1331: FROM RA_CUSTOMER_TRX_ALL
1332: WHERE customer_trx_id = pr_new.customer_trx_id ;
1333:
1334: ln_legal_entity_id NUMBER ;
1335:

Line 1799: from ra_customer_trx_all

1795: exchange_rate ,
1796: created_from ,
1797: nvl(bill_to_customer_id,ship_to_customer_id) customer_id , -- Date 26-feb-2006 added by sacsethi for bug 5631784
1798: trx_date
1799: from ra_customer_trx_all
1800: where customer_trx_id = pr_new.customer_trx_id;
1801:
1802: CURSOR JA_SO_LINES_INFO IS
1803: SELECT tax_category_id ,

Line 4230: FROM ra_customer_trx_all

4226: CURSOR CREATED_FROM_CUR IS
4227: SELECT created_from, trx_number, batch_source_id, set_of_books_id, primary_salesrep_id,
4228: invoice_currency_code, exchange_rate_type, exchange_date, exchange_rate,
4229: legal_entity_id /* rallamse bug#4448789 */
4230: FROM ra_customer_trx_all
4231: WHERE customer_trx_id = v_header_id;
4232:
4233:
4234: -- following cursor definition modified by sriram - bug # 2755890 - 18/01/2003

Line 4309: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

4305:
4306: v_trans_type VARCHAR2(30);
4307: CURSOR transaction_type_cur IS
4308: SELECT A.TYPE
4309: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
4310: WHERE A.cust_trx_type_id = b.cust_trx_type_id
4311: AND b.customer_trx_id = v_header_id
4312: AND NVL(A.org_id,0) = NVL(pr_new.org_id,0);
4313:

Line 4345: ra_customer_trx_all rct,

4341: IS
4342: SELECT
4343: ott.transaction_type_id
4344: FROM
4345: ra_customer_trx_all rct,
4346: oe_transaction_types_tl ott
4347: WHERE
4348: rct.customer_trx_id = pr_new.previous_customer_trx_id
4349: /* bug 4926865. Added by Lakshmi Gopalsami

Line 4453: The legal_entity_id is derived from CREATED_FROM_CUR cursor based on ra_customer_trx_all.

4449: 12. 10-Jun-2005 rallamse bug#4448789 116.3
4450: Added legal_entity_id for table JAI_AR_TRXS in insert statement
4451:
4452: 13. 26-07-2005 rallamse bug#4510143 120.2
4453: The legal_entity_id is derived from CREATED_FROM_CUR cursor based on ra_customer_trx_all.
4454:
4455: 14. 24-Aug-2005 Ramananda for bug #4567935 (115 bug 4404898, 4395450). File version 120.2
4456: Issue:-
4457: 1. The following type of taxes should not be inserted into JAI_AR_TRX_LINES when Order type is BOND register:-

Line 4896: cursor c_gl_dist_date ( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type)

4892: ln_threshold_tax_cat_id JAI_AP_TDS_THHOLD_TAXES.tax_category_id%type;
4893: ld_gl_dist_date date;
4894: v_service_type VARCHAR2(30); -- added by csahoo for bug#5879769
4895:
4896: cursor c_gl_dist_date ( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type)
4897: is
4898: select gl_date
4899: from ra_cust_trx_line_gl_dist_all
4900: where customer_trx_id = cp_customer_trx_id

Line 4950: FROM RA_CUSTOMER_TRX_ALL A

4946: Cursor bind_cur IS
4947: SELECT A.org_id,
4948: A.ship_to_customer_id,
4949: NVL(A.ship_to_site_use_id,0)
4950: FROM RA_CUSTOMER_TRX_ALL A
4951: WHERE customer_trx_id = v_header_id;
4952:
4953:
4954: Cursor header_info_cur IS

Line 4960: FROM RA_CUSTOMER_TRX_ALL

4956: invoice_currency_code,
4957: exchange_rate_type,
4958: exchange_date,
4959: exchange_rate, trx_date
4960: FROM RA_CUSTOMER_TRX_ALL
4961: WHERE customer_trx_id = v_header_id;
4962:
4963: Cursor address_cur(p_ship_to_site_use_id IN Number) IS
4964: SELECT cust_acct_site_id address_id

Line 4999: FROM JAI_AR_TRXS A, RA_CUSTOMER_TRX_ALL B

4995: FROM JAI_AR_TRX_APPS_RELS_T ;/*altered by rchandan for bug#4479131*/
4996:
4997: CURSOR organization_cur IS
4998: SELECT A.organization_id
4999: FROM JAI_AR_TRXS A, RA_CUSTOMER_TRX_ALL B
5000: WHERE A.trx_number = B.recurred_from_trx_number AND B.customer_trx_id = v_header_id;
5001:
5002: CURSOR CREATED_FROM_CUR IS
5003: SELECT created_from , trx_date

Line 5004: FROM ra_customer_trx_all

5000: WHERE A.trx_number = B.recurred_from_trx_number AND B.customer_trx_id = v_header_id;
5001:
5002: CURSOR CREATED_FROM_CUR IS
5003: SELECT created_from , trx_date
5004: FROM ra_customer_trx_all
5005: WHERE customer_trx_id = v_header_id;
5006:
5007: ld_trx_date ra_customer_trx_all.trx_Date%type;
5008:

Line 5007: ld_trx_date ra_customer_trx_all.trx_Date%type;

5003: SELECT created_from , trx_date
5004: FROM ra_customer_trx_all
5005: WHERE customer_trx_id = v_header_id;
5006:
5007: ld_trx_date ra_customer_trx_all.trx_Date%type;
5008:
5009: CURSOR ONCE_COMPLETE_FLAG_CUR IS
5010: SELECT once_completed_flag
5011: FROM JAI_AR_TRXS

Line 5016: FROM RA_CUSTOMER_TRX_ALL

5012: WHERE customer_trx_id = v_header_id;
5013:
5014: CURSOR ROW_ID_CUR IS
5015: SELECT rowid
5016: FROM RA_CUSTOMER_TRX_ALL
5017: WHERE customer_trx_id = v_header_id;
5018:
5019: CURSOR old_line_amount_cur IS
5020: SELECT line_amount

Line 5033: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

5029:
5030:
5031: Cursor transaction_type_cur IS
5032: Select a.type
5033: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
5034: Where a.cust_trx_type_id = b.cust_trx_type_id
5035: And b.customer_trx_id = v_header_id
5036: And NVL(a.org_id,0) = NVL(pr_new.org_id,0);
5037:

Line 5592: FROM RA_CUSTOMER_TRX_ALL A

5588: /* --Ramananda for File.Sql.35 */
5589:
5590: Cursor bind_cur IS
5591: SELECT A.org_id,A.ship_to_customer_id,NVL(A.ship_to_site_use_id,0)
5592: FROM RA_CUSTOMER_TRX_ALL A
5593: WHERE customer_trx_id = v_header_id;
5594:
5595: Cursor header_info_cur IS
5596: SELECT set_of_books_id , invoice_currency_code,

Line 5599: FROM RA_CUSTOMER_TRX_ALL

5595: Cursor header_info_cur IS
5596: SELECT set_of_books_id , invoice_currency_code,
5597: exchange_rate_type, exchange_date,
5598: exchange_rate , trx_date
5599: FROM RA_CUSTOMER_TRX_ALL
5600: WHERE customer_trx_id = v_header_id;
5601:
5602: CURSOR excise_cal_cur IS
5603: select A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type

Line 5620: FROM RA_CUSTOMER_TRX_ALL

5616: SELECT organization_id
5617: FROM JAI_AR_TRXS
5618: WHERE trx_number = (
5619: SELECT recurred_from_trx_number
5620: FROM RA_CUSTOMER_TRX_ALL
5621: WHERE customer_trx_id = v_header_id
5622: );
5623:
5624: CURSOR CREATED_FROM_CUR IS

Line 5626: FROM ra_customer_trx_all

5622: );
5623:
5624: CURSOR CREATED_FROM_CUR IS
5625: SELECT created_from
5626: FROM ra_customer_trx_all
5627: WHERE customer_trx_id = v_header_id;
5628:
5629: /*CURSOR ROW_ID_CUR IS
5630: SELECT rowid FROM RA_CUSTOMER_TRX_ALL

Line 5630: SELECT rowid FROM RA_CUSTOMER_TRX_ALL

5626: FROM ra_customer_trx_all
5627: WHERE customer_trx_id = v_header_id;
5628:
5629: /*CURSOR ROW_ID_CUR IS
5630: SELECT rowid FROM RA_CUSTOMER_TRX_ALL
5631: WHERE customer_trx_id = v_header_id;*//*commented by rchandan for bug#4479131*/
5632:
5633:
5634: Cursor transaction_type_cur IS

Line 5636: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

5632:
5633:
5634: Cursor transaction_type_cur IS
5635: Select a.type
5636: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
5637: Where a.cust_trx_type_id = b.cust_trx_type_id
5638: And b.customer_trx_id = v_header_id
5639: And (a.org_id = pr_new.org_id
5640: OR

Line 5913: FROM RA_CUSTOMER_TRX_ALL A

5909:
5910: /* Bind variables customer_id , org_id to be retrieved in the db trigger */
5911: Cursor bind_cur IS
5912: SELECT A.org_id,A.ship_to_customer_id,NVL(A.ship_to_site_use_id,0)
5913: FROM RA_CUSTOMER_TRX_ALL A
5914: WHERE customer_trx_id = v_header_id;
5915:
5916: Cursor header_info_cur IS
5917: SELECT set_of_books_id, invoice_currency_code, exchange_rate_type, exchange_date,

Line 5919: FROM RA_CUSTOMER_TRX_ALL

5915:
5916: Cursor header_info_cur IS
5917: SELECT set_of_books_id, invoice_currency_code, exchange_rate_type, exchange_date,
5918: exchange_rate, trx_date
5919: FROM RA_CUSTOMER_TRX_ALL
5920: WHERE customer_trx_id = v_header_id;
5921:
5922: Cursor tax_id_cur(p_tax_category_id IN Number) IS
5923: SELECT line_no

Line 5952: FROM RA_CUSTOMER_TRX_ALL

5948: SELECT organization_id
5949: FROM JAI_AR_TRXS
5950: WHERE trx_number = (
5951: SELECT recurred_from_trx_number
5952: FROM RA_CUSTOMER_TRX_ALL
5953: WHERE customer_trx_id = v_header_id
5954: );
5955:
5956: CURSOR CREATED_FROM_CUR IS

Line 5958: FROM ra_customer_trx_all

5954: );
5955:
5956: CURSOR CREATED_FROM_CUR IS
5957: SELECT created_from , trx_date
5958: FROM ra_customer_trx_all
5959: WHERE customer_trx_id = v_header_id;
5960:
5961: /*CURSOR ROW_ID_CUR IS
5962: SELECT rowid FROM RA_CUSTOMER_TRX_ALL

Line 5962: SELECT rowid FROM RA_CUSTOMER_TRX_ALL

5958: FROM ra_customer_trx_all
5959: WHERE customer_trx_id = v_header_id;
5960:
5961: /*CURSOR ROW_ID_CUR IS
5962: SELECT rowid FROM RA_CUSTOMER_TRX_ALL
5963: WHERE customer_trx_id = v_header_id;*//*commented by rchandan for bug#4479131*/
5964:
5965: CURSOR ONCE_COMPLETE_FLAG_CUR IS
5966: SELECT once_completed_flag

Line 5973: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

5969:
5970:
5971: Cursor transaction_type_cur IS
5972: Select a.type
5973: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
5974: Where a.cust_trx_type_id = b.cust_trx_type_id
5975: And b.customer_trx_id = v_header_id
5976: And ( a.org_id = pr_new.org_id
5977: OR

Line 6348: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

6344: -- 6369471
6345: -- cursor to get transaction type
6346: CURSOR c_transaction_type IS
6347: SELECT A.TYPE
6348: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
6349: WHERE A.cust_trx_type_id = b.cust_trx_type_id
6350: AND b.customer_trx_id = r_new.customer_trx_id
6351: AND NVL(A.org_id,0) = NVL(r_new.org_id,0);
6352:

Line 6362: from ra_customer_trx_all

6358: select trx_number, trx_date, batch_source_id, set_of_books_id
6359: , primary_salesrep_id ,invoice_currency_code, exchange_rate_type
6360: , exchange_date, exchange_rate
6361: , legal_entity_id -- 6012570
6362: from ra_customer_trx_all
6363: where customer_trx_id = r_new.customer_trx_id;
6364: r_ra_customer_trx c_ra_customer_trx%rowtype;
6365:
6366: cursor c_jai_ra_customer_trx is