[Home] [Help]
2024: L_TAX_EXMPT_SOURCE_TAX ,
2025: L_APPLICABLE_BY_DEFAULT_FLAG --Bug 4905771
2026: )
2027: /* --Bug4400704
2028: INTO zx_taxes_tl
2029: (
2030: TAX_ID ,
2031: LANGUAGE ,
2032: SOURCE_LANG ,
2439: L_TAX_EXMPT_SOURCE_TAX ,
2440: L_APPLICABLE_BY_DEFAULT_FLAG --Bug 4905771
2441: )
2442: /* --Bug4400704
2443: INTO zx_taxes_tl
2444: (
2445: TAX_ID ,
2446: LANGUAGE ,
2447: SOURCE_LANG ,
6528: AND tax = p_seg_att_type
6529: AND content_owner_id = -99
6530: )
6531: ) THEN
6532: INTO ZX_TAXES_TL
6533: (
6534: LANGUAGE ,
6535: SOURCE_LANG ,
6536: TAX_FULL_NAME ,
8086: ;
8087:
8088: END IF;
8089: /* --Bug440704
8090: -- Unique Index : zx_taxes_tl_u1 (tax_id, language)
8091: INSERT INTO ZX_TAXES_TL
8092: (
8093: LANGUAGE ,
8094: SOURCE_LANG ,
8087:
8088: END IF;
8089: /* --Bug440704
8090: -- Unique Index : zx_taxes_tl_u1 (tax_id, language)
8091: INSERT INTO ZX_TAXES_TL
8092: (
8093: LANGUAGE ,
8094: SOURCE_LANG ,
8095: TAX_FULL_NAME ,
8142: AND b.content_owner_id = c.content_owner_id (+)
8143:
8144: AND not exists
8145: (select NULL
8146: from ZX_TAXES_TL T
8147: where T.TAX_ID = B.TAX_ID
8148: and T.LANGUAGE = L.LANGUAGE_CODE);*/
8149:
8150: --Bug : 5092560 : This is to populate the ZX_TAXES_B.legal_reporting_status_def_val with '000000000000000'
9269: | DESCRIPTION
9270: | This procedure populates data in following MLS tables :
9271: |
9272: | - ZX_REGIMES_TL
9273: | - ZX_TAXES_TL
9274: | - ZX_STATUS_TL
9275: | - ZX_RATES_TL
9276: |
9277: | It is called at the end of AR tax code migration process and
9342: --
9343: -- For CZ/HU/PL (Tax Origin)
9344: --
9345:
9346: INSERT INTO ZX_TAXES_TL
9347: (
9348: LANGUAGE ,
9349: SOURCE_LANG ,
9350: TAX_FULL_NAME ,
9385: AND ar_code.global_attribute_category = 'JE.CZ.ARXSUVAT.TAX_ORIGIN'
9386: AND flv.lookup_type = 'JGZZ_TAX_ORIGIN'
9387: AND NOT EXISTS
9388: (select NULL
9389: from ZX_TAXES_TL T
9390: where T.TAX_ID = TAXES.TAX_ID
9391: and T.LANGUAGE = FLV.LANGUAGE);
9392:
9393:
9390: where T.TAX_ID = TAXES.TAX_ID
9391: and T.LANGUAGE = FLV.LANGUAGE);
9392:
9393:
9394: INSERT INTO ZX_TAXES_TL
9395: (
9396: LANGUAGE ,
9397: SOURCE_LANG ,
9398: TAX_FULL_NAME ,
9433: AND ar_code.global_attribute_category = 'JE.HU.ARXSUVAT.TAX_ORIGIN'
9434: AND flv.lookup_type = 'JGZZ_TAX_ORIGIN'
9435: AND NOT EXISTS
9436: (select NULL
9437: from ZX_TAXES_TL T
9438: where T.TAX_ID = TAXES.TAX_ID
9439: and T.LANGUAGE = FLV.LANGUAGE);
9440:
9441: INSERT INTO ZX_TAXES_TL
9437: from ZX_TAXES_TL T
9438: where T.TAX_ID = TAXES.TAX_ID
9439: and T.LANGUAGE = FLV.LANGUAGE);
9440:
9441: INSERT INTO ZX_TAXES_TL
9442: (
9443: LANGUAGE ,
9444: SOURCE_LANG ,
9445: TAX_FULL_NAME ,
9480: AND ar_code.global_attribute_category = 'JE.PL.ARXSUVAT.TAX_ORIGIN'
9481: AND flv.lookup_type = 'JGZZ_TAX_ORIGIN'
9482: AND NOT EXISTS
9483: (select NULL
9484: from ZX_TAXES_TL T
9485: where T.TAX_ID = TAXES.TAX_ID
9486: and T.LANGUAGE = FLV.LANGUAGE);
9487:
9488: --
9487:
9488: --
9489: -- LTE Tax Handling
9490: --
9491: INSERT INTO ZX_TAXES_TL
9492: (
9493: LANGUAGE ,
9494: SOURCE_LANG ,
9495: TAX_FULL_NAME ,
9532: and codes.global_attribute1 = to_char(categs.tax_category_id)
9533: and codes.org_id = categs.org_id
9534: AND not exists
9535: (select NULL
9536: from ZX_TAXES_TL T
9537: where T.TAX_ID = B.TAX_ID
9538: and T.LANGUAGE = L.LANGUAGE_CODE);
9539:
9540: INSERT INTO ZX_TAXES_TL
9536: from ZX_TAXES_TL T
9537: where T.TAX_ID = B.TAX_ID
9538: and T.LANGUAGE = L.LANGUAGE_CODE);
9539:
9540: INSERT INTO ZX_TAXES_TL
9541: (
9542: LANGUAGE ,
9543: SOURCE_LANG ,
9544: TAX_FULL_NAME ,
9581: and codes.global_attribute1 = to_char(categs.tax_category_id)
9582: and codes.org_id = categs.org_id
9583: AND not exists
9584: (select NULL
9585: from ZX_TAXES_TL T
9586: where T.TAX_ID = B.TAX_ID
9587: and T.LANGUAGE = L.LANGUAGE_CODE);
9588:
9589: INSERT INTO ZX_TAXES_TL
9585: from ZX_TAXES_TL T
9586: where T.TAX_ID = B.TAX_ID
9587: and T.LANGUAGE = L.LANGUAGE_CODE);
9588:
9589: INSERT INTO ZX_TAXES_TL
9590: (
9591: LANGUAGE ,
9592: SOURCE_LANG ,
9593: TAX_FULL_NAME ,
9630: and codes.global_attribute1 = to_char(categs.tax_category_id)
9631: and codes.org_id = categs.org_id
9632: AND not exists
9633: (select NULL
9634: from ZX_TAXES_TL T
9635: where T.TAX_ID = B.TAX_ID
9636: and T.LANGUAGE = L.LANGUAGE_CODE);
9637:
9638:
9635: where T.TAX_ID = B.TAX_ID
9636: and T.LANGUAGE = L.LANGUAGE_CODE);
9637:
9638:
9639: INSERT INTO ZX_TAXES_TL
9640: (
9641: TAX_ID,
9642: TAX_FULL_NAME,
9643: CREATION_DATE,
9669: L.INSTALLED_FLAG in ('I', 'B')
9670: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9671: AND not exists
9672: (select NULL
9673: from ZX_TAXES_TL T
9674: where T.TAX_ID = B.TAX_ID
9675: and T.LANGUAGE = L.LANGUAGE_CODE);
9676:
9677: /***** LTE handling is replaced by the insert statement executed above
9676:
9677: /***** LTE handling is replaced by the insert statement executed above
9678: --
9679: --Bug 4400704
9680: -- Unique Index : zx_taxes_tl_u1 (tax_id, language)
9681: INSERT INTO ZX_TAXES_TL
9682: (
9683: LANGUAGE ,
9684: SOURCE_LANG ,
9677: /***** LTE handling is replaced by the insert statement executed above
9678: --
9679: --Bug 4400704
9680: -- Unique Index : zx_taxes_tl_u1 (tax_id, language)
9681: INSERT INTO ZX_TAXES_TL
9682: (
9683: LANGUAGE ,
9684: SOURCE_LANG ,
9685: TAX_FULL_NAME ,
9749: AND b.content_owner_id = c.content_owner_id (+)
9750:
9751: AND not exists
9752: (select NULL
9753: from ZX_TAXES_TL T
9754: where T.TAX_ID = B.TAX_ID
9755: and T.LANGUAGE = L.LANGUAGE_CODE);
9756: ******/
9757: