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_RCTA_TRIGGER_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 2765: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;

2761: v_salesrep_id NUMBER;
2762: v_line_type VARCHAR2(30);
2763: v_vat_tax NUMBER;
2764: v_ccid NUMBER;
2765: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;
2766: v_customer_trx_line_id NUMBER ;
2767: v_customer_trx_id NUMBER; -- := pr_new.customer_trx_id; --Ramananda for File.Sql.35
2768: v_created_from VARCHAR2(30);
2769: c_from_currency_code VARCHAR2(15);

Line 2785: lv_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;

2781: v_org_id NUMBER(15);
2782: -- Bug 5207772. Added by Lakshmi Gopalsami
2783: v_order_type VARCHAR2(30);
2784:
2785: lv_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;
2786: lv_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;
2787: lv_acct_class_tax RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;
2788: lv_acct_class_freight RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;
2789:

Line 2786: lv_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;

2782: -- Bug 5207772. Added by Lakshmi Gopalsami
2783: v_order_type VARCHAR2(30);
2784:
2785: lv_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;
2786: lv_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;
2787: lv_acct_class_tax RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;
2788: lv_acct_class_freight RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;
2789:
2790: ld_st_accrual_date DATE; /*11821537*/

Line 2862: FROM RA_CUSTOMER_TRX_LINES_ALL

2858:
2859: CURSOR C_GET_TRX_COUNT
2860: IS
2861: SELECT COUNT(*)
2862: FROM RA_CUSTOMER_TRX_LINES_ALL
2863: WHERE CUSTOMER_TRX_ID = pr_new.CUSTOMER_TRX_ID
2864: AND LINE_TYPE in (lv_line_type_tax, lv_line_type_freight); /* Modified by Ramananda for removal of SQL LITERALs */
2865: --('TAX','FREIGHT');
2866:

Line 3036: /* RAISE_APPLICATION_ERROR(-20102,'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables');

3032:
3033:
3034:
3035: IF v_TRX_TAX_COUNT <> v_trx_gl_dist_COUNT THEN
3036: /* RAISE_APPLICATION_ERROR(-20102,'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables');
3037: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables' ; return ;
3038: END IF ;
3039:
3040: FOR v_trx_rec in C_GET_TRX_DETAILS

Line 3037: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables' ; return ;

3033:
3034:
3035: IF v_TRX_TAX_COUNT <> v_trx_gl_dist_COUNT THEN
3036: /* RAISE_APPLICATION_ERROR(-20102,'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables');
3037: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables' ; return ;
3038: END IF ;
3039:
3040: FOR v_trx_rec in C_GET_TRX_DETAILS
3041:

Line 4005: FROM ra_customer_trx_lines_all

4001: IS
4002: SELECT interface_line_attribute6 order_line_id
4003: ,inventory_item_id
4004: ,customer_trx_line_id --Added By Bo Li for bug#9765108 on 09-JUL-2010
4005: FROM ra_customer_trx_lines_all
4006: WHERE customer_trx_id = pr_new.customer_trx_id;
4007:
4008: /*
4009: || Check the trasaction is from RMA credit only

Line 4153: cp_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,

4149: CURSOR cur_get_man_ar_inv_taxes
4150: ( cp_source IN jai_rgm_trx_records.source%TYPE,
4151: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
4152: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,
4153: cp_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
4154: cp_organization_id IN JAI_AR_TRXS.organization_id%TYPE,
4155: cp_loc_id IN JAI_AR_TRXS.location_id%TYPE
4156: )
4157: IS

Line 4636: -- SELECT ra_customer_trx_lines_s.nextval INTO v_customer_trx_line_id FROM Dual;

4632:
4633: FOR rec in LINES_INFO_CUR(v_parent_header_id)
4634: LOOP
4635:
4636: -- SELECT ra_customer_trx_lines_s.nextval INTO v_customer_trx_line_id FROM Dual;
4637:
4638: INSERT INTO JAI_AR_TRX_LINES
4639: (customer_trx_line_id, line_number,
4640: customer_trx_id, description,

Line 4649: VALUES(ra_customer_trx_lines_s.nextval,

4645: creation_date, created_by,
4646: last_update_date,last_updated_by,
4647: last_update_login,
4648: service_type_code) --added by csahoo for Bug#5879769
4649: VALUES(ra_customer_trx_lines_s.nextval,
4650: --v_customer_trx_line_id, /* Commented by Ramananda as a part of removal of SQL LITERALs */
4651: rec.line_number,
4652: v_header_id,rec.description,
4653: rec.inventory_item_id, rec.unit_code,

Line 4676: VALUES( ra_customer_trx_lines_s.nextval, v_customer_trx_line_id, rec1.tax_line_no,

4672: tax_id, tax_rate, qty_rate, uom,
4673: tax_amount, base_tax_amount, func_tax_amount,
4674: creation_date, created_by, last_update_date,
4675: last_updated_by, last_update_login)
4676: VALUES( ra_customer_trx_lines_s.nextval, v_customer_trx_line_id, rec1.tax_line_no,
4677: rec1.precedence_1, rec1.precedence_2, rec1.precedence_3, rec1.precedence_4, rec1.precedence_5,
4678: rec1.precedence_6, rec1.precedence_7, rec1.precedence_8, rec1.precedence_9, rec1.precedence_10, -- Date 06/12/2006 Bug 5228046 added by SACSETHI
4679: rec1.tax_id, rec1.tax_rate, rec1.qty_rate, rec1.uom,
4680: rec1.tax_amount, rec1.base_tax_amount, rec1.func_tax_amount,