DBA Data[Home] [Help]

APPS.AR_GTA_ARTRX_PROC dependencies on AR_GTA_TRX_LINES_ALL

Line 2163: l_discount_amount ar_gta_trx_lines_all.discount_amount%TYPE;

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
2161:
2162: --Yao Zhang Add for bug#8605196 to support discount line
2163: l_discount_amount ar_gta_trx_lines_all.discount_amount%TYPE;
2164: l_discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE;
2165: l_discount_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2166: l_discount_tax_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2167: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;

Line 2164: l_discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE;

2160: l_master_org HR_ORGANIZATION_UNITS.organization_id%TYPE; --yao zhang add for bug 7721035
2161:
2162: --Yao Zhang Add for bug#8605196 to support discount line
2163: l_discount_amount ar_gta_trx_lines_all.discount_amount%TYPE;
2164: l_discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE;
2165: l_discount_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2166: l_discount_tax_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2167: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2168: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;

Line 2165: l_discount_rate ar_gta_trx_lines_all.discount_rate%TYPE;

2161:
2162: --Yao Zhang Add for bug#8605196 to support discount line
2163: l_discount_amount ar_gta_trx_lines_all.discount_amount%TYPE;
2164: l_discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE;
2165: l_discount_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2166: l_discount_tax_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2167: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2168: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2169: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;

Line 2166: l_discount_tax_rate ar_gta_trx_lines_all.discount_rate%TYPE;

2162: --Yao Zhang Add for bug#8605196 to support discount line
2163: l_discount_amount ar_gta_trx_lines_all.discount_amount%TYPE;
2164: l_discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE;
2165: l_discount_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2166: l_discount_tax_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2167: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2168: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2169: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2170: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;

Line 2173: l_discount_flag ar_gta_trx_lines_all.discount_flag%TYPE;

2169: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2170: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2171: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2172: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2173: l_discount_flag ar_gta_trx_lines_all.discount_flag%TYPE;
2174: l_tax_amount ar_gta_trx_lines_all.tax_amount%TYPE;
2175: l_discount_amount_func_curr ar_gta_trx_lines_all.discount_amount%TYPE; --Yao add for bug#9132371
2176: -- Yao Modified for bug#8605196 to support discount line
2177: l_actual_unit_price NUMBER; --yao add for bug 9045187

Line 2174: l_tax_amount ar_gta_trx_lines_all.tax_amount%TYPE;

2170: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2171: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2172: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2173: l_discount_flag ar_gta_trx_lines_all.discount_flag%TYPE;
2174: l_tax_amount ar_gta_trx_lines_all.tax_amount%TYPE;
2175: l_discount_amount_func_curr ar_gta_trx_lines_all.discount_amount%TYPE; --Yao add for bug#9132371
2176: -- Yao Modified for bug#8605196 to support discount line
2177: l_actual_unit_price NUMBER; --yao add for bug 9045187
2178: l_discount_on_invoice VARCHAR2(1); --Yao add for bug#9830678

Line 2175: l_discount_amount_func_curr ar_gta_trx_lines_all.discount_amount%TYPE; --Yao add for bug#9132371

2171: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2172: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2173: l_discount_flag ar_gta_trx_lines_all.discount_flag%TYPE;
2174: l_tax_amount ar_gta_trx_lines_all.tax_amount%TYPE;
2175: l_discount_amount_func_curr ar_gta_trx_lines_all.discount_amount%TYPE; --Yao add for bug#9132371
2176: -- Yao Modified for bug#8605196 to support discount line
2177: l_actual_unit_price NUMBER; --yao add for bug 9045187
2178: l_discount_on_invoice VARCHAR2(1); --Yao add for bug#9830678
2179: