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.JMF_GTA_TRX_UTIL dependencies on RA_CUSTOMER_TRX_ALL

Line 162: ,ra_customer_trx_all rcta

158: l_invoice_type
159: FROM
160: jmf_gta_tax_limits_all jgtla
161: ,jmf_gta_type_mappings jgtm
162: ,ra_customer_trx_all rcta
163: WHERE rcta.customer_trx_id = p_customer_trx_id
164: AND rcta.cust_trx_type_id = jgtm.transaction_type_id
165: AND jgtm.limitation_id = jgtla.limitation_id
166: AND jgtla.fp_tax_registration_number = p_fp_tax_registration_num

Line 927: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--jogen bug5212702 May-17,2006

923: IS
924: l_tax_type_code zx_lines.tax_type_code%TYPE;
925: l_taxline_count NUMBER;
926: l_gt_currency_code fnd_currencies.currency_code%TYPE;
927: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--jogen bug5212702 May-17,2006
928:
929: CURSOR c_tax_type_code
930: IS
931: SELECT

Line 1653: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;

1649: IS
1650: l_tax_type_code zx_lines.tax_type_code%TYPE;
1651: l_arline_amount NUMBER;
1652: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1653: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
1654:
1655: CURSOR c_tax_type_code
1656: IS
1657: SELECT

Line 1765: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006

1761: IS
1762: l_tax_type_code zx_lines.tax_type_code%TYPE;
1763: l_arline_vatamount NUMBER;
1764: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1765: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006
1766:
1767: CURSOR c_tax_type_code
1768: IS
1769: SELECT

Line 1876: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006

1872: IS
1873: l_tax_type_code zx_lines.tax_type_code%TYPE;
1874: l_tax_rate NUMBER;
1875: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1876: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006
1877:
1878: CURSOR c_tax_type_code
1879: IS
1880: SELECT

Line 1991: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;

1987: )
1988: IS
1989: l_procedure_name VARCHAR2(30) := 'Get_Bank_Info';
1990:
1991: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
1992:
1993: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
1994: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
1995: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;

Line 1998: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;

1994: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
1995: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1996: l_error_string VARCHAR2(500);
1997:
1998: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
1999: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2000: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2001: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2002: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;

Line 1999: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;

1995: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1996: l_error_string VARCHAR2(500);
1997:
1998: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
1999: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2000: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2001: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2002: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2003: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;

Line 2009: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;

2005: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2006: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2007: l_bank_name HZ_PARTIES.party_name%TYPE;
2008: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2009: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2010:
2011: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;
2012:
2013:

Line 2065: ra_customer_trx_all h

2061: l_paying_customer_id
2062: , l_paying_site_use_id
2063: , l_trxn_extension_id
2064: FROM
2065: ra_customer_trx_all h
2066:
2067: WHERE h.customer_trx_id = p_customer_trx_id ;
2068: EXCEPTION
2069: WHEN no_data_found THEN

Line 2294: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--jogen bug5212702 May-17,2006

2290: IS
2291: l_tax_line_count NUMBER;
2292: l_procedure_name VARCHAR2(50) := 'verify_tax_line';
2293: l_tax_line_id zx_lines.tax_line_id%TYPE;
2294: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--jogen bug5212702 May-17,2006
2295:
2296: BEGIN
2297:
2298: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 2795: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;

2791: , x_tp_tax_registration_number OUT NOCOPY VARCHAR2
2792: )
2793: IS
2794: l_procedure_name VARCHAR2(80) := 'get_tp_tax_registration_number';
2795: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2796: l_ra_cust_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2797: l_tax_regime_code zx_lines.tax_regime_code%TYPE;
2798: l_tax zx_lines.tax%TYPE;
2799: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;

Line 2796: l_ra_cust_trx_id ra_customer_trx_all.customer_trx_id%TYPE;

2792: )
2793: IS
2794: l_procedure_name VARCHAR2(80) := 'get_tp_tax_registration_number';
2795: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2796: l_ra_cust_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2797: l_tax_regime_code zx_lines.tax_regime_code%TYPE;
2798: l_tax zx_lines.tax%TYPE;
2799: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2800: l_tax_determine_date zx_lines.tax_determine_date%TYPE;

Line 2875: ra_customer_trx_all trx_header

2871: bill_to_site_use_id
2872: INTO
2873: l_bill_to_site_use_id
2874: FROM
2875: ra_customer_trx_all trx_header
2876: WHERE trx_header.customer_trx_id = p_trx_id;
2877:
2878: -- get cust_acct_site_id by site_use_id
2879: SELECT

Line 3182: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006

3178: l_tax_rate NUMBER;
3179: l_gt_currency_code fnd_currencies.currency_code%TYPE;
3180: l_tax_line_id zx_lines.tax_line_id%TYPE;
3181: l_tp_tax_registration_number zx_registrations.registration_number%TYPE;
3182: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006
3183:
3184:
3185: CURSOR c_tax_type_code
3186: IS