APPS.ARP_CT_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 5440: FROM ra_customer_trx_lines

5436: SELECT customer_trx_line_id,
5437: inventory_item_id,
5438: memo_line_id,
5439: warehouse_id
5440: FROM ra_customer_trx_lines
5441: WHERE customer_trx_id = p_customer_trx_id
5442: AND line_type = 'LINE';--3872371
5443:
5444: l_tax_code VARCHAR2(50);

Line 5449: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

5445: l_vat_tax_id NUMBER ;
5446: l_organization_id NUMBER ;
5447: l_warehouse_id NUMBER;
5448: l_sob_id NUMBER;
5449: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
5450: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;
5451: l_autotax ra_customer_trx_lines.autotax%type;
5452: l_amt_incl_tax_flag ar_vat_tax.amount_includes_tax_flag%type;
5453: l_amt_incl_tax_override ar_vat_tax.amount_includes_tax_override%type;

Line 5450: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;

5446: l_organization_id NUMBER ;
5447: l_warehouse_id NUMBER;
5448: l_sob_id NUMBER;
5449: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
5450: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;
5451: l_autotax ra_customer_trx_lines.autotax%type;
5452: l_amt_incl_tax_flag ar_vat_tax.amount_includes_tax_flag%type;
5453: l_amt_incl_tax_override ar_vat_tax.amount_includes_tax_override%type;
5454: /* bug fix : 1070949 */

Line 5451: l_autotax ra_customer_trx_lines.autotax%type;

5447: l_warehouse_id NUMBER;
5448: l_sob_id NUMBER;
5449: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
5450: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;
5451: l_autotax ra_customer_trx_lines.autotax%type;
5452: l_amt_incl_tax_flag ar_vat_tax.amount_includes_tax_flag%type;
5453: l_amt_incl_tax_override ar_vat_tax.amount_includes_tax_override%type;
5454: /* bug fix : 1070949 */
5455: l_tax_calculation_flag varchar2(1);

Line 5552: --- UPDATE RA_CUSTOMER_TRX_LINES with new

5548: END;
5549:
5550: IF l_tax_code IS NOT NULL
5551: THEN
5552: --- UPDATE RA_CUSTOMER_TRX_LINES with new
5553: --- tax_code and autotax='Y'
5554: update ra_customer_trx_lines
5555: set tax_classification_code = l_tax_code,
5556: autotax = l_autotax

Line 5554: update ra_customer_trx_lines

5550: IF l_tax_code IS NOT NULL
5551: THEN
5552: --- UPDATE RA_CUSTOMER_TRX_LINES with new
5553: --- tax_code and autotax='Y'
5554: update ra_customer_trx_lines
5555: set tax_classification_code = l_tax_code,
5556: autotax = l_autotax
5557: where customer_trx_line_id = line.customer_trx_line_id;
5558: END IF;

Line 5605: update ra_customer_trx_lines

5601: l_tax_code := NULL;
5602: l_autotax := 'Y';
5603: END;
5604:
5605: update ra_customer_trx_lines
5606: set tax_classification_code = l_tax_code,
5607: autotax = l_autotax
5608: where customer_trx_line_id = line.customer_trx_line_id;
5609: