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 JAI_CONSTANTS

Line 531: and jrtl.tax_type = jai_constants.tax_type_tds

527: jrtl.tax_id tax_id
528: from jai_rcv_line_taxes jrtl,
529: jai_cmn_taxes_all jtc
530: where jtc.tax_id = jrtl.tax_id
531: and jrtl.tax_type = jai_constants.tax_type_tds
532: and jtc.section_type = p_section_type--rchandan for bug#4428980
533: and jrtl.shipment_header_id = p_shipment_header_id
534: and jrtl.shipment_line_id = p_shipment_line_id
535: order by jrtl.tax_line_no asc;

Line 618: and jtc.tax_type = jai_constants.tax_type_tds

614: where jpllt.tax_id = jtc.tax_id
615: and jpllt.po_header_id = p_po_header_id
616: and jpllt.po_line_id = p_po_line_id
617: and jpllt.line_location_id = p_line_location_id
618: and jtc.tax_type = jai_constants.tax_type_tds
619: and jtc.section_type = p_section_type--rchandan for bug#4428980
620: order by jpllt.tax_line_no asc;
621:
622:

Line 889: AND jrr.registration_type = jai_constants.regn_type_tax_types

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
891: and nvl(jadit.invoice_distribution_id, -9999) = nvl(cp_invoice_distribution_id, -9999)
892: and nvl(jadit.invoice_id, -9999) = nvl(cp_invoice_id, -9999);
893:

Line 890: AND jrd.regime_code = jai_constants.service_regime

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
891: and nvl(jadit.invoice_distribution_id, -9999) = nvl(cp_invoice_distribution_id, -9999)
892: and nvl(jadit.invoice_id, -9999) = nvl(cp_invoice_id, -9999);
893:
894: Cursor c_upd_servtax_flag_y(cp_invoice_id number, cp_invoice_distribution_id number) is

Line 904: AND jrr.registration_type = jai_constants.regn_type_tax_types

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
906: and nvl(jadit.invoice_distribution_id, -9999) = nvl(cp_invoice_distribution_id, -9999)
907: and nvl(jadit.invoice_id, -9999) = nvl(cp_invoice_id, -9999);
908:

Line 905: AND jrd.regime_code = jai_constants.service_regime

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
906: and nvl(jadit.invoice_distribution_id, -9999) = nvl(cp_invoice_distribution_id, -9999)
907: and nvl(jadit.invoice_id, -9999) = nvl(cp_invoice_id, -9999);
908:
909: ln_tds_inv_tax_id_upd_n jai_ap_tds_inv_taxes.tds_inv_tax_id%type;

Line 927: AND jrr.registration_type = jai_constants.regn_type_tax_types

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
929: /*and nvl(jadit.invoice_distribution_id, -9999) = nvl(p_invoice_distribution_id, -9999)
930: and nvl(jadit.invoice_id, -9999) = nvl(p_invoice_id, -9999)*/ /*Commented nvl clause and added below by mmurtuza for bug 13983975*/
931: and jadit.invoice_distribution_id = p_invoice_distribution_id

Line 928: AND jrd.regime_code = jai_constants.service_regime

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
929: /*and nvl(jadit.invoice_distribution_id, -9999) = nvl(p_invoice_distribution_id, -9999)
930: and nvl(jadit.invoice_id, -9999) = nvl(p_invoice_id, -9999)*/ /*Commented nvl clause and added below by mmurtuza for bug 13983975*/
931: and jadit.invoice_distribution_id = p_invoice_distribution_id
932: and jadit.invoice_id = p_invoice_id

Line 942: AND jcta.tax_type in (JAI_CONSTANTS.TAX_TYPE_EXCISE, JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL, JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,

938: jai_cmn_document_taxes jcdt,
939: jai_cmn_taxes_all jcta
940: WHERE jcdt.tax_id = jcta.tax_id
941: --AND (UPPER(jcta.tax_type) LIKE '%EXCISE%' OR UPPER(jcta.tax_type) LIKE '%CUSTOMS%')
942: AND jcta.tax_type in (JAI_CONSTANTS.TAX_TYPE_EXCISE, JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL, JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
943: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
944: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS)
945: AND jadit.invoice_id=jcdt.source_doc_id
946: --AND nvl(jadit.invoice_distribution_id, -9999) = nvl(p_invoice_distribution_id, -9999)

Line 943: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_CUSTOMS,

939: jai_cmn_taxes_all jcta
940: WHERE jcdt.tax_id = jcta.tax_id
941: --AND (UPPER(jcta.tax_type) LIKE '%EXCISE%' OR UPPER(jcta.tax_type) LIKE '%CUSTOMS%')
942: AND jcta.tax_type in (JAI_CONSTANTS.TAX_TYPE_EXCISE, JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL, JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
943: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
944: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS)
945: AND jadit.invoice_id=jcdt.source_doc_id
946: --AND nvl(jadit.invoice_distribution_id, -9999) = nvl(p_invoice_distribution_id, -9999)
947: --and nvl(jadit.invoice_id, -9999) = nvl(p_invoice_id, -9999); --Commented nvl clause and added below by mmurtuza for bug 13983975

Line 944: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS)

