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 RA_CUST_TRX_LINE_GL_DIST_ALL

Line 816: ra_cust_trx_line_gl_dist_all gl_dist ,

812: SELECT
813: gl_dist.gl_date ,
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 ,

Line 935: ld_source_doc_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;

931: lv_process_flag VARCHAR2(2) ;
932: lv_process_message VARCHAR2(4000) ;
933: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
934: ln_surcharge_cnt NUMBER(2) := 0 ;
935: ld_source_doc_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;
936: BEGIN
937:
938: /*########################################################################################################
939: || VARIABLES INITIALIZATION - PART -1

Line 1337: ra_cust_trx_line_gl_dist_all gl_dist ,

1333: jrctl.inventory_item_id ,
1334: gl_dist.amount
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 ,

Line 1371: CURSOR cur_get_cm_sign (cp_cm_customer_trx_id RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID%TYPE )

1367:
1368: /*
1369: ||Get the sign of the Credit Memo document
1370: */
1371: CURSOR cur_get_cm_sign (cp_cm_customer_trx_id RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID%TYPE )
1372: IS
1373: SELECT
1374: sign(nvl(amount,0)) app_fr_sign
1375: FROM

Line 1376: ra_cust_trx_line_gl_dist_all

1372: IS
1373: SELECT
1374: sign(nvl(amount,0)) app_fr_sign
1375: FROM
1376: ra_cust_trx_line_gl_dist_all
1377: WHERE
1378: account_class = jai_constants.account_class_rec
1379: AND latest_rec_flag = jai_constants.yes
1380: AND customer_trx_id = cp_cm_customer_trx_id;

Line 1428: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;

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 ;
1432: ln_app_to_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;

Line 1430: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%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 ;
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:

Line 2038: ra_cust_trx_line_gl_dist_all rct

2034: --NVL(jatl.total_amount,0) total_invoice_amount , --added by eric for inclusive tax on 26-dec,2007
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

Line 2124: ln_total_inv_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;

2120: lv_document_type VARCHAR2(100) ;
2121: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2122: ln_apportion_factor NUMBER(3) ;
2123: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
2124: ln_total_inv_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
2125: ld_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
2126: BEGIN
2127: /*########################################################################################################
2128: || VARIABLES INITIALIZATION

Line 2751: ra_cust_trx_line_gl_dist_all gl_dist ,

2747: nvl(bill_to_site_use_id,ship_to_site_use_id) app_to_customer_site_use_id -- Bug 6132484
2748: FROM
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 ,

Line 2777: CURSOR cur_get_exclu_amt(cp_customer_trx_id RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID%TYPE )

2773: );
2774:
2775: -- Added by Jia Li for inclusive taxes on 2008-01-18
2776: ----------------------------------------------------------------
2777: CURSOR cur_get_exclu_amt(cp_customer_trx_id RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID%TYPE )
2778: IS
2779: SELECT
2780: SUM(a.func_tax_amount)
2781: FROM

Line 2840: CURSOR cur_get_cm_details (cp_customer_trx_id RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID%TYPE)

2836: AND jdt.source_doc_type = JAI_CONSTANTS.ar_cash; --added by eric for a bug
2837: /*
2838: ||Get the applied to document CM details
2839: */
2840: CURSOR cur_get_cm_details (cp_customer_trx_id RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID%TYPE)
2841: IS
2842: SELECT
2843: --nvl(gl_dist.acctd_amount,0) app_fr_doc_amt ,--Deleted by eric for inclusive tax
2844: --NVL(jrctl.total_amount,0) app_fr_doc_amt ,--Added by eric for Inclusisve Tax on 26-dec,2007

Line 2855: ra_cust_trx_line_gl_dist_all gl_dist ,

2851: nvl( bill_to_site_use_id , ship_to_site_use_id ) app_to_customer_site_use_id
2852: FROM
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 ,