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_OM_RG_PKG dependencies on JAI_AR_TRX_LINES

Line 949: from JAI_AR_TRX_LINES

945: where delivery_detail_id = p_transaction_hdr_id;
946:
947: cursor c_customer_trx_details is
948: select customer_trx_id
949: from JAI_AR_TRX_LINES
950: where customer_trx_line_id = p_transaction_hdr_id;
951:
952: ln_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type;
953: ln_customer_trx_id JAI_AR_TRX_LINES.customer_trx_id%type;

Line 953: ln_customer_trx_id JAI_AR_TRX_LINES.customer_trx_id%type;

949: from JAI_AR_TRX_LINES
950: where customer_trx_line_id = p_transaction_hdr_id;
951:
952: ln_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type;
953: ln_customer_trx_id JAI_AR_TRX_LINES.customer_trx_id%type;
954: ln_Cess_amount number;
955: ln_inv_orgn_id number;
956: ln_header_id number;
957: lv_source_name varchar2(20);

Line 982: p_transaction_hdr_id := customer_trx_line_id from JAI_AR_TRX_LINES table

978: If called from AR invoice completion the values for the parameters are as follows.
979:
980: p_source_name := 'Receivables India'
981: p_category_name := 'RG Register Data Entry'
982: p_transaction_hdr_id := customer_trx_line_id from JAI_AR_TRX_LINES table
983:
984: Based on the customer_trx_line_id , pick up the customer_trx_id , organization id and get the taxes from JAI_AR_TRX_TAX_LINES
985:
986: */

Line 2667: FROM jai_ar_trx_lines lines,

2663: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, begin
2664: --------------------------------------------------------------------------------------
2665: /*CURSOR get_external_flag_cur IS
2666: SELECT COUNT(lines.customer_trx_id)
2667: FROM jai_ar_trx_lines lines,
2668: jai_interface_lines_all intfs
2669: WHERE lines.customer_trx_line_id = intfs.internal_trx_line_id
2670: AND lines.customer_trx_id IN (SELECT customer_trx_id
2671: FROM jai_ar_trx_lines

Line 2671: FROM jai_ar_trx_lines

2667: FROM jai_ar_trx_lines lines,
2668: jai_interface_lines_all intfs
2669: WHERE lines.customer_trx_line_id = intfs.internal_trx_line_id
2670: AND lines.customer_trx_id IN (SELECT customer_trx_id
2671: FROM jai_ar_trx_lines
2672: WHERE customer_trx_line_id = p_picking_line_id)
2673: AND lines.interface_flag = 'Y'
2674: AND intfs.taxable_event = 'EXTERNAL';
2675:

Line 2679: FROM jai_ar_trx_lines jatl

2675:
2676: CURSOR get_external_tax_cur IS
2677: SELECT tax.code_combination_id
2678: , tax.tax_amount
2679: FROM jai_ar_trx_lines jatl
2680: , jai_ar_trx_tax_lines jattl
2681: , jai_interface_lines_all lines
2682: , jai_interface_tax_lines_all tax
2683: WHERE jatl.customer_trx_line_id = p_picking_line_id

Line 3171: FROM jai_ar_trx_lines lines,

3167: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, begin
3168: --------------------------------------------------------------------------------------
3169: /*CURSOR get_external_flag_cur IS
3170: SELECT COUNT(lines.customer_trx_id)
3171: FROM jai_ar_trx_lines lines,
3172: jai_interface_lines_all intfs
3173: WHERE lines.customer_trx_line_id = intfs.internal_trx_line_id
3174: AND lines.customer_trx_id IN (SELECT customer_trx_id
3175: FROM jai_ar_trx_lines

Line 3175: FROM jai_ar_trx_lines

3171: FROM jai_ar_trx_lines lines,
3172: jai_interface_lines_all intfs
3173: WHERE lines.customer_trx_line_id = intfs.internal_trx_line_id
3174: AND lines.customer_trx_id IN (SELECT customer_trx_id
3175: FROM jai_ar_trx_lines
3176: WHERE customer_trx_line_id = p_header_id)
3177: AND lines.interface_flag = 'Y'
3178: AND intfs.taxable_event = 'EXTERNAL';
3179:

Line 3183: FROM jai_ar_trx_lines jatl

3179:
3180: CURSOR get_external_tax_cur IS
3181: SELECT tax.code_combination_id
3182: , tax.tax_amount
3183: FROM jai_ar_trx_lines jatl
3184: , jai_ar_trx_tax_lines jattl
3185: , jai_interface_lines_all lines
3186: , jai_interface_tax_lines_all tax
3187: WHERE jatl.customer_trx_line_id = p_header_id

Line 4364: from JAI_AR_TRX_LINES

4360: where delivery_id = p_header_id;
4361:
4362: cursor c_invoice_header_cur(cp_header_id number) is
4363: select customer_trx_id
4364: from JAI_AR_TRX_LINES
4365: where customer_trx_line_id = cp_header_id;
4366:
4367: /*
4368: following two cursors added by ssumaith - bug# 4136981

Line 4402: from JAI_AR_TRX_LINES

4398: JAI_CMN_TAXES_ALL jtc
4399: where jtc.tax_id = jrctl.tax_id
4400: and link_to_cust_trx_line_id in
4401: (select customer_trx_line_id
4402: from JAI_AR_TRX_LINES
4403: where customer_trx_id = cp_customer_trx_id
4404: )
4405: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS) ;
4406: /*Bug 5989740 bduvarag*/

Line 4414: from JAI_AR_TRX_LINES

4410: JAI_CMN_TAXES_ALL jtc
4411: where jtc.tax_id = jrctl.tax_id
4412: and link_to_cust_trx_line_id in
4413: (select customer_trx_line_id
4414: from JAI_AR_TRX_LINES
4415: where customer_trx_id = cp_customer_trx_id
4416: )
4417: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;
4418:

Line 4426: from JAI_AR_TRX_LINES

4422: JAI_CMN_TAXES_ALL jtc
4423: where jtc.tax_id = jrctl.tax_id
4424: and link_to_cust_trx_line_id in
4425: (select customer_trx_line_id
4426: from JAI_AR_TRX_LINES
4427: where customer_trx_id = cp_customer_trx_id
4428: )
4429: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS) ;
4430: /*Bug 5989740 bduvarag*/

Line 4438: from JAI_AR_TRX_LINES

4434: JAI_CMN_TAXES_ALL jtc
4435: where jtc.tax_id = jrctl.tax_id
4436: and link_to_cust_trx_line_id in
4437: (select customer_trx_line_id
4438: from JAI_AR_TRX_LINES
4439: where customer_trx_id = cp_customer_trx_id
4440: )
4441: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;
4442:

Line 4555: from JAI_AR_TRX_LINES

4551:
4552: for line_rec in
4553: (
4554: select customer_trx_line_id
4555: from JAI_AR_TRX_LINES
4556: where customer_trx_line_id = p_header_id
4557: )
4558: Loop
4559: for cess_rec in

Line 4620: from JAI_AR_TRX_LINES

4616:
4617: for line_rec in
4618: (
4619: select customer_trx_line_id
4620: from JAI_AR_TRX_LINES
4621: where customer_trx_line_id = p_header_id
4622: )
4623: Loop
4624: for cess_rec in