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_ARTRX_PROC dependencies on ZX_LINES

Line 2141: l_tax_amount_func_curr zx_lines.tax_amt_funcl_curr%TYPE;

2137: l_tax_line_count NUMBER;
2138: l_legal_entity_id ra_customer_trx_all.legal_entity_id%TYPE;
2139:
2140: -- the data get from ebtax
2141: l_tax_amount_func_curr zx_lines.tax_amt_funcl_curr%TYPE;
2142: l_taxable_amount_func_curr zx_lines.taxable_amt_funcl_curr%TYPE;
2143: l_line_quantity zx_lines.trx_line_quantity%TYPE;
2144: l_tax_rate zx_lines.tax_rate%TYPE;
2145: l_unit_price zx_lines.unit_price%TYPE;

Line 2142: l_taxable_amount_func_curr zx_lines.taxable_amt_funcl_curr%TYPE;

2138: l_legal_entity_id ra_customer_trx_all.legal_entity_id%TYPE;
2139:
2140: -- the data get from ebtax
2141: l_tax_amount_func_curr zx_lines.tax_amt_funcl_curr%TYPE;
2142: l_taxable_amount_func_curr zx_lines.taxable_amt_funcl_curr%TYPE;
2143: l_line_quantity zx_lines.trx_line_quantity%TYPE;
2144: l_tax_rate zx_lines.tax_rate%TYPE;
2145: l_unit_price zx_lines.unit_price%TYPE;
2146: l_fp_registration_number zx_lines.tax_registration_number%TYPE;

Line 2143: l_line_quantity zx_lines.trx_line_quantity%TYPE;

2139:
2140: -- the data get from ebtax
2141: l_tax_amount_func_curr zx_lines.tax_amt_funcl_curr%TYPE;
2142: l_taxable_amount_func_curr zx_lines.taxable_amt_funcl_curr%TYPE;
2143: l_line_quantity zx_lines.trx_line_quantity%TYPE;
2144: l_tax_rate zx_lines.tax_rate%TYPE;
2145: l_unit_price zx_lines.unit_price%TYPE;
2146: l_fp_registration_number zx_lines.tax_registration_number%TYPE;
2147: l_tp_registration_number zx_lines.tax_registration_number%TYPE;

Line 2144: l_tax_rate zx_lines.tax_rate%TYPE;

2140: -- the data get from ebtax
2141: l_tax_amount_func_curr zx_lines.tax_amt_funcl_curr%TYPE;
2142: l_taxable_amount_func_curr zx_lines.taxable_amt_funcl_curr%TYPE;
2143: l_line_quantity zx_lines.trx_line_quantity%TYPE;
2144: l_tax_rate zx_lines.tax_rate%TYPE;
2145: l_unit_price zx_lines.unit_price%TYPE;
2146: l_fp_registration_number zx_lines.tax_registration_number%TYPE;
2147: l_tp_registration_number zx_lines.tax_registration_number%TYPE;
2148:

Line 2145: l_unit_price zx_lines.unit_price%TYPE;

2141: l_tax_amount_func_curr zx_lines.tax_amt_funcl_curr%TYPE;
2142: l_taxable_amount_func_curr zx_lines.taxable_amt_funcl_curr%TYPE;
2143: l_line_quantity zx_lines.trx_line_quantity%TYPE;
2144: l_tax_rate zx_lines.tax_rate%TYPE;
2145: l_unit_price zx_lines.unit_price%TYPE;
2146: l_fp_registration_number zx_lines.tax_registration_number%TYPE;
2147: l_tp_registration_number zx_lines.tax_registration_number%TYPE;
2148:
2149: -- for get the error message from get_info_from_ebtax

Line 2146: l_fp_registration_number zx_lines.tax_registration_number%TYPE;

