APPS.JA_ZZ_VALIDATE_INVOICE_GDF dependencies on ZX_MCO_RATES

Line 674: -- Changing reference to ar vat tax to zx_mco_rates

670: FROM
671: ar_trx_lines_gt l,
672: --
673: -- Bug 4756219
674: -- Changing reference to ar vat tax to zx_mco_rates
675: zx_mco_rates tax
676:
677: WHERE
678: l.customer_trx_id = x_customer_trx_id

Line 675: zx_mco_rates tax

671: ar_trx_lines_gt l,
672: --
673: -- Bug 4756219
674: -- Changing reference to ar vat tax to zx_mco_rates
675: zx_mco_rates tax
676:
677: WHERE
678: l.customer_trx_id = x_customer_trx_id
679: AND l.vat_tax_id = tax.tax_rate_id;

Line 987: -- Changing reference to ar vat tax to zx_mco_rates

983: SELECT count(l.customer_trx_line_id)
984: INTO n
985: FROM ra_customer_trx_lines l,
986: -- Bug 4756219
987: -- Changing reference to ar vat tax to zx_mco_rates
988: zx_mco_rates v,
989: zx_accounts a
990: WHERE l.customer_trx_id = p_customer_trx_id
991: AND v.tax_rate_id = l.vat_tax_id

Line 988: zx_mco_rates v,

984: INTO n
985: FROM ra_customer_trx_lines l,
986: -- Bug 4756219
987: -- Changing reference to ar vat tax to zx_mco_rates
988: zx_mco_rates v,
989: zx_accounts a
990: WHERE l.customer_trx_id = p_customer_trx_id
991: AND v.tax_rate_id = l.vat_tax_id
992: AND v.tax_rate_id = a.tax_account_entity_id

Line 1000: -- Changing reference to ar vat tax to zx_mco_rates

996: SELECT count(l.customer_trx_line_id)
997: INTO n
998: FROM ar_trx_lines_gt l,
999: -- Bug 4756219
1000: -- Changing reference to ar vat tax to zx_mco_rates
1001: zx_mco_rates v,
1002: zx_accounts a
1003: WHERE l.customer_trx_id = p_customer_trx_id
1004: AND v.tax_rate_id = l.vat_tax_id

Line 1001: zx_mco_rates v,

997: INTO n
998: FROM ar_trx_lines_gt l,
999: -- Bug 4756219
1000: -- Changing reference to ar vat tax to zx_mco_rates
1001: zx_mco_rates v,
1002: zx_accounts a
1003: WHERE l.customer_trx_id = p_customer_trx_id
1004: AND v.tax_rate_id = l.vat_tax_id
1005: AND (v.tax_class = 'O' OR v.tax_class IS NULL)