[Home] [Help]
1938: L_TAX_EXMPT_SOURCE_TAX ,
1939: L_APPLICABLE_BY_DEFAULT_FLAG --Bug 4905771
1940: )
1941: /* --Bug4400704
1942: INTO zx_taxes_tl
1943: (
1944: TAX_ID ,
1945: LANGUAGE ,
1946: SOURCE_LANG ,
2352: L_TAX_EXMPT_SOURCE_TAX ,
2353: L_APPLICABLE_BY_DEFAULT_FLAG --Bug 4905771
2354: )
2355: /* --Bug4400704
2356: INTO zx_taxes_tl
2357: (
2358: TAX_ID ,
2359: LANGUAGE ,
2360: SOURCE_LANG ,
6516: AND tax = p_seg_att_type
6517: AND content_owner_id = -99
6518: )
6519: ) THEN
6520: INTO ZX_TAXES_TL
6521: (
6522: LANGUAGE ,
6523: SOURCE_LANG ,
6524: TAX_FULL_NAME ,
8074: ;
8075:
8076: END IF;
8077: /* --Bug440704
8078: -- Unique Index : zx_taxes_tl_u1 (tax_id, language)
8079: INSERT INTO ZX_TAXES_TL
8080: (
8081: LANGUAGE ,
8082: SOURCE_LANG ,
8075:
8076: END IF;
8077: /* --Bug440704
8078: -- Unique Index : zx_taxes_tl_u1 (tax_id, language)
8079: INSERT INTO ZX_TAXES_TL
8080: (
8081: LANGUAGE ,
8082: SOURCE_LANG ,
8083: TAX_FULL_NAME ,
8130: AND b.content_owner_id = c.content_owner_id (+)
8131:
8132: AND not exists
8133: (select NULL
8134: from ZX_TAXES_TL T
8135: where T.TAX_ID = B.TAX_ID
8136: and T.LANGUAGE = L.LANGUAGE_CODE);*/
8137:
8138: --Bug : 5092560 : This is to populate the ZX_TAXES_B.legal_reporting_status_def_val with '000000000000000'
9257: | DESCRIPTION
9258: | This procedure populates data in following MLS tables :
9259: |
9260: | - ZX_REGIMES_TL
9261: | - ZX_TAXES_TL
9262: | - ZX_STATUS_TL
9263: | - ZX_RATES_TL
9264: |
9265: | It is called at the end of AR tax code migration process and
9330: --
9331: -- For CZ/HU/PL (Tax Origin)
9332: --
9333:
9334: INSERT INTO ZX_TAXES_TL
9335: (
9336: LANGUAGE ,
9337: SOURCE_LANG ,
9338: TAX_FULL_NAME ,
9373: AND ar_code.global_attribute_category = 'JE.CZ.ARXSUVAT.TAX_ORIGIN'
9374: AND flv.lookup_type = 'JGZZ_TAX_ORIGIN'
9375: AND NOT EXISTS
9376: (select NULL
9377: from ZX_TAXES_TL T
9378: where T.TAX_ID = TAXES.TAX_ID
9379: and T.LANGUAGE = FLV.LANGUAGE);
9380:
9381:
9378: where T.TAX_ID = TAXES.TAX_ID
9379: and T.LANGUAGE = FLV.LANGUAGE);
9380:
9381:
9382: INSERT INTO ZX_TAXES_TL
9383: (
9384: LANGUAGE ,
9385: SOURCE_LANG ,
9386: TAX_FULL_NAME ,
9421: AND ar_code.global_attribute_category = 'JE.HU.ARXSUVAT.TAX_ORIGIN'
9422: AND flv.lookup_type = 'JGZZ_TAX_ORIGIN'
9423: AND NOT EXISTS
9424: (select NULL
9425: from ZX_TAXES_TL T
9426: where T.TAX_ID = TAXES.TAX_ID
9427: and T.LANGUAGE = FLV.LANGUAGE);
9428:
9429: INSERT INTO ZX_TAXES_TL
9425: from ZX_TAXES_TL T
9426: where T.TAX_ID = TAXES.TAX_ID
9427: and T.LANGUAGE = FLV.LANGUAGE);
9428:
9429: INSERT INTO ZX_TAXES_TL
9430: (
9431: LANGUAGE ,
9432: SOURCE_LANG ,
9433: TAX_FULL_NAME ,
9468: AND ar_code.global_attribute_category = 'JE.PL.ARXSUVAT.TAX_ORIGIN'
9469: AND flv.lookup_type = 'JGZZ_TAX_ORIGIN'
9470: AND NOT EXISTS
9471: (select NULL
9472: from ZX_TAXES_TL T
9473: where T.TAX_ID = TAXES.TAX_ID
9474: and T.LANGUAGE = FLV.LANGUAGE);
9475:
9476: --
9475:
9476: --
9477: -- LTE Tax Handling
9478: --
9479: INSERT INTO ZX_TAXES_TL
9480: (
9481: LANGUAGE ,
9482: SOURCE_LANG ,
9483: TAX_FULL_NAME ,
9520: and codes.global_attribute1 = to_char(categs.tax_category_id)
9521: and codes.org_id = categs.org_id
9522: AND not exists
9523: (select NULL
9524: from ZX_TAXES_TL T
9525: where T.TAX_ID = B.TAX_ID
9526: and T.LANGUAGE = L.LANGUAGE_CODE);
9527:
9528: INSERT INTO ZX_TAXES_TL
9524: from ZX_TAXES_TL T
9525: where T.TAX_ID = B.TAX_ID
9526: and T.LANGUAGE = L.LANGUAGE_CODE);
9527:
9528: INSERT INTO ZX_TAXES_TL
9529: (
9530: LANGUAGE ,
9531: SOURCE_LANG ,
9532: TAX_FULL_NAME ,
9569: and codes.global_attribute1 = to_char(categs.tax_category_id)
9570: and codes.org_id = categs.org_id
9571: AND not exists
9572: (select NULL
9573: from ZX_TAXES_TL T
9574: where T.TAX_ID = B.TAX_ID
9575: and T.LANGUAGE = L.LANGUAGE_CODE);
9576:
9577: INSERT INTO ZX_TAXES_TL
9573: from ZX_TAXES_TL T
9574: where T.TAX_ID = B.TAX_ID
9575: and T.LANGUAGE = L.LANGUAGE_CODE);
9576:
9577: INSERT INTO ZX_TAXES_TL
9578: (
9579: LANGUAGE ,
9580: SOURCE_LANG ,
9581: TAX_FULL_NAME ,
9618: and codes.global_attribute1 = to_char(categs.tax_category_id)
9619: and codes.org_id = categs.org_id
9620: AND not exists
9621: (select NULL
9622: from ZX_TAXES_TL T
9623: where T.TAX_ID = B.TAX_ID
9624: and T.LANGUAGE = L.LANGUAGE_CODE);
9625:
9626:
9623: where T.TAX_ID = B.TAX_ID
9624: and T.LANGUAGE = L.LANGUAGE_CODE);
9625:
9626:
9627: INSERT INTO ZX_TAXES_TL
9628: (
9629: TAX_ID,
9630: TAX_FULL_NAME,
9631: CREATION_DATE,
9657: L.INSTALLED_FLAG in ('I', 'B')
9658: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9659: AND not exists
9660: (select NULL
9661: from ZX_TAXES_TL T
9662: where T.TAX_ID = B.TAX_ID
9663: and T.LANGUAGE = L.LANGUAGE_CODE);
9664:
9665: /***** LTE handling is replaced by the insert statement executed above
9664:
9665: /***** LTE handling is replaced by the insert statement executed above
9666: --
9667: --Bug 4400704
9668: -- Unique Index : zx_taxes_tl_u1 (tax_id, language)
9669: INSERT INTO ZX_TAXES_TL
9670: (
9671: LANGUAGE ,
9672: SOURCE_LANG ,
9665: /***** LTE handling is replaced by the insert statement executed above
9666: --
9667: --Bug 4400704
9668: -- Unique Index : zx_taxes_tl_u1 (tax_id, language)
9669: INSERT INTO ZX_TAXES_TL
9670: (
9671: LANGUAGE ,
9672: SOURCE_LANG ,
9673: TAX_FULL_NAME ,
9737: AND b.content_owner_id = c.content_owner_id (+)
9738:
9739: AND not exists
9740: (select NULL
9741: from ZX_TAXES_TL T
9742: where T.TAX_ID = B.TAX_ID
9743: and T.LANGUAGE = L.LANGUAGE_CODE);
9744: ******/
9745: