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_IMPORT_SYNC_PKG dependencies on JAI_AR_TRXS

Line 82: v_vat_invoice_no JAI_AR_TRXS.tax_invoice_no%type;

78:
79: v_vat_start_num JAI_CMN_INVENTORY_ORGS.current_number%Type;
80: v_vat_jump_by JAI_CMN_INVENTORY_ORGS.jump_by%type;
81: v_vat_prefix JAI_CMN_INVENTORY_ORGS.prefix%type;
82: v_vat_invoice_no JAI_AR_TRXS.tax_invoice_no%type;
83: v_vat_reg_no JAI_CMN_INVENTORY_ORGS.vat_reg_no%type;
84:
85:
86: v_organization_id Number;

Line 90: v_loc_vat_inv_no JAI_AR_TRXS.tax_invoice_no%type;

86: v_organization_id Number;
87: v_loc_id Number;
88: v_vat_taxes_exist Number;
89: v_trans_type VARCHAR2(30);
90: v_loc_vat_inv_no JAI_AR_TRXS.tax_invoice_no%type;
91:
92: CURSOR organization_cur IS
93: SELECT organization_id,location_id
94: FROM JAI_AR_TRXS

Line 94: FROM JAI_AR_TRXS

90: v_loc_vat_inv_no JAI_AR_TRXS.tax_invoice_no%type;
91:
92: CURSOR organization_cur IS
93: SELECT organization_id,location_id
94: FROM JAI_AR_TRXS
95: where customer_trx_id = pr_new.customer_trx_id;
96:
97: CURSOR C_VAT_INVOICE_CUR IS
98: SELECT TAX_INVOICE_NO

Line 99: FROM JAI_AR_TRXS

95: where customer_trx_id = pr_new.customer_trx_id;
96:
97: CURSOR C_VAT_INVOICE_CUR IS
98: SELECT TAX_INVOICE_NO
99: FROM JAI_AR_TRXS
100: WHERE Customer_Trx_Id = pr_new.customer_trx_id;
101:
102:
103: cursor c_vat_taxes_exist

Line 148: from jai_ar_trxs

144: ---------------------------------------------------------
145: cursor c_get_rec(cn_customer_trx_id number)
146: is
147: select *
148: from jai_ar_trxs
149: where customer_trx_id = cn_customer_trx_id;
150:
151: t_rec_new jai_ar_trxs%rowtype;
152: t_rec_old jai_ar_trxs%rowtype;

Line 151: t_rec_new jai_ar_trxs%rowtype;

147: select *
148: from jai_ar_trxs
149: where customer_trx_id = cn_customer_trx_id;
150:
151: t_rec_new jai_ar_trxs%rowtype;
152: t_rec_old jai_ar_trxs%rowtype;
153:
154: lv_action VARCHAR2(20) ;
155: lv_return_message VARCHAR2(2000);

Line 152: t_rec_old jai_ar_trxs%rowtype;

148: from jai_ar_trxs
149: where customer_trx_id = cn_customer_trx_id;
150:
151: t_rec_new jai_ar_trxs%rowtype;
152: t_rec_old jai_ar_trxs%rowtype;
153:
154: lv_action VARCHAR2(20) ;
155: lv_return_message VARCHAR2(2000);
156: lv_return_code VARCHAR2(100) ;

Line 201: update JAI_AR_TRXS

197:
198: ---------------------------------------------------------
199: --Added by Zhiwei for JAI Trigger elimination end
200:
201: update JAI_AR_TRXS
202: set tax_invoice_no = v_vat_invoice_no
203: where customer_trx_id = pr_new.customer_trx_id;
204:
205: --Added by Zhiwei for JAI Trigger elimination begin

Line 217: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(

213: if(t_rec_new.once_completed_flag = 'Y')then
214:
215: lv_action := jai_constants.updating ;
216:
217: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
218: pr_old => t_rec_old ,
219: pr_new => t_rec_new ,
220: pv_action => lv_action ,
221: pv_return_code => lv_return_code ,

Line 337: from jai_ar_trxs

333: ---------------------------------------------------------
334: cursor c_get_rec(cn_customer_trx_id number)
335: is
336: select *
337: from jai_ar_trxs
338: where customer_trx_id = cn_customer_trx_id;
339:
340: t_rec_new jai_ar_trxs%rowtype;
341: t_rec_old jai_ar_trxs%rowtype;

Line 340: t_rec_new jai_ar_trxs%rowtype;

336: select *
337: from jai_ar_trxs
338: where customer_trx_id = cn_customer_trx_id;
339:
340: t_rec_new jai_ar_trxs%rowtype;
341: t_rec_old jai_ar_trxs%rowtype;
342: ---------------------------------------------------------
343: --Added by Zhiwei for JAI Trigger elimination end
344: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TRX_NUMBER()';

Line 341: t_rec_old jai_ar_trxs%rowtype;

337: from jai_ar_trxs
338: where customer_trx_id = cn_customer_trx_id;
339:
340: t_rec_new jai_ar_trxs%rowtype;
341: t_rec_old jai_ar_trxs%rowtype;
342: ---------------------------------------------------------
343: --Added by Zhiwei for JAI Trigger elimination end
344: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TRX_NUMBER()';
345:

Line 371: Update JAI_AR_TRXS

367: close c_get_rec;
368: ---------------------------------------------------------
369: --Added by Zhiwei for JAI Trigger elimination end
370:
371: Update JAI_AR_TRXS
372: Set Customer_Trx_ID = pr_new.Customer_Trx_ID
373: Where Customer_Trx_ID = pr_old.Customer_Trx_ID;
374:
375: --Added by Zhiwei for JAI Trigger elimination begin

Line 385: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(

381: if(t_rec_new.once_completed_flag = 'Y')then
382:
383: lv_action := jai_constants.updating ;
384:
385: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
386: pr_old => t_rec_old ,
387: pr_new => t_rec_new ,
388: pv_action => lv_action ,
389: pv_return_code => lv_return_code ,

Line 458: Update JAI_AR_TRXS

454: close c_get_rec;
455: ---------------------------------------------------------
456: --Added by Zhiwei for JAI Trigger elimination end
457:
458: Update JAI_AR_TRXS
459: Set Trx_Number = pr_new.Trx_Number
460: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
461:
462: --Added by Zhiwei for JAI Trigger elimination begin

Line 474: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(

470: if(t_rec_new.once_completed_flag = 'Y')then
471:
472: lv_action := jai_constants.updating ;
473:
474: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
475: pr_old => t_rec_old ,
476: pr_new => t_rec_new ,
477: pv_action => lv_action ,
478: pv_return_code => lv_return_code ,

Line 511: Update JAI_AR_TRXS

507: IF NVL(v_trans_type,'N') in ('CM','DM') THEN
508:
509:
510: IF pr_new.created_from = 'RAXTRX' THEN
511: Update JAI_AR_TRXS
512: Set Trx_Number = pr_new.Trx_Number
513: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
514: ELSE
515:

Line 517: Update JAI_AR_TRXS

513: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
514: ELSE
515:
516:
517: Update JAI_AR_TRXS
518: Set Trx_Number = pr_new.Trx_Number
519: , Once_Completed_Flag = NVL(pr_new.Complete_Flag,'N')
520: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
521: END IF;

Line 524: Update JAI_AR_TRXS

520: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
521: END IF;
522:
523: ELSIF NVL(v_trans_type,'N') = 'INV' THEN
524: Update JAI_AR_TRXS
525: Set Trx_Number = pr_new.Trx_Number
526: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
527: END IF;
528:

Line 541: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(

537: if(t_rec_new.once_completed_flag = 'Y')then
538:
539: lv_action := jai_constants.updating ;
540:
541: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
542: pr_old => t_rec_old ,
543: pr_new => t_rec_new ,
544: pv_action => lv_action ,
545: pv_return_code => lv_return_code ,

Line 643: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;

639: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
640: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
641:
642: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
643: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;
644:
645:
646: CURSOR complete_cur
647: IS

Line 656: JAI_AR_TRXS

652: decode(once_completed_flag,'A','RG23A','C','RG23C','P','PLA') register_type,
653: update_rg_flag,
654: nvl(update_rg23d_flag,'N')
655: FROM
656: JAI_AR_TRXS
657: WHERE
658: customer_trx_id = v_customer_trx_id;
659:
660:

Line 682: FROM JAI_AR_TRXS

678: WHERE organization_id = p_org_id AND fin_active_flag = 'Y';
679:
680: CURSOR tax_amount_cur IS
681: SELECT NVL(tax_amount,0) tax_amount
682: FROM JAI_AR_TRXS
683: WHERE customer_trx_id = v_customer_trx_id;
684:
685: CURSOR preference_reg_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
686: SELECT pref_rg23a , pref_rg23c , pref_pla

Line 699: FROM JAI_AR_TRXS

695: ORGANIZATION_ID = P_ORG_ID;
696:
697: CURSOR organization_cur IS
698: SELECT organization_id,location_id
699: FROM JAI_AR_TRXS
700: WHERE trx_number = v_parent_trx_number;
701:
702: CURSOR register_balance_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
703: SELECT NVL(register_balance,0) register_balance

Line 845: FROM JAI_AR_TRXS jtrx,

841:
842:
843: CURSOR c_total_Excise_amt IS
844: SELECT nvl(sum(jrtl.func_tax_amount),0)
845: FROM JAI_AR_TRXS jtrx,
846: JAI_AR_TRX_LINES jtl,
847: JAI_AR_TRX_TAX_LINES jrtl,
848: JAI_CMN_TAXES_ALL jtc ,
849: JAI_INV_ITM_SETUPS jmtl

Line 885: CURSOR cur_chk_temp_lines_exist( cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE )

881: ||
882: || Check whether the JAI_AR_TRX_INS_LINES_T table still has the row corresponding to the current
883: || customer_trx_id
884: */
885: CURSOR cur_chk_temp_lines_exist( cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE )
886: IS
887: SELECT '1'
888: FROM Fnd_Concurrent_Requests FCR
889: WHERE FCR.argument1 = to_char(cp_customer_trx_id)

Line 909: FROM JAI_AR_TRXS

905: CURSOR c_vat_invoice_cur
906: IS
907: SELECT
908: vat_invoice_no
909: FROM JAI_AR_TRXS
910: WHERE customer_trx_id = pr_new.customer_trx_id;
911:
912: CURSOR cur_vat_taxes_exist
913: IS

Line 968: CURSOR cur_get_same_inv_no ( cp_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ,

964:
965:
966:
967:
968: CURSOR cur_get_same_inv_no ( cp_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ,
969: cp_location_id JAI_AR_TRXS.LOCATION_ID%TYPE
970: )
971: IS
972: SELECT

Line 969: cp_location_id JAI_AR_TRXS.LOCATION_ID%TYPE

965:
966:
967:
968: CURSOR cur_get_same_inv_no ( cp_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ,
969: cp_location_id JAI_AR_TRXS.LOCATION_ID%TYPE
970: )
971: IS
972: SELECT
973: nvl(attribute_value ,'N') attribute_value

Line 1014: lv_vat_invoice_number JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;

1010: lv_register_type VARCHAR2(5);
1011: lv_rg23a_cess_avlbl VARCHAR2(10);
1012: lv_rg23c_cess_avlbl VARCHAR2(10);
1013: lv_pla_cess_avlbl VARCHAR2(10);
1014: lv_vat_invoice_number JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
1015: lv_vat_taxes_exist VARCHAR2(1);
1016: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
1017: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
1018: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

Line 1086: from jai_ar_trxs

1082: ---------------------------------------------------------
1083: cursor c_get_rec(cn_customer_trx_id number)
1084: is
1085: select *
1086: from jai_ar_trxs
1087: where customer_trx_id = cn_customer_trx_id;
1088:
1089: t_rec_new jai_ar_trxs%rowtype;
1090: t_rec_old jai_ar_trxs%rowtype;

Line 1089: t_rec_new jai_ar_trxs%rowtype;

1085: select *
1086: from jai_ar_trxs
1087: where customer_trx_id = cn_customer_trx_id;
1088:
1089: t_rec_new jai_ar_trxs%rowtype;
1090: t_rec_old jai_ar_trxs%rowtype;
1091:
1092: ---------------------------------------------------------
1093: --Added by Zhiwei for JAI Trigger elimination end

Line 1090: t_rec_old jai_ar_trxs%rowtype;

1086: from jai_ar_trxs
1087: where customer_trx_id = cn_customer_trx_id;
1088:
1089: t_rec_new jai_ar_trxs%rowtype;
1090: t_rec_old jai_ar_trxs%rowtype;
1091:
1092: ---------------------------------------------------------
1093: --Added by Zhiwei for JAI Trigger elimination end
1094:

Line 1162: UPDATE JAI_AR_TRXS

1158: ---------------------------------------------------------
1159: --Added by Zhiwei for JAI Trigger elimination end
1160:
1161:
1162: UPDATE JAI_AR_TRXS
1163: SET ONCE_COMPLETED_FLAG = pr_new.COMPLETE_FLAG
1164: ,complete_flag = pr_new.COMPLETE_FLAG --Added by Zhiwei for Trigger Elimination for Import AR
1165: WHERE CUSTOMER_TRX_ID = V_CUSTOMER_TRX_ID;
1166:

Line 1177: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(

1173: if(t_rec_new.once_completed_flag = 'Y')then
1174:
1175: lv_action := jai_constants.updating ;
1176:
1177: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
1178: pr_old => t_rec_old ,
1179: pr_new => t_rec_new ,
1180: pv_action => lv_action ,
1181: pv_return_code => lv_return_code ,

Line 1207: UPDATE JAI_AR_TRXS

1203: close c_get_rec;
1204: ---------------------------------------------------------
1205: --Added by Zhiwei for JAI Trigger elimination end
1206:
1207: UPDATE JAI_AR_TRXS
1208: SET ONCE_COMPLETED_FLAG = pr_new.COMPLETE_FLAG
1209: ,complete_flag = pr_new.complete_flag --Added by Zhiwei for ZX integration
1210: --,TRX_DATE = pr_new.trx_date --Added by Zhiwei for ZX integration
1211: WHERE CUSTOMER_TRX_ID = V_CUSTOMER_TRX_ID;

Line 1223: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(

1219: if(t_rec_new.once_completed_flag = 'Y')then
1220:
1221: lv_action := jai_constants.updating ;
1222:
1223: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
1224: pr_old => t_rec_old ,
1225: pr_new => t_rec_new ,
1226: pv_action => lv_action ,
1227: pv_return_code => lv_return_code ,

Line 1729: FROM JAI_AR_TRXS

1725: v_reg_type VARCHAR2(10);
1726: Begin
1727: SELECT once_completed_flag
1728: INTO v_reg_type
1729: FROM JAI_AR_TRXS
1730: WHERE CUSTOMER_TRX_ID = pr_new.Customer_trx_id;
1731:
1732: IF v_reg_type = 'P' THEN
1733: v_reg_type := 'PLA';

Line 1874: FROM JAI_AR_TRXS

1870: v_reg_type1 VARCHAR2(10);
1871: Begin
1872: SELECT once_completed_flag
1873: INTO v_reg_type1
1874: FROM JAI_AR_TRXS
1875: WHERE CUSTOMER_TRX_ID = pr_new.Customer_trx_id;
1876:
1877: If v_reg_type1 = 'P' THEN
1878: v_reg_type1 := 'PLA';

Line 1989: UPDATE JAI_AR_TRXS

1985: close c_get_rec;
1986: ---------------------------------------------------------
1987: --Added by Zhiwei for JAI Trigger elimination end
1988:
1989: UPDATE JAI_AR_TRXS
1990: SET
1991: ONCE_COMPLETED_FLAG = pr_new.COMPLETE_FLAG
1992: WHERE CUSTOMER_TRX_ID = V_CUSTOMER_TRX_ID;
1993:

Line 2004: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(

2000: if(t_rec_new.once_completed_flag = 'Y')then
2001:
2002: lv_action := jai_constants.updating ;
2003:
2004: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(
2005: pr_old => t_rec_old ,
2006: pr_new => t_rec_new ,
2007: pv_action => lv_action ,
2008: pv_return_code => lv_return_code ,

Line 2053: LV_ONCE_COMPLETED_FLAG JAI_AR_TRXS.ONCE_COMPLETED_FLAG%TYPE;

2049: ( PR_OLD t_jai_rec%TYPE , PR_NEW T_REC%TYPE , PV_ACTION VARCHAR2 , PV_RETURN_CODE OUT NOCOPY VARCHAR2 , PV_RETURN_MESSAGE OUT NOCOPY VARCHAR2 )
2050: IS
2051: LV_DOCUMENT_TYPE VARCHAR2(40);
2052: LN_REG_ID NUMBER;
2053: LV_ONCE_COMPLETED_FLAG JAI_AR_TRXS.ONCE_COMPLETED_FLAG%TYPE;
2054: V_HEADER_ID NUMBER;
2055:
2056:
2057: CURSOR ONCE_COMPLETE_FLAG_CUR IS

Line 2059: FROM JAI_AR_TRXS

2055:
2056:
2057: CURSOR ONCE_COMPLETE_FLAG_CUR IS
2058: SELECT ONCE_COMPLETED_FLAG
2059: FROM JAI_AR_TRXS
2060: WHERE CUSTOMER_TRX_ID = V_HEADER_ID;
2061: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_TCS_TAX()';
2062: BEGIN
2063:

Line 2136: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE ;

2132: PROCEDURE process_cm_vat_repo ( pr_old t_jai_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
2133: v_organization_id NUMBER ;
2134: v_loc_id NUMBER ;
2135: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;
2136: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE ;
2137: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
2138: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;
2139: lv_process_flag VARCHAR2(10) ;
2140: lv_process_message VARCHAR2(4000) ;

Line 2142: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE ;

2138: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;
2139: lv_process_flag VARCHAR2(10) ;
2140: lv_process_message VARCHAR2(4000) ;
2141: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;
2142: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE ;
2143:
2144: ln_rma_flag NUMBER;
2145: ln_order_line_id NUMBER;
2146: ln_nonship_rma_flag NUMBER;

Line 2196: || Get the organization, location, vat_invoice_no and vat_invoice_date from JAI_AR_TRXS

2192: AND l.rma_line_id = pn_order_line_id
2193: AND msi.shippable_item_flag = 'N' ;
2194:
2195: /*
2196: || Get the organization, location, vat_invoice_no and vat_invoice_date from JAI_AR_TRXS
2197: */
2198: CURSOR organization_cur
2199: IS
2200: SELECT organization_id ,

Line 2204: FROM JAI_AR_TRXS

2200: SELECT organization_id ,
2201: location_id ,
2202: vat_invoice_no ,
2203: vat_invoice_date
2204: FROM JAI_AR_TRXS
2205: WHERE customer_trx_id = pr_new.customer_trx_id;
2206:
2207: /*
2208: || Get the transaction type of the document

Line 2250: FROM JAI_AR_TRXS

2246:
2247: CURSOR cur_get_in_vat_no
2248: IS
2249: SELECT vat_invoice_no
2250: FROM JAI_AR_TRXS
2251: WHERE customer_trx_id = pr_new.previous_customer_trx_id;
2252:
2253: /*
2254: || Check if only 'VAT REVERSAL' tax type is present in ja_in_ra_cust_trx_tax_lines

Line 2300: cp_organization_id IN JAI_AR_TRXS.organization_id%TYPE,

2296: ( cp_source IN jai_rgm_trx_records.source%TYPE,
2297: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
2298: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,
2299: cp_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
2300: cp_organization_id IN JAI_AR_TRXS.organization_id%TYPE,
2301: cp_loc_id IN JAI_AR_TRXS.location_id%TYPE
2302: )
2303: IS
2304: SELECT

Line 2301: cp_loc_id IN JAI_AR_TRXS.location_id%TYPE

2297: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
2298: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,
2299: cp_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
2300: cp_organization_id IN JAI_AR_TRXS.organization_id%TYPE,
2301: cp_loc_id IN JAI_AR_TRXS.location_id%TYPE
2302: )
2303: IS
2304: SELECT
2305: jctl.customer_trx_id ,