940: WHERE jcdt.tax_id = jcta.tax_id
941: --AND (UPPER(jcta.tax_type) LIKE '%EXCISE%' OR UPPER(jcta.tax_type) LIKE '%CUSTOMS%')
942: AND jcta.tax_type in (JAI_CONSTANTS.TAX_TYPE_EXCISE, JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL, JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
943: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
944: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS)
945: AND jadit.invoice_id=jcdt.source_doc_id
946: --AND nvl(jadit.invoice_distribution_id, -9999) = nvl(p_invoice_distribution_id, -9999)
947: --and nvl(jadit.invoice_id, -9999) = nvl(p_invoice_id, -9999); --Commented nvl clause and added below by mmurtuza for bug 13983975
948: AND jadit.invoice_distribution_id = p_invoice_distribution_id

Line 964: AND jrr.registration_type = jai_constants.regn_type_tax_types

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
964: AND jrr.registration_type = jai_constants.regn_type_tax_types
965: AND jrd.regime_code = jai_constants.service_regime
966: /*and nvl(jadit.invoice_distribution_id, -9999) = nvl(p_invoice_distribution_id, -9999)
967: and nvl(jadit.invoice_id, -9999) = nvl(p_invoice_id, -9999)*/ /*Commented nvl clause and added below by mmurtuza for bug 13983975*/
968: and jadit.invoice_distribution_id = p_invoice_distribution_id

Line 965: AND jrd.regime_code = jai_constants.service_regime

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
964: AND jrr.registration_type = jai_constants.regn_type_tax_types
965: AND jrd.regime_code = jai_constants.service_regime
966: /*and nvl(jadit.invoice_distribution_id, -9999) = nvl(p_invoice_distribution_id, -9999)
967: and nvl(jadit.invoice_id, -9999) = nvl(p_invoice_id, -9999)*/ /*Commented nvl clause and added below by mmurtuza for bug 13983975*/
968: and jadit.invoice_distribution_id = p_invoice_distribution_id
969: and jadit.invoice_id = p_invoice_id

Line 976: jcta.tax_type in (JAI_CONSTANTS.TAX_TYPE_EXCISE, JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL, JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,

972:
973: select tds_inv_tax_id from
974: jai_ap_tds_inv_taxes jadit, JAI_AP_MATCH_INV_TAXES jamit, jai_cmn_taxes_all jcta
975: where --(upper(jcta.tax_type) like '%EXCISE%' OR UPPER(jcta.tax_type) LIKE '%CUSTOMS%')
976: jcta.tax_type in (JAI_CONSTANTS.TAX_TYPE_EXCISE, JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL, JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
977: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
978: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS)
979: and jamit.tax_id = jcta.tax_id
980: and nvl(jamit.po_distribution_id, -9999) = p_po_distribution_id

Line 977: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_CUSTOMS,

973: select tds_inv_tax_id from
974: jai_ap_tds_inv_taxes jadit, JAI_AP_MATCH_INV_TAXES jamit, jai_cmn_taxes_all jcta
975: where --(upper(jcta.tax_type) like '%EXCISE%' OR UPPER(jcta.tax_type) LIKE '%CUSTOMS%')
976: jcta.tax_type in (JAI_CONSTANTS.TAX_TYPE_EXCISE, JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL, JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
977: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
978: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS)
979: and jamit.tax_id = jcta.tax_id
980: and nvl(jamit.po_distribution_id, -9999) = p_po_distribution_id
981: and jadit.invoice_distribution_id = jamit.invoice_distribution_id

Line 978: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS)

