APPS.ARP_CT_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 6786: FROM ra_customer_trx_lines

6782: SELECT customer_trx_line_id,
6783: inventory_item_id,
6784: memo_line_id,
6785: warehouse_id
6786: FROM ra_customer_trx_lines
6787: WHERE customer_trx_id = p_customer_trx_id
6788: AND line_type = 'LINE';--3872371
6789:
6790: l_tax_code VARCHAR2(50);

Line 6795: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

6791: l_vat_tax_id NUMBER ;
6792: l_organization_id NUMBER ;
6793: l_warehouse_id NUMBER;
6794: l_sob_id NUMBER;
6795: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
6796: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;
6797: l_autotax ra_customer_trx_lines.autotax%type;
6798: l_amt_incl_tax_flag ar_vat_tax.amount_includes_tax_flag%type;
6799: l_amt_incl_tax_override ar_vat_tax.amount_includes_tax_override%type;

Line 6796: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;

6792: l_organization_id NUMBER ;
6793: l_warehouse_id NUMBER;
6794: l_sob_id NUMBER;
6795: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
6796: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;
6797: l_autotax ra_customer_trx_lines.autotax%type;
6798: l_amt_incl_tax_flag ar_vat_tax.amount_includes_tax_flag%type;
6799: l_amt_incl_tax_override ar_vat_tax.amount_includes_tax_override%type;
6800: /* bug fix : 1070949 */

Line 6797: l_autotax ra_customer_trx_lines.autotax%type;

6793: l_warehouse_id NUMBER;
6794: l_sob_id NUMBER;
6795: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
6796: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type;
6797: l_autotax ra_customer_trx_lines.autotax%type;
6798: l_amt_incl_tax_flag ar_vat_tax.amount_includes_tax_flag%type;
6799: l_amt_incl_tax_override ar_vat_tax.amount_includes_tax_override%type;
6800: /* bug fix : 1070949 */
6801: l_tax_calculation_flag varchar2(1);

Line 6898: --- UPDATE RA_CUSTOMER_TRX_LINES with new

6894: END;
6895:
6896: IF l_tax_code IS NOT NULL
6897: THEN
6898: --- UPDATE RA_CUSTOMER_TRX_LINES with new
6899: --- tax_code and autotax='Y'
6900: update ra_customer_trx_lines
6901: set tax_classification_code = l_tax_code,
6902: autotax = l_autotax

Line 6900: update ra_customer_trx_lines

6896: IF l_tax_code IS NOT NULL
6897: THEN
6898: --- UPDATE RA_CUSTOMER_TRX_LINES with new
6899: --- tax_code and autotax='Y'
6900: update ra_customer_trx_lines
6901: set tax_classification_code = l_tax_code,
6902: autotax = l_autotax
6903: where customer_trx_line_id = line.customer_trx_line_id;
6904: END IF;

Line 6951: update ra_customer_trx_lines

6947: l_tax_code := NULL;
6948: l_autotax := 'Y';
6949: END;
6950:
6951: update ra_customer_trx_lines
6952: set tax_classification_code = l_tax_code,
6953: autotax = l_autotax
6954: where customer_trx_line_id = line.customer_trx_line_id;
6955: