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_REPORTS_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 2119: l_ar_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;

2115: :=p_org_id;
2116: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE
2117: :=p_ar_header_id;
2118: l_has_difference BOOLEAN;
2119: l_ar_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2120: l_ar_line_number ra_customer_trx_lines_all.line_number%TYPE;
2121: l_ar_goods_description ra_customer_trx_lines_all.description%TYPE;
2122: l_ar_line_amount NUMBER;
2123: l_ar_line_amount_disp VARCHAR2(50);

Line 2120: l_ar_line_number ra_customer_trx_lines_all.line_number%TYPE;

2116: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE
2117: :=p_ar_header_id;
2118: l_has_difference BOOLEAN;
2119: l_ar_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2120: l_ar_line_number ra_customer_trx_lines_all.line_number%TYPE;
2121: l_ar_goods_description ra_customer_trx_lines_all.description%TYPE;
2122: l_ar_line_amount NUMBER;
2123: l_ar_line_amount_disp VARCHAR2(50);
2124: l_ar_vat_line_tax NUMBER;

Line 2121: l_ar_goods_description ra_customer_trx_lines_all.description%TYPE;

2117: :=p_ar_header_id;
2118: l_has_difference BOOLEAN;
2119: l_ar_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2120: l_ar_line_number ra_customer_trx_lines_all.line_number%TYPE;
2121: l_ar_goods_description ra_customer_trx_lines_all.description%TYPE;
2122: l_ar_line_amount NUMBER;
2123: l_ar_line_amount_disp VARCHAR2(50);
2124: l_ar_vat_line_tax NUMBER;
2125: l_ar_vat_line_tax_disp VARCHAR2(50);

Line 2130: l_ar_uom ra_customer_trx_lines_all.uom_code%TYPE;

2126: l_ar_vat_tax_rate NUMBER;
2127: l_ar_quantity NUMBER;
2128: l_ar_unit_price NUMBER;
2129: l_ar_unit_price_disp VARCHAR2(50);
2130: l_ar_uom ra_customer_trx_lines_all.uom_code%TYPE;
2131: l_ar_tax_reg_number zx_registrations.registration_number%TYPE;
2132: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;
2133: l_gta_line_number ar_gta_trx_lines_all.line_number%TYPE;
2134: l_gta_goods_description ra_customer_trx_lines_all.description%TYPE;

Line 2134: l_gta_goods_description ra_customer_trx_lines_all.description%TYPE;

2130: l_ar_uom ra_customer_trx_lines_all.uom_code%TYPE;
2131: l_ar_tax_reg_number zx_registrations.registration_number%TYPE;
2132: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;
2133: l_gta_line_number ar_gta_trx_lines_all.line_number%TYPE;
2134: l_gta_goods_description ra_customer_trx_lines_all.description%TYPE;
2135: l_gta_line_amount NUMBER;
2136: l_gta_vat_line_tax NUMBER;
2137: l_gta_vat_tax_rate NUMBER;
2138: l_gta_quantity NUMBER;

Line 2141: l_gta_uom ra_customer_trx_lines_all.uom_code%TYPE;

2137: l_gta_vat_tax_rate NUMBER;
2138: l_gta_quantity NUMBER;
2139: l_gta_unit_price NUMBER;
2140: l_gta_unit_price_disp VARCHAR2(50);
2141: l_gta_uom ra_customer_trx_lines_all.uom_code%TYPE;
2142: l_gta_line_amount_sum NUMBER;
2143: l_gta_line_amount_sum_disp VARCHAR2(50);
2144: l_gta_line_taxamount_sum NUMBER;
2145: l_gta_line_taxamount_sum_disp VARCHAR2(50);

Line 2184: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;

2180: l_tax_type_code zx_lines.tax_type_code%TYPE;
2181: l_gt_currency_code fnd_currencies.currency_code%TYPE;
2182: l_no_value VARCHAR2(1):='-';
2183: --------------------------------------
2184: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2185: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2186: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2187: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2188: l_ar_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;

Line 2185: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;

2181: l_gt_currency_code fnd_currencies.currency_code%TYPE;
2182: l_no_value VARCHAR2(1):='-';
2183: --------------------------------------
2184: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2185: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2186: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2187: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2188: l_ar_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2189: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;

Line 2186: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;

2182: l_no_value VARCHAR2(1):='-';
2183: --------------------------------------
2184: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2185: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2186: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2187: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2188: l_ar_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2189: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2190: l_discount_amount ar_gta_trx_lines_all.discount_amount%TYPE;

Line 2187: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;

2183: --------------------------------------
2184: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2185: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2186: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2187: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2188: l_ar_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2189: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2190: l_discount_amount ar_gta_trx_lines_all.discount_amount%TYPE;
2191: l_discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE;

Line 2188: l_ar_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;

2184: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2185: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2186: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2187: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2188: l_ar_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2189: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2190: l_discount_amount ar_gta_trx_lines_all.discount_amount%TYPE;
2191: l_discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE;
2192: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;

Line 2192: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;

2188: l_ar_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2189: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2190: l_discount_amount ar_gta_trx_lines_all.discount_amount%TYPE;
2191: l_discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE;
2192: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2193:
2194:
2195: CURSOR c_ar_lines IS
2196: SELECT

Line 2532: FROM ra_customer_trx_lines_all rctl

2528: --calculate discount amount
2529: SELECT rctl.revenue_amount + nvl(l_discount_amount, 0),
2530: rctl.customer_trx_line_id
2531: INTO l_discount_amount, l_discount_cust_trx_line_id
2532: FROM ra_customer_trx_lines_all rctl
2533: WHERE rctl.customer_trx_id = l_ar_header_id
2534: AND rctl.line_type = 'LINE'
2535: AND rctl.interface_line_attribute11 =
2536: l_discount_adjustment_id;