[Home] [Help]
113:
114: /* Bug 4710118 : To Ensure that atleast one rate code gets created with default_rate_flag = 'Y' for a particular
115: Combination of regime , tax , status and Content Owner */
116:
117: update zx_rates_b_tmp rates
118: set rates.default_rate_flag = 'Y' ,
119: rates.default_flg_effective_from = rates.effective_from, --Bug 5104891
120: rates.default_flg_effective_to = rates.effective_to -- Bug 6680676
121: where rates.tax_rate_code in ( select rates1.tax_rate_code from zx_rates_b rates1
117: update zx_rates_b_tmp rates
118: set rates.default_rate_flag = 'Y' ,
119: rates.default_flg_effective_from = rates.effective_from, --Bug 5104891
120: rates.default_flg_effective_to = rates.effective_to -- Bug 6680676
121: where rates.tax_rate_code in ( select rates1.tax_rate_code from zx_rates_b rates1
122: where rates.tax_regime_code = rates1.tax_regime_code
123: and rates.tax = rates1.tax
124: and rates.tax_status_code = rates1.tax_status_code
125: and rates.content_owner_id = rates1.content_owner_id
130: and rownum = 1)
131: /* Not Exists is to prevent the default_rate_flag to be updated to 'Y' for 2 rates under the same combination of
132: regime,tax,status and Content owner */
133:
134: and not exists (select 1 from zx_rates_b rates2
135: where rates2.tax_regime_code = rates.tax_regime_code
136: and rates2.tax = rates.tax
137: and rates2.tax_status_code = rates.tax_status_code
138: and rates2.content_owner_id = rates.content_owner_id
244: INTO p_tax_regime_code,
245: p_tax,
246: p_tax_status_code,
247: p_tax_rate_code
248: FROM zx_rates_b zrb,
249: zx_party_tax_profile zptp
250: WHERE
251: zptp.party_type_code = 'OU'
252: AND zptp.party_tax_profile_id = zrb.content_owner_id
476: AND asp.tax_database_view_set = 'O'
477: AND tax.tax_regime_code = 'US-SALES-TAX-'|| TO_CHAR(location_structure_id)
478: AND tax.content_owner_id = -99
479: AND tax.tax_type_code = 'LOCATION'
480: AND not exists(select 1 from zx_rates_b rate
481: where rate.tax_rate_code = tax.tax
482: and rate.content_owner_id = ptp.party_tax_profile_id
483: and rate.active_flag = 'Y'
484: and rate.tax_jurisdiction_code is null);
2791: -- zx_rates_tl is created by procedure populate_mls_tables
2792: IF L_MULTI_ORG_FLAG = 'Y'
2793: THEN
2794: INSERT ALL
2795: INTO zx_rates_b_tmp
2796: (
2797: TAX_RATE_ID ,
2798: TAX_RATE_CODE ,
2799: CONTENT_OWNER_ID ,
3117: 'JL.BR.ARXSUVAT.AR_VAT_TAX',
3118: 'JL.CO.ARXSUVAT.AR_VAT_TAX'))
3119: AND (asp.tax_database_view_set = 'O' AND codes.tax_type = 'LOCATION')
3120: AND NOT EXISTS (SELECT 1
3121: FROM zx_rates_b rates
3122: WHERE status.tax_regime_code = rates.tax_regime_code
3123: AND status.tax = rates.tax
3124: AND status.tax_status_code = rates.tax_status_code
3125: AND status.content_owner_id = rates.content_owner_id
3126: AND rates.tax_rate_code = codes.tax_code
3127: );
3128: ELSE
3129: INSERT ALL
3130: INTO zx_rates_b_tmp
3131: (
3132: TAX_RATE_ID ,
3133: TAX_RATE_CODE ,
3134: CONTENT_OWNER_ID ,
3454: 'JL.CO.ARXSUVAT.AR_VAT_TAX'))
3455: AND (asp.tax_database_view_set = 'O' AND codes.tax_type = 'LOCATION')
3456:
3457: AND NOT EXISTS (SELECT 1
3458: FROM zx_rates_b rates
3459: WHERE status.tax_regime_code = rates.tax_regime_code
3460: AND status.tax = rates.tax
3461: AND status.tax_status_code = rates.tax_status_code
3462: AND status.content_owner_id = rates.content_owner_id
3606: AND asp.tax_database_view_set IN ('_A','_V')
3607: AND tax.tax_regime_code = 'US-SALES-TAX-'|| TO_CHAR(location_structure_id)
3608: AND tax.content_owner_id = -99
3609: AND tax.tax_type_code = 'LOCATION'
3610: AND not exists(select 1 from zx_rates_b rate
3611: where rate.tax_rate_code = tax.tax
3612: and rate.content_owner_id = ptp.party_tax_profile_id
3613: and rate.active_flag = 'Y'
3614: and rate.tax_jurisdiction_code is null);
4090: THEN
4091:
4092:
4093: INSERT ALL
4094: INTO zx_rates_b_tmp
4095: (
4096: TAX_RATE_ID ,
4097: TAX_RATE_CODE ,
4098: CONTENT_OWNER_ID ,
4415: AND ((avt.tax_code = ztb.tax and avt.tax_type = 'SALES_TAX' ) or (avt.tax_type = 'LOCATION' and ztb.tax='LOCATION'))
4416: --bug#7343019
4417: AND ptp.party_tax_profile_id = ztb.content_owner_id
4418: AND NOT EXISTS (SELECT 1
4419: FROM zx_rates_b rates
4420: WHERE rates.tax_rate_id = avt.vat_tax_id
4421: );
4422: ELSE
4423:
4422: ELSE
4423:
4424:
4425: INSERT ALL
4426: INTO zx_rates_b_tmp
4427: (
4428: TAX_RATE_ID ,
4429: TAX_RATE_CODE ,
4430: CONTENT_OWNER_ID ,
4748: AND ((avt.tax_code = ztb.tax and avt.tax_type = 'SALES_TAX' ) or (avt.tax_type = 'LOCATION' and ztb.tax='LOCATION'))
4749: --bug#7343019
4750: AND ptp.party_tax_profile_id = ztb.content_owner_id
4751: AND NOT EXISTS (SELECT 1
4752: FROM zx_rates_b rates
4753: WHERE rates.tax_rate_id = avt.vat_tax_id
4754: );
4755:
4756: END IF;
4922: IF L_MULTI_ORG_FLAG = 'Y'
4923: THEN
4924:
4925: INSERT ALL
4926: INTO zx_rates_b_tmp
4927: (
4928: TAX_RATE_ID ,
4929: TAX_RATE_CODE ,
4930: CONTENT_OWNER_ID ,
5271: AND codes.vat_tax_id = nvl(p_tax_id, codes.vat_tax_id)
5272:
5273: --Rerunability/ID CLASH
5274: AND not exists (select 1
5275: from zx_rates_b rates
5276: where rates.tax_rate_id = nvl(p_tax_id, codes.vat_tax_id)
5277: );
5278: ELSE
5279:
5277: );
5278: ELSE
5279:
5280: INSERT ALL
5281: INTO zx_rates_b_tmp
5282: (
5283: TAX_RATE_ID ,
5284: TAX_RATE_CODE ,
5285: CONTENT_OWNER_ID ,
5627: AND codes.vat_tax_id = nvl(p_tax_id, codes.vat_tax_id)
5628:
5629: --Rerunability/ID CLASH
5630: AND not exists (select 1
5631: from zx_rates_b rates
5632: where rates.tax_rate_id = nvl(p_tax_id, codes.vat_tax_id)
5633: );
5634:
5635:
5639:
5640: /* Bug 4708982
5641: IF L_LTE_USED = 'Y' THEN
5642: INSERT ALL
5643: INTO zx_rates_b_tmp
5644: (
5645: TAX_RATE_ID ,
5646: TAX_RATE_CODE ,
5647: CONTENT_OWNER_ID ,
5971:
5972: -- Rerunability/ID CLASH
5973: --BugFix 3605729 added nvl(source_id, in the following condition.
5974: AND not exists (select 1
5975: from zx_rates_b rates
5976: where rates.tax_rate_id = nvl(p_tax_id,codes.vat_tax_id)
5977: );
5978: END IF;
5979: */
6004: avtt.language ,
6005: avtt.source_lang
6006:
6007: FROM ar_vat_tax_all_tl avtt,
6008: zx_rates_b zrb
6009: WHERE avtt.vat_tax_id = zrb.tax_rate_id
6010: AND NOT EXISTS (SELECT 1
6011: FROM zx_rates_tl zrt
6012: WHERE zrt.tax_rate_id = avtt.vat_tax_id
6569: |
6570: | OUT
6571: |
6572: | DESCRIPTION
6573: | This routine creates records in zx_status_b/tl grouping by zx_rates_b
6574: |
6575: |
6576: | SCOPE - PRIVATE
6577: |
6690: NVL(ar_sys_op.TAX_USE_PRODUCT_EXEMPT_FLAG,'N') = 'N')
6691: THEN 'N'
6692: ELSE 'Y'
6693: END ALLOW_EXCEPTIONS_FLAG
6694: FROM ZX_RATES_B rates,
6695: AR_VAT_TAX_ALL_B codes,
6696: AR_SYSTEM_PARAMETERS_ALL ar_sys_op
6697: WHERE
6698: rates.record_type_code = 'MIGRATED'
6816: NVL(ar_sys_op.TAX_USE_PRODUCT_EXEMPT_FLAG,'N') = 'N')
6817: THEN 'N'
6818: ELSE 'Y'
6819: END ALLOW_EXCEPTIONS_FLAG
6820: FROM ZX_RATES_B rates,
6821: AR_VAT_TAX_ALL_B codes,
6822: AR_SYSTEM_PARAMETERS_ALL ar_sys_op
6823: WHERE
6824: rates.record_type_code = 'MIGRATED'
6948: min(categs.start_date_active) EFFECTIVE_FROM, --Effecive is derived from jl_zz_ar_tx_categ
6949: AR_SYS_OP.TAX_USE_PRODUCT_EXEMPT_FLAG tax_use_product_exempt_flag,
6950: AR_SYS_OP.TAX_USE_CUSTOMER_EXEMPT_FLAG tax_use_customer_exempt_flag,
6951: AR_SYS_OP.TAX_USE_LOC_EXC_RATE_FLAG tax_use_loc_exc_rate_flag
6952: FROM ZX_RATES_B rates,
6953: AR_VAT_TAX_ALL_B codes,
6954: AR_SYSTEM_PARAMETERS_ALL ar_sys_op,
6955: jl_zz_ar_tx_categ_all categs
6956: WHERE
7092: AND NVL(ar_sys_op.TAX_USE_PRODUCT_EXEMPT_FLAG,'N') = 'N')
7093: THEN 'N'
7094: ELSE 'Y'
7095: END ALLOW_EXCEPTIONS_FLAG
7096: FROM ZX_RATES_B rates,
7097: AR_VAT_TAX_ALL_B codes,
7098: AR_SYSTEM_PARAMETERS_ALL ar_sys_op
7099: WHERE codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id) --YK:8/30/2004: ID Clash handling
7100: AND codes.global_attribute_category = 'JATW.ARXSUVAT.VAT_TAX' --RP:9/7/2004: Category is different for P2P
7242: AND NVL(ar_sys_op.TAX_USE_PRODUCT_EXEMPT_FLAG,'N') = 'N')
7243: THEN 'N'
7244: ELSE 'Y'
7245: END ALLOW_EXCEPTIONS_FLAG
7246: FROM ZX_RATES_B rates,
7247: AR_VAT_TAX_ALL_B codes,
7248: AR_SYSTEM_PARAMETERS_ALL ar_sys_op
7249: WHERE codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id) --YK:8/30/2004: ID Clash handling
7250: AND codes.global_attribute_category = 'JATW.ARXSUVAT.VAT_TAX' --RP:9/7/2004: Category is different for P2P
7351: |
7352: | OUT
7353: |
7354: | DESCRIPTION
7355: | This routine creates records in zx_taxes_b/tl grouping by zx_rates_b
7356: |
7357: |
7358: | SCOPE - PRIVATE
7359: |
7505: (select codes.tax_type tax_type_code,
7506: rates.tax_regime_code tax_regime_code,
7507: rates.tax tax,
7508: rates.content_owner_id content_owner_id
7509: from zx_rates_b rates, ar_vat_tax_all_b codes
7510: where nvl(rates.source_id, rates.tax_rate_id) = codes.vat_tax_id --ID Clash
7511: AND rates.record_type_code = 'MIGRATED'
7512: AND rates.tax_class = DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT')
7513: group by rates.tax_regime_code, rates.tax, rates.content_owner_id, tax_type
7571: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
7572: 'N' ,--REPORTING_ONLY_FLAG
7573: 'N' ,--AUTO_PRVN_FLAG
7574: CASE WHEN
7575: EXISTS (select 1 from zx_rates_b active_rate
7576: where active_rate.TAX = l_TAX
7577: and active_rate.TAX_REGIME_CODE = l_TAX_REGIME_CODE
7578: and sysdate between active_rate.effective_from
7579: and nvl(active_rate.effective_to,sysdate)) --Could add active_flag in the condition
7603: 'N' ,--ALLOW_ROUNDING_OVERRIDE_FLAG
7604: --BugFix 3493419
7605: DECODE(L_CONTENT_OWNER_ID,
7606: (select min(CONTENT_OWNER_ID)
7607: from zx_rates_b
7608: where tax = l_TAX
7609: and tax_regime_code = l_TAX_REGIME_CODE
7610: and RECORD_TYPE_CODE = 'MIGRATED'),
7611: 'Y',
7673: -- Bug 6006519/5654551. 'User' is not a valid exchange rate type
7674: -- decode(ARP.CROSS_CURRENCY_RATE_TYPE,'User','Corporate',ARP.CROSS_CURRENCY_RATE_TYPE) CROSS_CURRENCY_RATE_TYPE
7675: NULL CROSS_CURRENCY_RATE_TYPE
7676: FROM
7677: ZX_RATES_B RATES,
7678: ZX_UPDATE_CRITERIA_RESULTS results,
7679: AR_SYSTEM_PARAMETERS_ALL ARP,
7680: GL_SETS_OF_BOOKS SOB,
7681: ZX_PARTY_TAX_PROFILE PTP
7858: (select codes.tax_type tax_type_code,
7859: rates.tax_regime_code tax_regime_code,
7860: rates.tax tax,
7861: rates.content_owner_id content_owner_id
7862: from zx_rates_b rates, ar_vat_tax_all_b codes
7863: where nvl(rates.source_id, rates.tax_rate_id) = codes.vat_tax_id --ID Clash
7864: AND rates.record_type_code = 'MIGRATED'
7865: AND rates.tax_class = DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT')
7866: group by rates.tax_regime_code, rates.tax, rates.content_owner_id, tax_type
7924: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
7925: 'N' ,--REPORTING_ONLY_FLAG
7926: 'N' ,--AUTO_PRVN_FLAG
7927: CASE WHEN
7928: EXISTS (select 1 from zx_rates_b active_rate
7929: where active_rate.TAX = l_TAX
7930: and active_rate.TAX_REGIME_CODE = l_TAX_REGIME_CODE
7931: and sysdate between active_rate.effective_from
7932: and nvl(active_rate.effective_to,sysdate)) --Could add active_flag in the condition
7956: 'N' ,--ALLOW_ROUNDING_OVERRIDE_FLAG
7957: --BugFix 3493419
7958: DECODE(L_CONTENT_OWNER_ID,
7959: (select min(CONTENT_OWNER_ID)
7960: from zx_rates_b
7961: where tax = l_TAX
7962: and tax_regime_code = l_TAX_REGIME_CODE
7963: and RECORD_TYPE_CODE = 'MIGRATED'),
7964: 'Y',
8026: -- Bug 6006519/5654551, 'User' is not a valid exchange rate type
8027: -- decode(ARP.CROSS_CURRENCY_RATE_TYPE,'User','Corporate',ARP.CROSS_CURRENCY_RATE_TYPE) CROSS_CURRENCY_RATE_TYPE
8028: NULL CROSS_CURRENCY_RATE_TYPE
8029: FROM
8030: ZX_RATES_B RATES,
8031: ZX_UPDATE_CRITERIA_RESULTS results,
8032: AR_SYSTEM_PARAMETERS_ALL ARP,
8033: GL_SETS_OF_BOOKS SOB,
8034: ZX_PARTY_TAX_PROFILE PTP
8122: rates.tax tax,
8123: rates.content_owner_id content_owner_id,
8124: categs.description description,
8125: codes.global_attribute_category global_attribute_category
8126: from zx_rates_b rates,
8127: ar_vat_tax_all_b codes,
8128: jl_zz_ar_tx_categ_all categs
8129: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
8130: and codes.global_attribute_category in ('JL.AR.ARXSUVAT.AR_VAT_TAX',
8173:
8174: --Bug Fix 5691957
8175: UPDATE zx_taxes_b_tmp tax SET taxable_basis_rule_flag = 'Y' WHERE
8176: EXISTS
8177: (SELECT 1 FROM zx_rates_b rates,ar_vat_tax_all_b codes
8178: WHERE rates.tax_regime_code = tax.tax_regime_code
8179: AND rates.tax = tax.tax
8180: AND rates.content_owner_id = tax.content_owner_id
8181: AND rates.tax_rate_id = codes.vat_tax_id
8382: (
8383: SELECT RATES.TAX_REGIME_CODE TAX_REGIME_CODE,
8384: min(RATES.EFFECTIVE_FROM) EFFECTIVE_FROM
8385: FROM
8386: ZX_RATES_B RATES
8387: WHERE
8388: RATES.RECORD_TYPE_CODE = 'MIGRATED'
8389:
8390: --Added following conditions for Sync process
8434: ZX_REGIMES_B B,
8435: (select rates.tax_regime_code tax_regime_code,
8436: lkups.meaning meaning,
8437: codes.global_attribute_category global_attribute_category
8438: from zx_rates_b rates,
8439: ar_vat_tax_all_b codes,
8440: ar_system_parameters_all params,
8441: fnd_lookups lkups
8442: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
8936: lc_tax_regime_code,
8937: lc_tax,
8938: lc_status_code,
8939: lc_rate_code_id
8940: FROM zx_rates_b rates,
8941: ar_vat_tax_all_b tax_code
8942: WHERE tax_code.vat_tax_id = rates.tax_rate_id
8943: AND rates.record_type_code = 'MIGRATED'
8944: AND tax_code.global_attribute_category
9371: fnd_global.conc_login_id ,
9372: taxes.tax_id
9373: FROM
9374: zx_taxes_b taxes,
9375: zx_rates_b rates,
9376: fnd_lookup_values flv,
9377: ar_vat_tax_all_b ar_code
9378: WHERE
9379: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
9419: fnd_global.conc_login_id ,
9420: taxes.tax_id
9421: FROM
9422: zx_taxes_b taxes,
9423: zx_rates_b rates,
9424: fnd_lookup_values flv,
9425: ar_vat_tax_all_b ar_code
9426: WHERE
9427: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
9466: fnd_global.conc_login_id ,
9467: taxes.tax_id
9468: FROM
9469: zx_taxes_b taxes,
9470: zx_rates_b rates,
9471: fnd_lookup_values flv,
9472: ar_vat_tax_all_b ar_code
9473: WHERE
9474: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
9517: B.TAX_ID
9518: FROM
9519: FND_LANGUAGES L,
9520: ZX_TAXES_B B,
9521: zx_rates_b rates,
9522: ar_vat_tax_all_b codes,
9523: jl_zz_ar_tx_categ_all categs
9524: WHERE
9525: L.INSTALLED_FLAG in ('I', 'B')
9566: B.TAX_ID
9567: FROM
9568: FND_LANGUAGES L,
9569: ZX_TAXES_B B,
9570: zx_rates_b rates,
9571: ar_vat_tax_all_b codes,
9572: jl_zz_ar_tx_categ_all categs
9573: WHERE
9574: L.INSTALLED_FLAG in ('I', 'B')
9615: B.TAX_ID
9616: FROM
9617: FND_LANGUAGES L,
9618: ZX_TAXES_B B,
9619: zx_rates_b rates,
9620: ar_vat_tax_all_b codes,
9621: jl_zz_ar_tx_categ_all categs
9622: WHERE
9623: L.INSTALLED_FLAG in ('I', 'B')
9729: rates.tax tax,
9730: rates.content_owner_id content_owner_id,
9731: categs.description description,
9732: codes.global_attribute_category global_attribute_category
9733: from zx_rates_b rates,
9734: ar_vat_tax_all_b codes,
9735: jl_zz_ar_tx_categ_all categs
9736: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
9737: and codes.global_attribute_category in ('JL.AR.ARXSUVAT.AR_VAT_TAX',
9784: fnd_global.user_id,
9785: fnd_global.conc_login_id,
9786: flv.language,
9787: userenv('LANG')
9788: from zx_rates_b rates,
9789: zx_status_b status,
9790: ar_vat_tax_all_b codes,
9791: fnd_lookup_values flv
9792: where rates.tax_regime_code = status.tax_regime_code
9876: fnd_global.login_id,
9877: avtt.language ,
9878: avtt.source_lang ,
9879: avtb.description
9880: FROM zx_rates_b b,
9881: ar_vat_tax_all_b avtb,
9882: ar_vat_tax_all_tl avtt
9883: WHERE avtb.vat_tax_id = b.tax_rate_id
9884: AND avtb.vat_tax_id = avtt.vat_tax_id
9914: fnd_global.conc_login_id ,
9915: l.language_code ,
9916: userenv('LANG') ,
9917: Initcap(zrb.tax_rate_code)
9918: FROM zx_rates_b zrb,
9919: fnd_languages l
9920: WHERE L.INSTALLED_FLAG in ('I', 'B')
9921: AND zrb.RECORD_TYPE_CODE = 'MIGRATED'
9922: AND zrb.tax_jurisdiction_code IS NULL
9943: |
9944: | OUT
9945: |
9946: | DESCRIPTION
9947: | This routine inserts a record into zx_rates_b.
9948: |
9949: | SCOPE - PRIVATE
9950: |
9951: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
9973: IS
9974: BEGIN
9975: INSERT ALL
9976: WHEN (NOT EXISTS (SELECT 1
9977: FROM zx_rates_b
9978: WHERE tax_rate_code = p_tax_rate_code
9979: AND content_owner_id = p_content_owner_id
9980: AND active_flag = p_active_flag
9981: AND TRUNC(effective_from) = p_effective_from
9980: AND active_flag = p_active_flag
9981: AND TRUNC(effective_from) = p_effective_from
9982: )
9983: ) THEN
9984: INTO zx_rates_b_tmp
9985: (
9986: TAX_RATE_ID ,
9987: TAX_RATE_CODE ,
9988: CONTENT_OWNER_ID ,
10048: ALLOW_EXCEPTIONS_FLAG
10049: )
10050: VALUES
10051: (
10052: zx_rates_b_s.nextval , --TAX_RATE_ID
10053: p_tax_rate_code , --tax_rate_code
10054: p_content_owner_id , --content_owner_id
10055: p_effective_from , --effective_from
10056: NULL , --effective_to
10161: )
10162: VALUES
10163: (
10164: ZX_ACCOUNTS_S.nextval ,--TAX_ACCOUNT_ID
10165: zx_rates_b_s.nextval ,--TAX_RATE_ID
10166: 'RATES' ,--TAX_ACCOUNT_ENTITY_CODE
10167: p_ledger_id ,--LEDGER_ID
10168: p_org_id ,--ORG_ID
10169: p_tax_account_ccid ,--TAX_ACCOUNT_CCID
10315: FOR cursor_rec IN (SELECT party_id,
10316: party_tax_profile_id
10317: FROM zx_party_tax_profile
10318: WHERE party_tax_profile_id IN (SELECT content_owner_id
10319: FROM zx_rates_b
10320: WHERE tax_class = 'OUTPUT'
10321: INTERSECT
10322: SELECT content_owner_id
10323: FROM zx_rates_b
10319: FROM zx_rates_b
10320: WHERE tax_class = 'OUTPUT'
10321: INTERSECT
10322: SELECT content_owner_id
10323: FROM zx_rates_b
10324: WHERE tax_class = 'INPUT')
10325: AND party_type_code = 'OU'
10326: AND record_type_code = 'MIGRATED')
10327: LOOP