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.JL_ZZ_TAX dependencies on FND_NUMBER

Line 2356: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))

2352: SELECT tc1.tax_category_id tax_category_id
2353: ,tc1.threshold_check_grp_by grp_attr_name
2354: ,tcl1.tax_attribute_value grp_attr_value
2355: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2356: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2357: charged_tax
2358: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2359: calculated_tax
2360: ,rl1.customer_trx_line_id inv_line_number

Line 2358: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))

2354: ,tcl1.tax_attribute_value grp_attr_value
2355: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2356: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2357: charged_tax
2358: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2359: calculated_tax
2360: ,rl1.customer_trx_line_id inv_line_number
2361: ,r1.customer_trx_id header_trx_id
2362: FROM ra_customer_trx r1

Line 2389: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))

2385: SELECT tc1.tax_category_id tax_category_id
2386: ,tc1.threshold_check_grp_by grp_attr_name
2387: ,tcl1.tax_attribute_value grp_attr_value
2388: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2389: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2390: charged_tax
2391: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2392: calculated_tax
2393: ,rl1.customer_trx_line_id inv_line_number

Line 2391: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))

2387: ,tcl1.tax_attribute_value grp_attr_value
2388: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2389: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2390: charged_tax
2391: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2392: calculated_tax
2393: ,rl1.customer_trx_line_id inv_line_number
2394: ,r1.customer_trx_id header_trx_id
2395: FROM ra_customer_trx r1

Line 2422: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))

2418: SELECT tc1.tax_category_id tax_category_id
2419: ,tc1.threshold_check_grp_by grp_attr_name
2420: ,tcl1.tax_attribute_value grp_attr_value
2421: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2422: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2423: charged_tax
2424: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2425: calculated_tax
2426: ,rl1.customer_trx_line_id inv_line_number

Line 2424: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))

2420: ,tcl1.tax_attribute_value grp_attr_value
2421: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2422: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2423: charged_tax
2424: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2425: calculated_tax
2426: ,rl1.customer_trx_line_id inv_line_number
2427: ,r1.customer_trx_id header_trx_id
2428: FROM ra_customer_trx r1

Line 2455: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))

2451: SELECT tc1.tax_category_id tax_category_id
2452: ,tc1.threshold_check_grp_by grp_attr_name
2453: ,tcl1.tax_attribute_value grp_attr_value
2454: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2455: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2456: charged_tax
2457: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2458: calculated_tax
2459: ,rl1.customer_trx_line_id inv_line_number

Line 2457: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))

2453: ,tcl1.tax_attribute_value grp_attr_value
2454: ,nvl(rlt1.taxable_amount,0) appl_prior_base
2455: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute19,0))
2456: charged_tax
2457: ,fnd_number.canonical_to_number(nvl(rlt1.global_attribute20,0))
2458: calculated_tax
2459: ,rl1.customer_trx_line_id inv_line_number
2460: ,r1.customer_trx_id header_trx_id
2461: FROM ra_customer_trx r1

Line 4194: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines

4190: -- set the default global attributes for the tax lines
4191: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute2 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf2;
4192: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute3 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9;
4193:
4194: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4195: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=
4196: fnd_number.number_to_canonical (v_base_amount);
4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4198: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);

Line 4196: fnd_number.number_to_canonical (v_base_amount);

4192: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute3 := ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9;
4193:
4194: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4195: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=
4196: fnd_number.number_to_canonical (v_base_amount);
4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4198: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4199:
4200: -- Added following 2 lines to take care of bug# 660025

Line 4198: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);

4194: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4195: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute11 :=
4196: fnd_number.number_to_canonical (v_base_amount);
4197: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute12 :=
4198: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern3);
4199:
4200: -- Added following 2 lines to take care of bug# 660025
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := null;
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := null;

Line 4203: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines

4199:
4200: -- Added following 2 lines to take care of bug# 660025
4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := null;
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := null;
4203: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4205: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);
4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=
4207: fnd_number.number_to_canonical( v_calculated_tax_amount);

Line 4205: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);

4201: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute8 := null;
4202: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute9 := null;
4203: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4205: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);
4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=
4207: fnd_number.number_to_canonical( v_calculated_tax_amount);
4208:
4209: -- Added following 1 line to take care of bug# 787259

Line 4207: fnd_number.number_to_canonical( v_calculated_tax_amount);

4203: -- Bugfix 1062149 fnd_number.number_to_canonical added in following lines
4204: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute19 :=
4205: fnd_number.number_to_canonical(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_amount);
4206: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.global_attribute20 :=
4207: fnd_number.number_to_canonical( v_calculated_tax_amount);
4208:
4209: -- Added following 1 line to take care of bug# 787259
4210: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_amount := v_base_amount;
4211: END IF;