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.ARP_STANDARD dependencies on RA_CUSTOMER_TRX

Line 2459: FROM ra_customer_trx_lines tax,

2455: p_vat_tax_id IN NUMBER ) IS
2456:
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

Line 2460: ra_customer_trx_lines line,

2456:
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

Line 2476: FROM ra_customer_trx_lines tax,

2472: p_vat_tax_id IN NUMBER ) IS
2473:
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

Line 2477: ra_customer_trx_lines line,

2473:
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

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 );

Line 2498: SELECT 'x' from ra_customer_trx_lines line, ra_customer_trx hdr, ra_cust_trx_types type

2494: /* previous customer_trx_id and trx_line_id for tax records if */
2495: /* autoaccounting is to work. Using 10SC the tax views will */
2496: /* allways return a previous_customer_trx_line_id for applied trx */
2497:
2498: SELECT 'x' from ra_customer_trx_lines line, ra_customer_trx hdr, ra_cust_trx_types type
2499: where line.customer_trx_id = hdr.customer_trx_id
2500: and line.customer_trx_line_id = p_customer_trx_line_id
2501: and hdr.previous_customer_trx_id is not null
2502: and hdr.cust_trx_type_id = type.cust_trx_type_id