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

Line 334: JAI_AR_TRX_LINES jrctl ,

330: jrttv.regime_id ,
331: jtc.tax_type
332: FROM
333: JAI_AR_TRXS jrct ,
334: JAI_AR_TRX_LINES jrctl ,
335: JAI_AR_TRX_TAX_LINES jrcttl ,
336: JAI_CMN_TAXES_ALL jtc ,
337: jai_regime_tax_types_v jrttv
338:

Line 818: JAI_AR_TRX_LINES jrctl ,

814: jrct.organization_id
815: FROM
816: ra_cust_trx_line_gl_dist_all gl_dist ,
817: JAI_AR_TRXS jrct ,
818: JAI_AR_TRX_LINES jrctl ,
819: JAI_AR_TRX_TAX_LINES jrcttl ,
820: JAI_CMN_TAXES_ALL jtc ,
821: jai_regime_tax_types_v jrttv
822: WHERE

Line 868: JAI_AR_TRX_LINES jrctl

864: IS
865: SELECT
866: 1
867: FROM
868: JAI_AR_TRX_LINES jrctl
869: WHERE
870: jrctl.customer_trx_id = cp_customer_trx_id
871: AND NOT EXISTS ( SELECT /*Check that TCS type of taxes are not */
872: 1

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

884:
885: /*
886: ||Check tcs surcharge applicability on document
887: */
888: CURSOR cur_chk_tcs_sur_tax ( cp_customer_trx_id JAI_AR_TRX_LINES.CUSTOMER_TRX_ID%TYPE )
889: IS
890: SELECT
891: count(*) surcharge_cnt
892: FROM

Line 893: JAI_AR_TRX_LINES jrctl ,

889: IS
890: SELECT
891: count(*) surcharge_cnt
892: FROM
893: JAI_AR_TRX_LINES jrctl ,
894: JAI_AR_TRX_TAX_LINES jrcttl ,
895: JAI_CMN_TAXES_ALL jtc ,
896: jai_regime_tax_types_v jrttv
897: WHERE

Line 918: JAI_AR_TRX_LINES jrctl

914: organization_id ,
915: inventory_item_id
916: FROM
917: JAI_AR_TRXS jrct ,
918: JAI_AR_TRX_LINES jrctl
919: WHERE
920: jrct.customer_trx_id = cp_customer_trx_id
921: AND jrct.customer_trx_id = jrctl.customer_trx_id;
922:

Line 1339: JAI_AR_TRX_LINES jrctl ,

1335: FROM
1336: ra_customer_trx_all rcta ,
1337: ra_cust_trx_line_gl_dist_all gl_dist ,
1338: JAI_AR_TRXS jrct ,
1339: JAI_AR_TRX_LINES jrctl ,
1340: JAI_AR_TRX_TAX_LINES jrcttl ,
1341: JAI_CMN_TAXES_ALL jtc ,
1342: jai_regime_tax_types_v jrttv
1343: WHERE

Line 1427: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;

1423: ln_sign_of_app NUMBER(3) ;
1424: lv_exists VARCHAR2(1) ;
1425: ln_app_fr_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1426: ln_app_fr_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1427: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1428: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1429:
1430: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1431: ln_app_to_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;

Line 1433: ln_app_to_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;

1429:
1430: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1431: ln_app_to_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1432: ln_app_to_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1433: ln_app_to_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1434:
1435: lv_app_doc_type VARCHAR2(100) ;
1436: rec_cur_chk_parent_rec CUR_CHK_PARENT_REC%ROWTYPE ;
1437: lv_process_flag VARCHAR2(2) ;

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

2035: NVL(jatl.line_amount,0) total_invoice_amount , --added by Jia Li for inclusive tax on 2008-01-18
2036: rct.gl_date
2037: FROM
2038: ra_cust_trx_line_gl_dist_all rct
2039: , jai_ar_trx_lines jatl --added by eric for inclusive tax
2040: WHERE jatl.customer_trx_id = rct.customer_trx_id --added by eric for inclusive tax
2041: AND rct.customer_trx_id = p_ract.customer_trx_id
2042: AND rct.account_class = jai_constants.account_class_rec
2043: AND rct.latest_rec_flag = jai_constants.yes;

Line 2058: jai_ar_trx_lines

2054: WHERE link_to_cust_trx_line_id IN
2055: ( SELECT
2056: customer_trx_line_id
2057: FROM
2058: jai_ar_trx_lines
2059: WHERE customer_trx_id = p_ract.customer_trx_id )
2060: AND a.tax_id = b.tax_id
2061: AND NVL(b.inclusive_tax_flag,'N') = 'N';
2062: ln_total_inv_exclu_amt jai_ar_trx_tax_lines.func_tax_amount%TYPE;

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

2083:
2084: /*****
2085: ||Get the Invoice tax details
2086: ******/
2087: CURSOR cur_get_inv_taxes (cp_customer_trx_line_id JAI_AR_TRX_LINES.CUSTOMER_TRX_LINE_ID%TYPE )
2088: IS
2089: SELECT
2090: jrcttl.customer_trx_line_id ,
2091: jrcttl.tax_id ,

Line 2111: JAI_AR_TRX_LINES

2107: IS
2108: SELECT
2109: count(*) no_of_rows
2110: FROM
2111: JAI_AR_TRX_LINES
2112: WHERE
2113: customer_trx_id = p_ract.customer_trx_id ;
2114:
2115: ln_row_count NUMBER(3) ;

Line 2399: JAI_AR_TRX_LINES jrctl ,

2395: )
2396: AND exists ( SELECT /* TCS type of taxes exist for the corresponding Invoice */
2397: 1
2398: FROM
2399: JAI_AR_TRX_LINES jrctl ,
2400: JAI_AR_TRX_TAX_LINES jrcttl,
2401: JAI_CMN_TAXES_ALL jtc ,
2402: jai_regime_tax_types_v jrttv
2403: WHERE

Line 2753: JAI_AR_TRX_LINES jrctl ,

2749: ra_customer_trx_all rcta ,
2750: ra_cust_trx_types_all trx_types ,
2751: ra_cust_trx_line_gl_dist_all gl_dist ,
2752: JAI_AR_TRXS jrct ,
2753: JAI_AR_TRX_LINES jrctl ,
2754: JAI_AR_TRX_TAX_LINES jrcttl ,
2755: JAI_CMN_TAXES_ALL jtc ,
2756: jai_regime_tax_types_v jrttv
2757: WHERE

Line 2788: jai_ar_trx_lines

2784: WHERE link_to_cust_trx_line_id IN
2785: ( SELECT
2786: customer_trx_line_id
2787: FROM
2788: jai_ar_trx_lines
2789: WHERE customer_trx_id = cp_customer_trx_id )
2790: AND a.tax_id = b.tax_id
2791: AND NVL(b.inclusive_tax_flag,'N') = 'N';
2792: ln_total_exclu_amt jai_ar_trx_tax_lines.func_tax_amount%TYPE;

Line 2857: JAI_AR_TRX_LINES jrctl ,

2853: ra_customer_trx_all rcta ,
2854: ra_cust_trx_types_all trx_types ,
2855: ra_cust_trx_line_gl_dist_all gl_dist ,
2856: JAI_AR_TRXS jrct ,
2857: JAI_AR_TRX_LINES jrctl ,
2858: JAI_AR_TRX_TAX_LINES jrcttl ,
2859: JAI_CMN_TAXES_ALL jtc ,
2860: jai_regime_tax_types_v jrttv
2861: WHERE

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

2968: OPEN cur_get_doc_type ( cp_customer_trx_id => p_araa.applied_customer_trx_id ) ;
2969: FETCH cur_get_doc_type INTO ln_app_to_doc_type ;
2970: CLOSE cur_get_doc_type ;
2971:
2972: ln_app_to_doc_table := jai_constants.ar_inv_lines_table ; /* table JAI_AR_TRX_LINES */
2973: ln_app_to_doc_type := rec_cur_get_app_to_det.app_to_doc_type ;
2974: ln_to_organization_id := rec_cur_get_app_to_det.app_to_organization_id ;
2975: ln_to_party_id := rec_cur_get_app_to_det.app_to_customer_id ;
2976: ln_to_party_site_id := rec_cur_get_app_to_det.app_to_customer_site_use_id ;

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

3990: ln_reg_id NUMBER;
3991: /*****
3992: ||Get the Invoice tax details
3993: ******/
3994: CURSOR cur_get_inv_taxes ( cp_customer_trx_id JAI_AR_TRX_LINES.CUSTOMER_TRX_ID%TYPE ,
3995: cp_customer_trx_line_id JAI_AR_TRX_LINES.CUSTOMER_TRX_LINE_ID%TYPE
3996: )
3997: IS
3998: SELECT

Line 3995: cp_customer_trx_line_id JAI_AR_TRX_LINES.CUSTOMER_TRX_LINE_ID%TYPE

3991: /*****
3992: ||Get the Invoice tax details
3993: ******/
3994: CURSOR cur_get_inv_taxes ( cp_customer_trx_id JAI_AR_TRX_LINES.CUSTOMER_TRX_ID%TYPE ,
3995: cp_customer_trx_line_id JAI_AR_TRX_LINES.CUSTOMER_TRX_LINE_ID%TYPE
3996: )
3997: IS
3998: SELECT
3999: jrcttl.customer_trx_line_id ,

Line 4008: JAI_AR_TRX_LINES jrctl ,

4004: jrcttl.func_tax_amount ,
4005: jrct.invoice_currency_code currency_code
4006: FROM
4007: JAI_AR_TRXS jrct ,
4008: JAI_AR_TRX_LINES jrctl ,
4009: JAI_AR_TRX_TAX_LINES jrcttl ,
4010: JAI_CMN_TAXES_ALL jtc ,
4011: jai_regime_tax_types_v jrttv
4012: WHERE