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.ZX_PRODUCT_INTEGRATION_PKG dependencies on AR_VAT_TAX

Line 25: pg_tax_rate_passed ar_vat_tax.tax_rate%TYPE;

21: pg_cm_type VARCHAR2(15);
22: pg_bad_lines NUMBER;
23:
24: -- global variables for arp_tax_calculate
25: pg_tax_rate_passed ar_vat_tax.tax_rate%TYPE;
26: pg_adhoc_tax_code VARCHAR2(1);
27:
28: TYPE tax_line_rec_type is RECORD (
29: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,

Line 2541: FROM ar_vat_tax_all_b

2537: tax_info_rec.tax_calculation_plsql_block, --l_tax_calculation_plsql_block,
2538: tax_info_rec.userf7, --l_tax_type,
2539: tax_info_rec.usern2, --l_vat_tax_id,
2540: tax_info_rec.usern1 --l_tax_category_id
2541: FROM ar_vat_tax_all_b
2542: WHERE set_of_books_id = sysinfo.sysparam.SET_OF_BOOKS_ID
2543: AND tax_code = tax_info_rec.tax_code
2544: AND tax_info_rec.trx_date BETWEEN start_date
2545: AND NVL(end_date, TO_DATE( '31122199', 'DD

Line 2975: FROM ar_vat_tax_all_b

2971: decode(tax_type,
2972: 'LOCATION', TAX_TYPE_LOCATION,
2973: 'SALES_TAX', TAX_TYPE_SALES,
2974: TAX_TYPE_VAT ) tax_type
2975: FROM ar_vat_tax_all_b
2976: WHERE set_of_books_id = c_sob_id
2977: AND tax_code = c_tax_code
2978: AND c_trx_date between start_date and nvl(end_date, c_trx_end_date)
2979: AND nvl(enabled_flag,'Y') = 'Y'

Line 3728: l_taxable_basis ar_vat_tax.taxable_basis%type;

3724: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
3725: l_tax_rule_set ar_system_parameters.global_attribute13%type;
3726: l_location_id hr_locations_all.location_id%type;
3727: l_org_class hr_locations_all.global_attribute1%type;
3728: l_taxable_basis ar_vat_tax.taxable_basis%type;
3729: l_tax_calculation_plsql_block
3730: ar_vat_tax.tax_calculation_plsql_block%type;
3731: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
3732: l_tax_type ar_vat_tax.tax_type%type;

Line 3730: ar_vat_tax.tax_calculation_plsql_block%type;

3726: l_location_id hr_locations_all.location_id%type;
3727: l_org_class hr_locations_all.global_attribute1%type;
3728: l_taxable_basis ar_vat_tax.taxable_basis%type;
3729: l_tax_calculation_plsql_block
3730: ar_vat_tax.tax_calculation_plsql_block%type;
3731: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
3732: l_tax_type ar_vat_tax.tax_type%type;
3733: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
3734: l_tax_category_id ar_vat_tax.global_attribute1%type;

Line 3732: l_tax_type ar_vat_tax.tax_type%type;

3728: l_taxable_basis ar_vat_tax.taxable_basis%type;
3729: l_tax_calculation_plsql_block
3730: ar_vat_tax.tax_calculation_plsql_block%type;
3731: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
3732: l_tax_type ar_vat_tax.tax_type%type;
3733: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
3734: l_tax_category_id ar_vat_tax.global_attribute1%type;
3735: l_global_attribute5 mtl_system_items.global_attribute1%type;
3736: l_global_attribute6 mtl_system_items.global_attribute2%type;

Line 3733: l_vat_tax_id ar_vat_tax.vat_tax_id%type;

3729: l_tax_calculation_plsql_block
3730: ar_vat_tax.tax_calculation_plsql_block%type;
3731: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
3732: l_tax_type ar_vat_tax.tax_type%type;
3733: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
3734: l_tax_category_id ar_vat_tax.global_attribute1%type;
3735: l_global_attribute5 mtl_system_items.global_attribute1%type;
3736: l_global_attribute6 mtl_system_items.global_attribute2%type;
3737: l_tax_classification_code ar_vat_tax_all_b.tax_code%type;

Line 3734: l_tax_category_id ar_vat_tax.global_attribute1%type;

3730: ar_vat_tax.tax_calculation_plsql_block%type;
3731: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
3732: l_tax_type ar_vat_tax.tax_type%type;
3733: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
3734: l_tax_category_id ar_vat_tax.global_attribute1%type;
3735: l_global_attribute5 mtl_system_items.global_attribute1%type;
3736: l_global_attribute6 mtl_system_items.global_attribute2%type;
3737: l_tax_classification_code ar_vat_tax_all_b.tax_code%type;
3738:

Line 3737: l_tax_classification_code ar_vat_tax_all_b.tax_code%type;

3733: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
3734: l_tax_category_id ar_vat_tax.global_attribute1%type;
3735: l_global_attribute5 mtl_system_items.global_attribute1%type;
3736: l_global_attribute6 mtl_system_items.global_attribute2%type;
3737: l_tax_classification_code ar_vat_tax_all_b.tax_code%type;
3738:
3739:
3740: BEGIN
3741:

Line 3959: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Getting attributes from AR_VAT_TAX_ALL for tax_code: '||

3955:
3956: tax_info_rec.tax_code := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_index);
3957:
3958: IF (g_level_statement >= g_current_runtime_level) THEN
3959: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Getting attributes from AR_VAT_TAX_ALL for tax_code: '||
3960: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_index));
3961: END IF;
3962:
3963: -- Fetch AR_VAT_TAX details when tax_code is not NULL

Line 3963: -- Fetch AR_VAT_TAX details when tax_code is not NULL

3959: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Getting attributes from AR_VAT_TAX_ALL for tax_code: '||
3960: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_index));
3961: END IF;
3962:
3963: -- Fetch AR_VAT_TAX details when tax_code is not NULL
3964: l_taxable_basis := NULL;
3965: l_tax_calculation_plsql_block := NULL;
3966: l_tax_type := NULL;
3967: l_vat_tax_id := NULL;

Line 3995: FROM ar_vat_tax_all_b

3991: l_tax_calculation_plsql_block,
3992: l_tax_type,
3993: l_vat_tax_id,
3994: l_tax_category_id
3995: FROM ar_vat_tax_all_b
3996: WHERE set_of_books_id = l_set_of_books_id
3997: AND tax_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_index)
3998: AND tax_info_rec.trx_date BETWEEN start_date
3999: AND NVL(end_date, TO_DATE( '31122199', 'DDMMYYYY'))

Line 5844: FROM ar_vat_tax

5840: CURSOR sel_vat_tax_rate IS
5841: SELECT vat_tax_id, tax_rate,
5842: TAX_TYPE_VAT,
5843: nvl(validate_flag, 'N')
5844: FROM ar_vat_tax
5845: WHERE tax_code = tax_info_rec.tax_code
5846: AND set_of_books_id = sysinfo.sysparam.set_of_books_id
5847: AND trunc(tax_info_rec.trx_date) between start_date and
5848: nvl(end_date, trunc(tax_info_rec.trx_date))

Line 5857: FROM ar_vat_tax

5853: CURSOR sel_vat_tax_code_count IS
5854: SELECT 1
5855: FROM DUAL
5856: WHERE EXISTS ( SELECT tax_code
5857: FROM ar_vat_tax
5858: WHERE tax_code = tax_info_rec.tax_code
5859: AND set_of_books_id = sysinfo.sysparam.set_of_books_id
5860: AND nvl(enabled_flag, 'Y') = 'Y'
5861: AND nvl(tax_class, 'O') = 'O');