2142: l_taxable_amount_func_curr zx_lines.taxable_amt_funcl_curr%TYPE;
2143: l_line_quantity zx_lines.trx_line_quantity%TYPE;
2144: l_tax_rate zx_lines.tax_rate%TYPE;
2145: l_unit_price zx_lines.unit_price%TYPE;
2146: l_fp_registration_number zx_lines.tax_registration_number%TYPE;
2147: l_tp_registration_number zx_lines.tax_registration_number%TYPE;
2148:
2149: -- for get the error message from get_info_from_ebtax
2150: l_status NUMBER;

Line 2147: l_tp_registration_number zx_lines.tax_registration_number%TYPE;

2143: l_line_quantity zx_lines.trx_line_quantity%TYPE;
2144: l_tax_rate zx_lines.tax_rate%TYPE;
2145: l_unit_price zx_lines.unit_price%TYPE;
2146: l_fp_registration_number zx_lines.tax_registration_number%TYPE;
2147: l_tp_registration_number zx_lines.tax_registration_number%TYPE;
2148:
2149: -- for get the error message from get_info_from_ebtax
2150: l_status NUMBER;
2151: l_proce_error_buffer VARCHAR2(180);

Line 2154: l_tp_regi_number_first zx_lines.tax_registration_number%TYPE;

2150: l_status NUMBER;
2151: l_proce_error_buffer VARCHAR2(180);
2152:
2153: -- for check the third party tax registration number
2154: l_tp_regi_number_first zx_lines.tax_registration_number%TYPE;
2155: l_trx_line_index NUMBER;
2156: l_tp_regi_number zx_lines.tax_registration_number%TYPE;
2157: l_trx_typ ra_cust_trx_types_all.name%TYPE; --added by subba
2158: l_cm_desc1 varchar2(50); --added by Yao Zhang for bug 7685610

Line 2156: l_tp_regi_number zx_lines.tax_registration_number%TYPE;

2152:
2153: -- for check the third party tax registration number
2154: l_tp_regi_number_first zx_lines.tax_registration_number%TYPE;
2155: l_trx_line_index NUMBER;
2156: l_tp_regi_number zx_lines.tax_registration_number%TYPE;
2157: l_trx_typ ra_cust_trx_types_all.name%TYPE; --added by subba
2158: l_cm_desc1 varchar2(50); --added by Yao Zhang for bug 7685610
2159: l_cm_desc2 varchar2(50); --added by Yao Zhang for bug 7685610
2160: l_master_org HR_ORGANIZATION_UNITS.organization_id%TYPE; --yao zhang add for bug 7721035

Line 2941: FROM ra_customer_trx_lines_all rctl, zx_lines tax

2937: rctl.customer_trx_line_id
2938: INTO l_discount_amount,
2939: l_discount_amount_func_curr,
2940: l_discount_cust_trx_line_id
2941: FROM ra_customer_trx_lines_all rctl, zx_lines tax
2942: WHERE rctl.customer_trx_id = l_customer_trx_id
2943: AND rctl.line_type = 'LINE'
2944: AND rctl.interface_line_attribute11 =
2945: l_discount_adjustment_id

Line 2959: FROM zx_lines tax

2955: --Calculate the tax discount amount
2956: SELECT tax.tax_amt_tax_curr +
2957: nvl(l_discount_tax_amount, 0)
2958: INTO l_discount_tax_amount
2959: FROM zx_lines tax
2960: WHERE tax.trx_line_id = l_discount_cust_trx_line_id
2961: AND tax.entity_code = 'TRANSACTIONS'
2962: AND tax.application_id = 222
2963: AND tax.trx_level_type = 'LINE'

Line 2987: FROM zx_lines tax

2983: CLOSE c_discount_lines;
2984: --Get tax amount
2985: SELECT tax.tax_amt_tax_curr + nvl(l_tax_amount, 0)
2986: INTO l_tax_amount
2987: FROM zx_lines tax
2988: WHERE tax.trx_line_id = l_customer_trx_line_id
2989: AND tax.entity_code = 'TRANSACTIONS'
2990: AND application_id = 222
2991: AND tax.trx_level_type = 'LINE'