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

Line 193: ,ra_customer_trx_all rcta

189: l_invoice_type
190: FROM
191: ar_gta_tax_limits_all jgtla
192: ,ar_gta_type_mappings jgtm
193: ,ra_customer_trx_all rcta
194: WHERE rcta.customer_trx_id = p_customer_trx_id
195: AND rcta.cust_trx_type_id = jgtm.transaction_type_id
196: AND jgtm.limitation_id = jgtla.limitation_id
197: AND jgtla.fp_tax_registration_number = p_fp_tax_registration_num

Line 215: FROM ra_customer_trx_all h,

211: -- Yao zhang modified for bug 14580597
212: BEGIN
213: SELECT HCA.CLASS_CODE
214: INTO l_class_code
215: FROM ra_customer_trx_all h,
216: hz_cust_site_uses_all hcsua,
217: zx_party_tax_profile ZPTP,
218: hz_code_assignments HCA,
219: HZ_CUST_ACCT_SITES_ALL HCASA

Line 239: FROM ra_customer_trx_all h,

235: IF l_class_code is null then
236: BEGIN
237: SELECT HCA.CLASS_CODE
238: INTO l_class_code
239: FROM ra_customer_trx_all h,
240: Hz_Parties RAC_BILL_PARTY,
241: Hz_Cust_Accounts RAC_BILL,
242: zx_party_tax_profile ZPTP,
243: hz_code_assignments HCA

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

1130: IS
1131: l_tax_type_code zx_lines.tax_type_code%TYPE;
1132: l_taxline_count NUMBER;
1133: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1134: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--jogen bug5212702 May-17,2006
1135:
1136: CURSOR c_tax_type_code
1137: IS
1138: SELECT

Line 1860: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;

1856: IS
1857: l_tax_type_code zx_lines.tax_type_code%TYPE;
1858: l_arline_amount NUMBER;
1859: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1860: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
1861:
1862: CURSOR c_tax_type_code
1863: IS
1864: SELECT

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

1968: IS
1969: l_tax_type_code zx_lines.tax_type_code%TYPE;
1970: l_arline_vatamount NUMBER;
1971: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1972: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006
1973:
1974: CURSOR c_tax_type_code
1975: IS
1976: SELECT

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

2079: IS
2080: l_tax_type_code zx_lines.tax_type_code%TYPE;
2081: l_tax_rate NUMBER;
2082: l_gt_currency_code fnd_currencies.currency_code%TYPE;
2083: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006
2084:
2085: CURSOR c_tax_type_code
2086: IS
2087: SELECT

Line 2199: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;

2195: )
2196: IS
2197: l_procedure_name VARCHAR2(30) := 'Get_Bank_Info';
2198:
2199: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2200: ----Yao Zhang add begin for bug#8404856
2201: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2202: l_valid_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2203: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;

Line 2201: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;

2197: l_procedure_name VARCHAR2(30) := 'Get_Bank_Info';
2198:
2199: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2200: ----Yao Zhang add begin for bug#8404856
2201: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2202: l_valid_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2203: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2204: ----Yao Zhang add end for bug#8404856
2205:

Line 2202: l_valid_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;

2198:
2199: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2200: ----Yao Zhang add begin for bug#8404856
2201: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2202: l_valid_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2203: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2204: ----Yao Zhang add end for bug#8404856
2205:
2206: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;

Line 2203: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;

2199: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2200: ----Yao Zhang add begin for bug#8404856
2201: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2202: l_valid_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2203: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2204: ----Yao Zhang add end for bug#8404856
2205:
2206: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
2207: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;

Line 2211: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;

2207: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2208: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2209: l_error_string VARCHAR2(500);
2210:
2211: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2212: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2213: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2214: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2215: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;

Line 2212: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;

2208: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2209: l_error_string VARCHAR2(500);
2210:
2211: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2212: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2213: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2214: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2215: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2216: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;

Line 2222: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;

2218: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2219: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2220: l_bank_name HZ_PARTIES.party_name%TYPE;
2221: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2222: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2223:
2224: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;
2225:
2226:

Line 2286: ra_customer_trx_all h

2282: , l_bill_to_customer_id
2283: , l_bill_to_site_use_id
2284: --Yao Zhang add end for bug#8404856
2285: FROM
2286: ra_customer_trx_all h
2287:
2288: WHERE h.customer_trx_id = p_customer_trx_id ;
2289: EXCEPTION
2290: WHEN no_data_found THEN

Line 2554: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;

2550: )
2551: IS
2552: l_procedure_name VARCHAR2(30) := 'Get_CM_Bank_Info';
2553:
2554: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2555: --Yao Zhang add begin for bug#8404856
2556: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2557: l_valid_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2558: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;

