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.

[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on JAI_AR_TRX_LINES

Line 764: JAI_AR_TRX_LINES jrctl ,

760: jrttv.regime_id ,
761: jtc.tax_type
762: FROM
763: JAI_AR_TRXS jrct ,
764: JAI_AR_TRX_LINES jrctl ,
765: JAI_AR_TRX_TAX_LINES jrcttl ,
766: JAI_CMN_TAXES_ALL jtc ,
767: jai_regime_tax_types_v jrttv
768:

Line 805: FROM jai_ar_trx_lines lines,

801: --Added by Xiao for Open Interface ER bug#11683927 on 10-Feb-2011, begin
802: ------------------------------------------------------------------------------
803: CURSOR get_external_flag_cur IS
804: SELECT COUNT(lines.customer_trx_id)
805: FROM jai_ar_trx_lines lines,
806: jai_interface_lines_all intfs
807: WHERE lines.customer_trx_line_id = intfs.internal_trx_line_id
808: AND lines.customer_trx_id = p_ract.customer_trx_id
809: AND lines.interface_flag = 'Y'

Line 1308: JAI_AR_TRX_LINES jrctl ,

1304: jrct.organization_id
1305: FROM
1306: ra_cust_trx_line_gl_dist_all gl_dist ,
1307: JAI_AR_TRXS jrct ,
1308: JAI_AR_TRX_LINES jrctl ,
1309: JAI_AR_TRX_TAX_LINES jrcttl ,
1310: JAI_CMN_TAXES_ALL jtc ,
1311: jai_regime_tax_types_v jrttv
1312: WHERE

Line 1358: JAI_AR_TRX_LINES jrctl,

1354: IS
1355: SELECT
1356: 1
1357: FROM
1358: JAI_AR_TRX_LINES jrctl,
1359: ra_customer_trx_lines_all rctla --Added by JMEENA to filter discount line. for bug#8241099
1360: WHERE
1361: jrctl.customer_trx_id = cp_customer_trx_id
1362: AND jrctl.customer_trx_id = rctla.customer_trx_id

Line 1382: CURSOR cur_chk_tcs_sur_tax ( cp_customer_trx_id JAI_AR_TRX_LINES.CUSTOMER_TRX_ID%TYPE )

1378:
1379: /*
1380: ||Check tcs surcharge applicability on document
1381: */
1382: CURSOR cur_chk_tcs_sur_tax ( cp_customer_trx_id JAI_AR_TRX_LINES.CUSTOMER_TRX_ID%TYPE )
1383: IS
1384: SELECT
1385: count(*) surcharge_cnt
1386: FROM

Line 1387: JAI_AR_TRX_LINES jrctl ,

1383: IS
1384: SELECT
1385: count(*) surcharge_cnt
1386: FROM
1387: JAI_AR_TRX_LINES jrctl ,
1388: JAI_AR_TRX_TAX_LINES jrcttl ,
1389: JAI_CMN_TAXES_ALL jtc ,
1390: jai_regime_tax_types_v jrttv
1391: WHERE

Line 1412: JAI_AR_TRX_LINES jrctl

1408: organization_id ,
1409: inventory_item_id
1410: FROM
1411: JAI_AR_TRXS jrct ,
1412: JAI_AR_TRX_LINES jrctl
1413: WHERE
1414: jrct.customer_trx_id = cp_customer_trx_id
1415: AND jrct.customer_trx_id = jrctl.customer_trx_id;
1416:

Line 1854: JAI_AR_TRX_LINES jrctl ,

1850: FROM
1851: ra_customer_trx_all rcta ,
1852: ra_cust_trx_line_gl_dist_all gl_dist ,
1853: JAI_AR_TRXS jrct ,
1854: JAI_AR_TRX_LINES jrctl ,
1855: JAI_AR_TRX_TAX_LINES jrcttl ,
1856: JAI_CMN_TAXES_ALL jtc ,
1857: jai_regime_tax_types_v jrttv
1858: WHERE

Line 1942: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;

1938: ln_sign_of_app NUMBER(3) ;
1939: lv_exists VARCHAR2(1) ;
1940: ln_app_fr_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1941: ln_app_fr_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1942: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1943: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1944:
1945: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1946: ln_app_to_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;

Line 1948: ln_app_to_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;

1944:
1945: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1946: ln_app_to_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1947: ln_app_to_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1948: ln_app_to_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1949:
1950: lv_app_doc_type VARCHAR2(100) ;
1951: rec_cur_chk_parent_rec CUR_CHK_PARENT_REC%ROWTYPE ;
1952: lv_process_flag VARCHAR2(2) ;

Line 2554: , jai_ar_trx_lines jatl --added by eric for inclusive tax

2550: NVL(jatl.line_amount,0) total_invoice_amount , --added by Jia Li for inclusive tax on 2008-01-18
2551: rct.gl_date
2552: FROM
2553: ra_cust_trx_line_gl_dist_all rct
2554: , jai_ar_trx_lines jatl --added by eric for inclusive tax
2555: WHERE jatl.customer_trx_id = rct.customer_trx_id --added by eric for inclusive tax
2556: AND rct.customer_trx_id = p_ract.customer_trx_id
2557: AND rct.account_class = jai_constants.account_class_rec
2558: AND rct.latest_rec_flag = jai_constants.yes;

Line 2573: jai_ar_trx_lines

2569: WHERE link_to_cust_trx_line_id IN
2570: ( SELECT
2571: customer_trx_line_id
2572: FROM
2573: jai_ar_trx_lines
2574: WHERE customer_trx_id = p_ract.customer_trx_id )
2575: AND a.tax_id = b.tax_id
2576: AND NVL(b.inclusive_tax_flag,'N') = 'N';
2577: ln_total_inv_exclu_amt jai_ar_trx_tax_lines.func_tax_amount%TYPE;

Line 2602: CURSOR cur_get_inv_taxes (cp_customer_trx_line_id JAI_AR_TRX_LINES.CUSTOMER_TRX_LINE_ID%TYPE )

2598:
2599: /*****
2600: ||Get the Invoice tax details
2601: ******/
2602: CURSOR cur_get_inv_taxes (cp_customer_trx_line_id JAI_AR_TRX_LINES.CUSTOMER_TRX_LINE_ID%TYPE )
2603: IS
2604: SELECT
2605: jrcttl.customer_trx_line_id ,
2606: jrcttl.tax_id ,

Line 2626: JAI_AR_TRX_LINES

2622: IS
2623: SELECT
2624: count(*) no_of_rows
2625: FROM
2626: JAI_AR_TRX_LINES
2627: WHERE
2628: customer_trx_id = p_ract.customer_trx_id ;
2629:
2630: ln_row_count NUMBER(3) ;

Line 2914: JAI_AR_TRX_LINES jrctl ,

2910: )
2911: AND exists ( SELECT /* TCS type of taxes exist for the corresponding Invoice */
2912: 1
2913: FROM
2914: JAI_AR_TRX_LINES jrctl ,
2915: JAI_AR_TRX_TAX_LINES jrcttl,
2916: JAI_CMN_TAXES_ALL jtc ,
2917: jai_regime_tax_types_v jrttv
2918: WHERE

Line 3274: JAI_AR_TRX_LINES jrctl ,

3270: ra_customer_trx_all rcta ,
3271: ra_cust_trx_types_all trx_types ,
3272: ra_cust_trx_line_gl_dist_all gl_dist ,
3273: JAI_AR_TRXS jrct ,
3274: JAI_AR_TRX_LINES jrctl ,
3275: JAI_AR_TRX_TAX_LINES jrcttl ,
3276: JAI_CMN_TAXES_ALL jtc ,
3277: jai_regime_tax_types_v jrttv
3278: WHERE

Line 3309: jai_ar_trx_lines

3305: WHERE link_to_cust_trx_line_id IN
3306: ( SELECT
3307: customer_trx_line_id
3308: FROM
3309: jai_ar_trx_lines
3310: WHERE customer_trx_id = cp_customer_trx_id )
3311: AND a.tax_id = b.tax_id
3312: AND NVL(b.inclusive_tax_flag,'N') = 'N';
3313: ln_total_exclu_amt jai_ar_trx_tax_lines.func_tax_amount%TYPE;

Line 3382: JAI_AR_TRX_LINES jrctl ,

3378: ra_customer_trx_all rcta ,
3379: ra_cust_trx_types_all trx_types ,
3380: ra_cust_trx_line_gl_dist_all gl_dist ,
3381: JAI_AR_TRXS jrct ,
3382: JAI_AR_TRX_LINES jrctl ,
3383: JAI_AR_TRX_TAX_LINES jrcttl ,
3384: JAI_CMN_TAXES_ALL jtc ,
3385: jai_regime_tax_types_v jrttv
3386: WHERE

Line 3497: ln_app_to_doc_table := jai_constants.ar_inv_lines_table ; /* table JAI_AR_TRX_LINES */

3493: OPEN cur_get_doc_type ( cp_customer_trx_id => p_araa.applied_customer_trx_id ) ;
3494: FETCH cur_get_doc_type INTO ln_app_to_doc_type ;
3495: CLOSE cur_get_doc_type ;
3496:
3497: ln_app_to_doc_table := jai_constants.ar_inv_lines_table ; /* table JAI_AR_TRX_LINES */
3498: ln_app_to_doc_type := rec_cur_get_app_to_det.app_to_doc_type ;
3499: ln_to_organization_id := rec_cur_get_app_to_det.app_to_organization_id ;
3500: ln_to_party_id := rec_cur_get_app_to_det.app_to_customer_id ;
3501: ln_to_party_site_id := rec_cur_get_app_to_det.app_to_customer_site_use_id ;

Line 4565: CURSOR cur_get_inv_taxes ( cp_customer_trx_id JAI_AR_TRX_LINES.CUSTOMER_TRX_ID%TYPE ,

4561: ln_reg_id NUMBER;
4562: /*****
4563: ||Get the Invoice tax details
4564: ******/
4565: CURSOR cur_get_inv_taxes ( cp_customer_trx_id JAI_AR_TRX_LINES.CUSTOMER_TRX_ID%TYPE ,
4566: cp_customer_trx_line_id JAI_AR_TRX_LINES.CUSTOMER_TRX_LINE_ID%TYPE
4567: )
4568: IS
4569: SELECT

Line 4566: cp_customer_trx_line_id JAI_AR_TRX_LINES.CUSTOMER_TRX_LINE_ID%TYPE

4562: /*****
4563: ||Get the Invoice tax details
4564: ******/
4565: CURSOR cur_get_inv_taxes ( cp_customer_trx_id JAI_AR_TRX_LINES.CUSTOMER_TRX_ID%TYPE ,
4566: cp_customer_trx_line_id JAI_AR_TRX_LINES.CUSTOMER_TRX_LINE_ID%TYPE
4567: )
4568: IS
4569: SELECT
4570: jrcttl.customer_trx_line_id ,

Line 4579: JAI_AR_TRX_LINES jrctl ,

4575: jrcttl.func_tax_amount ,
4576: jrct.invoice_currency_code currency_code
4577: FROM
4578: JAI_AR_TRXS jrct ,
4579: JAI_AR_TRX_LINES jrctl ,
4580: JAI_AR_TRX_TAX_LINES jrcttl ,
4581: JAI_CMN_TAXES_ALL jtc ,
4582: jai_regime_tax_types_v jrttv
4583: WHERE