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.JAI_AP_TDS_TAX_DEFAULTATION dependencies on JA_LOOKUPS

Line 885: and (NVL(upper(nvl(actual_section_code, default_section_code)), '-XX') NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE')

881: jai_ap_tds_inv_taxes jadit, jai_cmn_document_taxes jcdt, jai_cmn_taxes_all jcta,
882: jai_rgm_registrations jrr, jai_rgm_definitions jrd
883: where jadit.invoice_id=jcdt.source_doc_id
884: and jadit.actual_tax_id=jcta.tax_id
885: and (NVL(upper(nvl(actual_section_code, default_section_code)), '-XX') NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE')
886: AND upper(jcta.section_code) NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE'))
887: AND jcdt.tax_type = jrr.attribute_code
888: AND jrr.regime_id = jrd.regime_id
889: AND jrr.registration_type = jai_constants.regn_type_tax_types

Line 886: AND upper(jcta.section_code) NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE'))

882: jai_rgm_registrations jrr, jai_rgm_definitions jrd
883: where jadit.invoice_id=jcdt.source_doc_id
884: and jadit.actual_tax_id=jcta.tax_id
885: and (NVL(upper(nvl(actual_section_code, default_section_code)), '-XX') NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE')
886: AND upper(jcta.section_code) NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE'))
887: AND jcdt.tax_type = jrr.attribute_code
888: AND jrr.regime_id = jrd.regime_id
889: AND jrr.registration_type = jai_constants.regn_type_tax_types
890: AND jrd.regime_code = jai_constants.service_regime

Line 900: and NOT (NVL(upper(nvl(actual_section_code, default_section_code)), '-XX') NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE')

896: jai_ap_tds_inv_taxes jadit, jai_cmn_document_taxes jcdt, jai_cmn_taxes_all jcta,
897: jai_rgm_registrations jrr, jai_rgm_definitions jrd
898: where jadit.invoice_id=jcdt.source_doc_id
899: and jadit.actual_tax_id=jcta.tax_id
900: and NOT (NVL(upper(nvl(actual_section_code, default_section_code)), '-XX') NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE')
901: AND upper(jcta.section_code) NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE'))
902: AND jcdt.tax_type = jrr.attribute_code
903: AND jrr.regime_id = jrd.regime_id
904: AND jrr.registration_type = jai_constants.regn_type_tax_types

Line 901: AND upper(jcta.section_code) NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE'))

897: jai_rgm_registrations jrr, jai_rgm_definitions jrd
898: where jadit.invoice_id=jcdt.source_doc_id
899: and jadit.actual_tax_id=jcta.tax_id
900: and NOT (NVL(upper(nvl(actual_section_code, default_section_code)), '-XX') NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE')
901: AND upper(jcta.section_code) NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE'))
902: AND jcdt.tax_type = jrr.attribute_code
903: AND jrr.regime_id = jrd.regime_id
904: AND jrr.registration_type = jai_constants.regn_type_tax_types
905: AND jrd.regime_code = jai_constants.service_regime

Line 924: AND upper(jcta.section_code) NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE')

920: jai_ap_tds_inv_taxes jadit, jai_cmn_document_taxes jcdt, jai_cmn_taxes_all jcta,
921: jai_rgm_registrations jrr, jai_rgm_definitions jrd
922: where jadit.invoice_id=jcdt.source_doc_id
923: and nvl(jadit.actual_tax_id, jadit.default_tax_id)=jcta.tax_id
924: AND upper(jcta.section_code) NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE')
925: AND jcdt.tax_type = jrr.attribute_code
926: AND jrr.regime_id = jrd.regime_id
927: AND jrr.registration_type = jai_constants.regn_type_tax_types
928: AND jrd.regime_code = jai_constants.service_regime

Line 959: AND upper(jcta1.section_code) NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE')

955: jai_rgm_registrations jrr, jai_rgm_definitions jrd
956: where jadit.invoice_id = jamit.invoice_id
957: and nvl(jadit.actual_tax_id, default_tax_id)=jcta1.tax_id
958: and nvl(jamit.po_distribution_id, -9999) = p_po_distribution_id
959: AND upper(jcta1.section_code) NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE')
960: and jamit.tax_id=jcta2.tax_id /* Added AND condition for bug 14052883 */
961: and jadit.invoice_line_number=jamit.invoice_line_number /* Added AND condition for bug 14052883 */
962: AND jcta2.tax_type = jrr.attribute_code
963: AND jrr.regime_id = jrd.regime_id

Line 995: AND upper(jcta1.section_code) NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE')

991: jai_rgm_registrations jrr, jai_rgm_definitions jrd
992: where jadit.invoice_id = jamit.invoice_id
993: and nvl(jadit.actual_tax_id, default_tax_id)=jcta1.tax_id
994: and nvl(jamit.rcv_transaction_id, -9999) = p_rcv_transaction_id
995: AND upper(jcta1.section_code) NOT IN (select upper(lookup_code) from ja_lookups where lookup_type='JAI_TDS_SECTION_SERVICE')
996: and jamit.tax_id=jcta2.tax_id /* Added AND condition for bug 14052883 */
997: and jadit.invoice_line_number=jamit.invoice_line_number /* Added AND condition for bug 14052883 */
998: AND jcta2.tax_type = jrr.attribute_code
999: AND jrr.regime_id = jrd.regime_id