Line 2556: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;

2552: l_procedure_name VARCHAR2(30) := 'Get_CM_Bank_Info';
2553:
2554: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2555: --Yao Zhang add begin for bug#8404856
2556: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2557: l_valid_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2558: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2559: --Yao Zhang add end for bug#8404856
2560: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;

Line 2557: l_valid_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;

2553:
2554: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2555: --Yao Zhang add begin for bug#8404856
2556: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2557: l_valid_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2558: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2559: --Yao Zhang add end for bug#8404856
2560: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
2561: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;

Line 2558: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;

2554: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2555: --Yao Zhang add begin for bug#8404856
2556: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2557: l_valid_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2558: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2559: --Yao Zhang add end for bug#8404856
2560: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
2561: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2562: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;

Line 2565: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;

2561: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2562: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2563: l_error_string VARCHAR2(500);
2564:
2565: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2566: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2567: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2568: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2569: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;

Line 2566: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;

2562: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2563: l_error_string VARCHAR2(500);
2564:
2565: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2566: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2567: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2568: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2569: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2570: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;

Line 2576: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;

2572: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2573: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2574: l_bank_name HZ_PARTIES.party_name%TYPE;
2575: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2576: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2577: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;
2578:
2579: l_ori_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2580: l_ori_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;

Line 2579: l_ori_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;

2575: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2576: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2577: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;
2578:
2579: l_ori_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2580: l_ori_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2581: l_ori_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2582: l_ori_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2583:

Line 2580: l_ori_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;

2576: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2577: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;
2578:
2579: l_ori_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2580: l_ori_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2581: l_ori_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2582: l_ori_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2583:
2584: BEGIN

Line 2582: l_ori_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;

2578:
2579: l_ori_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2580: l_ori_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2581: l_ori_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2582: l_ori_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2583:
2584: BEGIN
2585: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2586: THEN

Line 2642: ra_customer_trx_all h

2638: ,l_bill_to_customer_id
2639: ,l_bill_to_site_use_id
2640: --Yao Zhang add end for bug#8404856
2641: FROM
2642: ra_customer_trx_all h
2643: WHERE h.customer_trx_id = p_customer_trx_id ;
2644: EXCEPTION
2645: WHEN no_data_found THEN
2646: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 2748: ra_customer_trx_all h

2744: l_ori_paying_customer_id
2745: , l_ori_paying_site_use_id
2746: , l_ori_trxn_extension_id
2747: FROM
2748: ra_customer_trx_all h
2749:
2750: WHERE h.customer_trx_id = p_original_trx_id ;
2751: EXCEPTION
2752: WHEN no_data_found THEN

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

3004: IS
3005: l_tax_line_count NUMBER;
3006: l_procedure_name VARCHAR2(50) := 'verify_tax_line';
3007: l_tax_line_id zx_lines.tax_line_id%TYPE;
3008: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--jogen bug5212702 May-17,2006
3009:
3010: BEGIN
3011:
3012: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 3518: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;

3514: , x_tp_tax_registration_number OUT NOCOPY VARCHAR2
3515: )
3516: IS
3517: l_procedure_name VARCHAR2(80) := 'get_tp_tax_registration_number';
3518: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
3519: l_ra_cust_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
3520: l_tax_regime_code zx_lines.tax_regime_code%TYPE;
3521: l_tax zx_lines.tax%TYPE;
3522: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;

Line 3519: l_ra_cust_trx_id ra_customer_trx_all.customer_trx_id%TYPE;

3515: )
3516: IS
3517: l_procedure_name VARCHAR2(80) := 'get_tp_tax_registration_number';
3518: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
3519: l_ra_cust_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
3520: l_tax_regime_code zx_lines.tax_regime_code%TYPE;
3521: l_tax zx_lines.tax%TYPE;
3522: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
3523: l_tax_determine_date zx_lines.tax_determine_date%TYPE;

Line 3599: ra_customer_trx_all trx_header

3595: bill_to_site_use_id
3596: INTO
3597: l_bill_to_site_use_id
3598: FROM
3599: ra_customer_trx_all trx_header
3600: WHERE trx_header.customer_trx_id = p_trx_id;
3601:
3602: -- get cust_acct_site_id by site_use_id
3603: SELECT

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

3946: l_tax_rate NUMBER;
3947: l_gt_currency_code fnd_currencies.currency_code%TYPE;
3948: l_tax_line_id zx_lines.tax_line_id%TYPE;
3949: l_tp_tax_registration_number zx_registrations.registration_number%TYPE;
3950: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006
3951:
3952:
3953: CURSOR c_tax_type_code
3954: IS

