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

Line 1639: --cursor c_get_ra_line_srvtyp (cp_customer_trx_line_id jai_ar_trx_lines.customer_trx_line_id%type) --commented by Chong.Lei for POT code port

1635: and jrlt.tax_type IN (jai_constants.tax_type_service,jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess)
1636: group by service_type_code;
1637: /*Bug 12902363 - End*/
1638:
1639: --cursor c_get_ra_line_srvtyp (cp_customer_trx_line_id jai_ar_trx_lines.customer_trx_line_id%type) --commented by Chong.Lei for POT code port
1640: --Added by Chong.Lei for POT code port begin
1641: cursor c_get_ra_line_srvtyp (cp_customer_trx_line_id jai_ar_trx_lines.customer_trx_line_id%TYPE
1642: , pv_document_source VARCHAR2 --Add by Xiao for POT Phase III, reg bug#12895841.
1643: --Added by Chong.Lei for POT code port end

Line 1641: cursor c_get_ra_line_srvtyp (cp_customer_trx_line_id jai_ar_trx_lines.customer_trx_line_id%TYPE

1637: /*Bug 12902363 - End*/
1638:
1639: --cursor c_get_ra_line_srvtyp (cp_customer_trx_line_id jai_ar_trx_lines.customer_trx_line_id%type) --commented by Chong.Lei for POT code port
1640: --Added by Chong.Lei for POT code port begin
1641: cursor c_get_ra_line_srvtyp (cp_customer_trx_line_id jai_ar_trx_lines.customer_trx_line_id%TYPE
1642: , pv_document_source VARCHAR2 --Add by Xiao for POT Phase III, reg bug#12895841.
1643: --Added by Chong.Lei for POT code port end
1644: )
1645: is

Line 1652: from JAI_AR_TRX_LINES jrctl

1648: select jrctl.service_type_code,
1649: --sum(jrcttl.tax_amount) service_tax_amount
1650: abs(SUM(NVL(jrec.DEBIT_AMOUNT,0))-SUM(NVL(jrec.CREDIT_AMOUNT,0))) service_tax_amount--Add by Xiao for POT Phase III, reg bug#12895841.
1651: --Added by Chong.Lei for POT code port end
1652: from JAI_AR_TRX_LINES jrctl
1653: ,JAI_AR_TRX_TAX_LINES jrcttl
1654: ,jai_cmn_taxes_all jtc
1655: --Added by Chong.Lei for POT code port begin
1656: , jai_rgm_trx_records jrec --Add by Xiao for POT Phase III, reg bug#12895841.

Line 1691: FROM jai_ar_trx_lines

1687: AND jrec.TAX_TYPE IN (jai_constants.tax_type_service,jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess);
1688: /*Bug 11932841 - Added cp_cust_trx_line_id*/
1689: CURSOR c_get_ra_line_amt_applied (cp_customer_trx_id NUMBER, cp_cust_trx_line_id NUMBER) IS
1690: SELECT Sum(Nvl(line_applied,0)) * max(((SELECT line_amount
1691: FROM jai_ar_trx_lines
1692: WHERE customer_trx_id = cp_customer_trx_id
1693: AND customer_trx_line_id = cp_cust_trx_line_id)/
1694: (SELECT line_amount
1695: FROM jai_ar_trxs

Line 3199: update JAI_AR_TRX_LINES set service_type_code = rec.service_type_code

3195: and line_id = rec.document_line_id;
3196:
3197: elsif rec.transaction_source = 'RECEIVABLES' then
3198:
3199: update JAI_AR_TRX_LINES set service_type_code = rec.service_type_code
3200: , last_update_date = sysdate
3201: , last_updated_by = lv_user_id
3202: , last_update_login = lv_login_id
3203: where customer_trx_id = rec.document_id

Line 3264: update jai_ar_trx_lines

3260: -- Bug 5876390, 6012570
3261:
3262: if rec.transaction_source in ('PROJECTS','ORDER MANAGEMENT') then
3263: -- In case of project and order invoices the invoice also should be updated
3264: update jai_ar_trx_lines
3265: set service_type_code = rec.service_type_code
3266: , last_update_date = sysdate
3267: , last_updated_by = lv_user_id
3268: , last_update_login = lv_login_id