974: jai_ap_tds_inv_taxes jadit, JAI_AP_MATCH_INV_TAXES jamit, jai_cmn_taxes_all jcta
975: where --(upper(jcta.tax_type) like '%EXCISE%' OR UPPER(jcta.tax_type) LIKE '%CUSTOMS%')
976: jcta.tax_type in (JAI_CONSTANTS.TAX_TYPE_EXCISE, JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL, JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
977: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
978: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS)
979: and jamit.tax_id = jcta.tax_id
980: and nvl(jamit.po_distribution_id, -9999) = p_po_distribution_id
981: and jadit.invoice_distribution_id = jamit.invoice_distribution_id
982: --and nvl(jadit.invoice_distribution_id, -9999) = nvl(p_invoice_distribution_id, -9999)

Line 1000: AND jrr.registration_type = jai_constants.regn_type_tax_types

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
1000: AND jrr.registration_type = jai_constants.regn_type_tax_types
1001: AND jrd.regime_code = jai_constants.service_regime
1002: /*and nvl(jadit.invoice_distribution_id, -9999) = nvl(p_invoice_distribution_id, -9999)
1003: and nvl(jadit.invoice_id, -9999) = nvl(p_invoice_id, -9999)*/ /*Commented nvl clause and added below by mmurtuza for bug 13983975*/
1004: and jadit.invoice_distribution_id = p_invoice_distribution_id

Line 1001: AND jrd.regime_code = jai_constants.service_regime

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
1000: AND jrr.registration_type = jai_constants.regn_type_tax_types
1001: AND jrd.regime_code = jai_constants.service_regime
1002: /*and nvl(jadit.invoice_distribution_id, -9999) = nvl(p_invoice_distribution_id, -9999)
1003: and nvl(jadit.invoice_id, -9999) = nvl(p_invoice_id, -9999)*/ /*Commented nvl clause and added below by mmurtuza for bug 13983975*/
1004: and jadit.invoice_distribution_id = p_invoice_distribution_id
1005: and jadit.invoice_id = p_invoice_id

Line 1012: jcta.tax_type in (JAI_CONSTANTS.TAX_TYPE_EXCISE, JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL, JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,

1008:
1009: select tds_inv_tax_id from
1010: jai_ap_tds_inv_taxes jadit, JAI_AP_MATCH_INV_TAXES jamit, jai_cmn_taxes_all jcta
1011: where --(upper(jcta.tax_type) like '%EXCISE%' OR UPPER(jcta.tax_type) LIKE '%CUSTOMS%')
1012: jcta.tax_type in (JAI_CONSTANTS.TAX_TYPE_EXCISE, JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL, JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
1013: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
1014: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS)
1015: and jamit.tax_id = jcta.tax_id
1016: and nvl(jamit.rcv_transaction_id, -9999) = p_rcv_transaction_id

Line 1013: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_CUSTOMS,

1009: select tds_inv_tax_id from
1010: jai_ap_tds_inv_taxes jadit, JAI_AP_MATCH_INV_TAXES jamit, jai_cmn_taxes_all jcta
1011: where --(upper(jcta.tax_type) like '%EXCISE%' OR UPPER(jcta.tax_type) LIKE '%CUSTOMS%')
1012: jcta.tax_type in (JAI_CONSTANTS.TAX_TYPE_EXCISE, JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL, JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
1013: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
1014: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS)
1015: and jamit.tax_id = jcta.tax_id
1016: and nvl(jamit.rcv_transaction_id, -9999) = p_rcv_transaction_id
1017: and jadit.invoice_distribution_id = jamit.invoice_distribution_id

Line 1014: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS)

1010: jai_ap_tds_inv_taxes jadit, JAI_AP_MATCH_INV_TAXES jamit, jai_cmn_taxes_all jcta
1011: where --(upper(jcta.tax_type) like '%EXCISE%' OR UPPER(jcta.tax_type) LIKE '%CUSTOMS%')
1012: jcta.tax_type in (JAI_CONSTANTS.TAX_TYPE_EXCISE, JAI_CONSTANTS.TAX_TYPE_EXC_ADDITIONAL, JAI_CONSTANTS.TAX_TYPE_EXC_OTHER,
1013: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_CUSTOMS,
1014: JAI_CONSTANTS.TAX_TYPE_CUSTOMS_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS)
1015: and jamit.tax_id = jcta.tax_id
1016: and nvl(jamit.rcv_transaction_id, -9999) = p_rcv_transaction_id
1017: and jadit.invoice_distribution_id = jamit.invoice_distribution_id
1018: --and nvl(jadit.invoice_distribution_id, -9999) = nvl(p_invoice_distribution_id, -9999)