Line 4451: FROM RA_CUSTOMER_TRX_ALL RCT

4447: -- all GTA invoices whose AR transaction type is not associated to invoice type
4448: CURSOR c_inv_trx_type_no_inv_type
4449: IS
4450: SELECT JGTH.GTA_TRX_NUMBER, SOURCE
4451: FROM RA_CUSTOMER_TRX_ALL RCT
4452: , AR_GTA_TRX_HEADERS_ALL JGTH
4453: WHERE invoice_type is null
4454: AND JGTH.ORG_ID = p_org_id
4455: AND RCT.CUSTOMER_TRX_ID(+) = JGTH.Ra_Trx_Id

Line 4469: FROM RA_CUSTOMER_TRX_ALL RCT

4465: -- but tax rate and amount is not zero.
4466: CURSOR c_recycle_tax_amount_not_zero
4467: IS
4468: SELECT JGTH.GTA_TRX_NUMBER, SOURCE
4469: FROM RA_CUSTOMER_TRX_ALL RCT
4470: , AR_GTA_TRX_HEADERS_ALL JGTH
4471: WHERE invoice_type is null
4472: AND JGTH.ORG_ID = p_org_id
4473: AND RCT.CUSTOMER_TRX_ID(+) = JGTH.Ra_Trx_Id

Line 4486: FROM RA_CUSTOMER_TRX_ALL RCT,

4482: -- credit memo whose invoice type is different with invoice type of original transaction
4483: CURSOR c_cm_inv_type_different
4484: IS
4485: SELECT JGTH.GTA_TRX_NUMBER, SOURCE
4486: FROM RA_CUSTOMER_TRX_ALL RCT,
4487: RA_CUST_TRX_TYPES_ALL RCTT,
4488: AR_GTA_TRX_HEADERS_ALL JGTH
4489: WHERE invoice_type is not null
4490: AND JGTH.ORG_ID = p_org_id

Line 4551: FROM RA_CUSTOMER_TRX_ALL RCT

4547: EXIT WHEN c_all_inv_updated%NOTFOUND;
4548: BEGIN
4549: SELECT JGTL.invoice_type
4550: INTO l_invoice_type
4551: FROM RA_CUSTOMER_TRX_ALL RCT
4552: ,ar_gta_tax_limits_all JGTL
4553: WHERE RCT.CUSTOMER_TRX_ID = l_ra_trx_id
4554: AND JGTL.ORG_ID = l_org_id
4555: AND JGTL.FP_TAX_REGISTRATION_NUMBER = l_fp_tax_registration_number

Line 4583: ,RA_CUSTOMER_TRX_ALL RCT

4579: BEGIN
4580: SELECT RCTT.TYPE
4581: INTO l_ar_trx_type
4582: FROM RA_CUST_TRX_TYPES_ALL RCTT
4583: ,RA_CUSTOMER_TRX_ALL RCT
4584: ,AR_GTA_TRX_HEADERS_ALL JGTH
4585: WHERE JGTH.GTA_TRX_HEADER_ID = l_gta_trx_header_id
4586: AND RCT.CUSTOMER_TRX_ID(+) = JGTH.Ra_Trx_Id
4587: AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID(+)

Line 4606: ,RA_CUSTOMER_TRX_ALL RCT

4602: BEGIN
4603: SELECT DISTINCT JGTH.invoice_type
4604: INTO l_pre_trx_invoice_type
4605: FROM AR_GTA_TRX_HEADERS_ALL JGTH
4606: ,RA_CUSTOMER_TRX_ALL RCT
4607: WHERE RCT.CUSTOMER_TRX_ID(+) = l_ra_trx_id
4608: AND JGTH.RA_TRX_id = RCT.previous_customer_trx_id;
4609: EXCEPTION
4610: WHEN no_data_found THEN

Line 4632: FROM RA_CUSTOMER_TRX_ALL RCT,

4628:
4629: -- initialize invoice type for GTA invoices
4630: UPDATE AR_GTA_TRX_HEADERS_ALL JGTH
4631: SET invoice_type = (SELECT JGTL.invoice_type
4632: FROM RA_CUSTOMER_TRX_ALL RCT,
4633: ar_gta_tax_limits_all JGTL
4634: WHERE RCT.CUSTOMER_TRX_ID = JGTH.Ra_Trx_Id
4635: AND JGTL.ORG_ID = JGTH.Org_Id
4636: AND JGTL.FP_TAX_REGISTRATION_NUMBER =