APPS.ARP_STANDARD dependencies on AR_VAT_TAX

Line 2461: ar_vat_tax v1,

2457: SELECT tax.customer_trx_line_id,
2458: tax.customer_trx_id
2459: FROM ra_customer_trx_lines tax,
2460: ra_customer_trx_lines line,
2461: ar_vat_tax v1,
2462: ar_vat_tax v2
2463: WHERE tax.link_to_cust_trx_line_id = line.previous_customer_trx_line_id
2464: AND line.customer_trx_line_id = p_customer_trx_line_id
2465: AND tax.line_number = p_tax_line_number

Line 2462: ar_vat_tax v2

2458: tax.customer_trx_id
2459: FROM ra_customer_trx_lines tax,
2460: ra_customer_trx_lines line,
2461: ar_vat_tax v1,
2462: ar_vat_tax v2
2463: WHERE tax.link_to_cust_trx_line_id = line.previous_customer_trx_line_id
2464: AND line.customer_trx_line_id = p_customer_trx_line_id
2465: AND tax.line_number = p_tax_line_number
2466: AND tax.vat_tax_id = v1.vat_tax_id

Line 2478: ar_vat_tax v1,

2474: SELECT tax.customer_trx_line_id,
2475: tax.customer_trx_id
2476: FROM ra_customer_trx_lines tax,
2477: ra_customer_trx_lines line,
2478: ar_vat_tax v1,
2479: ar_vat_tax v2
2480: WHERE tax.link_to_cust_trx_line_id = line.previous_customer_trx_line_id
2481: AND line.customer_trx_line_id = p_customer_trx_line_id
2482: AND tax.vat_tax_id = v1.vat_tax_id

Line 2479: ar_vat_tax v2

2475: tax.customer_trx_id
2476: FROM ra_customer_trx_lines tax,
2477: ra_customer_trx_lines line,
2478: ar_vat_tax v1,
2479: ar_vat_tax v2
2480: WHERE tax.link_to_cust_trx_line_id = line.previous_customer_trx_line_id
2481: AND line.customer_trx_line_id = p_customer_trx_line_id
2482: AND tax.vat_tax_id = v1.vat_tax_id
2483: AND v1.tax_code = v2.tax_code

Line 2485: AND not exists ( select 'x' from ra_customer_trx_lines v, ar_vat_tax v3

2481: AND line.customer_trx_line_id = p_customer_trx_line_id
2482: AND tax.vat_tax_id = v1.vat_tax_id
2483: AND v1.tax_code = v2.tax_code
2484: AND v2.vat_tax_id = p_vat_tax_id
2485: AND not exists ( select 'x' from ra_customer_trx_lines v, ar_vat_tax v3
2486: where v.link_to_cust_trx_line_id = line.previous_customer_trx_line_id
2487: and v.vat_tax_id = v3.vat_tax_id
2488: and v3.tax_code = v1.tax_code
2489: and v.customer_trx_line_id <> tax.customer_trx_line_id );