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.ZX_MIGRATE_TAX_DEF dependencies on ZX_TAXES_B

Line 204: UPDATE ZX_TAXES_B_TMP TAXES

200: arp_util_tax.debug('a:Migrate Recovery Rates');
201: --Bug 12837833
202: --Tail End Processing
203: BEGIN
204: UPDATE ZX_TAXES_B_TMP TAXES
205: SET PRIMARY_REC_TYPE_RULE_FLAG = 'Y',
206: PRIMARY_REC_RATE_DET_RULE_FLAG = 'Y'
207: WHERE EXISTS (SELECT 1
208: FROM ZX_RATES_B zx_rates,

Line 5652: (SELECT tax_id FROM zx_taxes_b WHERE tax_regime_code = rates.tax_regime_code AND tax = rates.tax AND content_owner_id = rates.content_owner_id)

5648: 'RECOVERY' RATE_TYPE_CODE,
5649: nvl(codes.tax_recovery_rate,0) PERCENTAGE_RATE,--Bug 5118399
5650: NULL QUANTITY_RATE ,
5651: NULL UOM_CODE,
5652: (SELECT tax_id FROM zx_taxes_b WHERE tax_regime_code = rates.tax_regime_code AND tax = rates.tax AND content_owner_id = rates.content_owner_id)
5653: TAX_JURISDICTION_CODE,--Bug 4943105
5654: 'STANDARD' RECOVERY_TYPE_CODE, --important
5655: 'Y' ACTIVE_FLAG,
5656: 'N' DEFAULT_RATE_FLAG ,

Line 5687: and tax_jurisdiction_code = (SELECT tax_id FROM zx_taxes_b WHERE tax_regime_code = rates.tax_regime_code

5683: AND ROWNUM = 1
5684: AND not exists (select 1 from zx_rates_b_tmp
5685: where SUBSTRB(tax_rate_code,1,24) = substrb(rates.default_rec_rate_code,1,24) --Bug 4943105
5686: and content_owner_id = rates.content_owner_id
5687: and tax_jurisdiction_code = (SELECT tax_id FROM zx_taxes_b WHERE tax_regime_code = rates.tax_regime_code
5688: AND tax = rates.tax AND content_owner_id = rates.content_owner_id)
5689: )
5690: );
5691:

Line 5922: (select tax_id from zx_taxes_b where tax = zx_rates.tax and tax_regime_code

5918: 'RECOVERY' RATE_TYPE_CODE,
5919: rates.recovery_rate PERCENTAGE_RATE,
5920: NULL QUANTITY_RATE ,
5921: NULL UOM_CODE,
5922: (select tax_id from zx_taxes_b where tax = zx_rates.tax and tax_regime_code
5923: = zx_rates.tax_regime_code and content_owner_id = zx_rates.content_owner_id )
5924: TAX_JURISDICTION_CODE,
5925: 'STANDARD' RECOVERY_TYPE_CODE, --important
5926: rates.enabled_flag ACTIVE_FLAG,

Line 5957: AND tax_jurisdiction_code = (select tax_id from zx_taxes_b where tax = zx_rates.tax and tax_regime_code

5953: 0,tax_rate_code,
5954: substrb(tax_rate_code,1,instrb(tax_rate_code,'-',1,2)-1)) = 'STANDARD-'|| rates.recovery_rate -- Bug 4644762
5955: and rate_type_code = 'RECOVERY'
5956: and content_owner_id = zx_rates.content_owner_id
5957: AND tax_jurisdiction_code = (select tax_id from zx_taxes_b where tax = zx_rates.tax and tax_regime_code
5958: = zx_rates.tax_regime_code and content_owner_id = zx_rates.content_owner_id )
5959: )
5960: );
5961: exception when others then

Line 6125: zx_taxes_b taxes

6121: NULL RECOVERY_RULE_CODE ,
6122: NULL DEF_REC_SETTLEMENT_OPTION_CODE,
6123: 'MIGRATED' RECORD_TYPE_CODE
6124: FROM
6125: zx_taxes_b taxes
6126: WHERE taxes.ALLOW_RECOVERABILITY_FLAG = 'Y'
6127: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
6128: -- Re-runnability Check
6129: AND not exists (select 1 from zx_rates_b

Line 6763: | This routine inserts data into ZX_TAXES_B,_TL based on the |

6759: | PROCEDURE |
6760: | create_zx_taxes |
6761: | |
6762: | DESCRIPTION |
6763: | This routine inserts data into ZX_TAXES_B,_TL based on the |
6764: | above inserted data into ZX_RATES_B. |
6765: | |
6766: | SCOPE - PUBLIC |
6767: | |

Line 6794: INSERT INTO ZX_TAXES_B_TMP

6790: BEGIN
6791:
6792: IF L_MULTI_ORG_FLAG = 'Y'
6793: THEN
6794: INSERT INTO ZX_TAXES_B_TMP
6795: (
6796: TAX ,
6797: EFFECTIVE_FROM ,
6798: EFFECTIVE_TO ,

Line 7044: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID

7040: NULL ,--PARENT_GEOGRAPHY_TYPE
7041: NULL ,--PARENT_GEOGRAPHY_ID
7042: 'N' ,--ALLOW_MASS_CREATE_FLAG
7043: 'P' ,--APPLIED_AMT_HANDLING_FLAG
7044: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID
7045: l_CONTENT_OWNER_ID ,
7046: REP_TAX_AUTHORITY_ID ,
7047: COLL_TAX_AUTHORITY_ID ,
7048: NULL ,--THRSHLD_CHK_TMPLT_CODE

Line 7143: AND not exists (select 1 from zx_taxes_b

7139: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
7140: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
7141: --Added following conditions for Sync process
7142: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
7143: AND not exists (select 1 from zx_taxes_b
7144: where tax_regime_code = rates.tax_regime_code
7145: and tax = rates.tax
7146: and content_owner_id= rates.content_owner_id
7147: )

Line 7185: INSERT INTO ZX_TAXES_B_TMP

7181:
7182: );
7183: ELSE
7184:
7185: INSERT INTO ZX_TAXES_B_TMP
7186: (
7187: TAX ,
7188: EFFECTIVE_FROM ,
7189: EFFECTIVE_TO ,

Line 7436: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID

7432: NULL ,--PARENT_GEOGRAPHY_TYPE
7433: NULL ,--PARENT_GEOGRAPHY_ID
7434: 'N' ,--ALLOW_MASS_CREATE_FLAG
7435: 'P' ,--APPLIED_AMT_HANDLING_FLAG
7436: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID
7437: l_CONTENT_OWNER_ID ,
7438: REP_TAX_AUTHORITY_ID ,
7439: COLL_TAX_AUTHORITY_ID ,
7440: NULL ,--THRSHLD_CHK_TMPLT_CODE

Line 7536: AND not exists (select 1 from zx_taxes_b

7532: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
7533: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
7534: --Added following conditions for Sync process
7535: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
7536: AND not exists (select 1 from zx_taxes_b
7537: where tax_regime_code = rates.tax_regime_code
7538: and tax = rates.tax
7539: and content_owner_id= rates.content_owner_id
7540: )

Line 7589: INSERT INTO ZX_TAXES_B_TMP

7585:
7586: IF L_MULTI_ORG_FLAG = 'Y'
7587: THEN
7588:
7589: INSERT INTO ZX_TAXES_B_TMP
7590: (
7591: TAX ,
7592: EFFECTIVE_FROM ,
7593: EFFECTIVE_TO ,

Line 7839: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID

7835: NULL ,--PARENT_GEOGRAPHY_TYPE
7836: NULL ,--PARENT_GEOGRAPHY_ID
7837: 'N' ,--ALLOW_MASS_CREATE_FLAG
7838: 'P' ,--APPLIED_AMT_HANDLING_FLAG
7839: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID
7840: l_CONTENT_OWNER_ID ,
7841: REP_TAX_AUTHORITY_ID ,
7842: COLL_TAX_AUTHORITY_ID ,
7843: NULL ,--THRSHLD_CHK_TMPLT_CODE

Line 7942: AND not exists (select 1 from zx_taxes_b

7938: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
7939: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
7940: --Added following conditions for Sync process
7941: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
7942: AND not exists (select 1 from zx_taxes_b
7943: where tax_regime_code = rates.tax_regime_code
7944: and tax = rates.tax
7945: and content_owner_id= rates.content_owner_id
7946: )

Line 8014: INSERT INTO ZX_TAXES_B_TMP

8010: AND global_attribute1 = lookup_code) --Review1 changes
8011: ) lookups;
8012: ELSE
8013:
8014: INSERT INTO ZX_TAXES_B_TMP
8015: (
8016: TAX ,
8017: EFFECTIVE_FROM ,
8018: EFFECTIVE_TO ,

Line 8264: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID

8260: NULL ,--PARENT_GEOGRAPHY_TYPE
8261: NULL ,--PARENT_GEOGRAPHY_ID
8262: 'N' ,--ALLOW_MASS_CREATE_FLAG
8263: 'P' ,--APPLIED_AMT_HANDLING_FLAG
8264: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID
8265: l_CONTENT_OWNER_ID ,
8266: REP_TAX_AUTHORITY_ID ,
8267: COLL_TAX_AUTHORITY_ID ,
8268: NULL ,--THRSHLD_CHK_TMPLT_CODE

Line 8368: AND not exists (select 1 from zx_taxes_b

8364: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
8365: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
8366: --Added following conditions for Sync process
8367: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
8368: AND not exists (select 1 from zx_taxes_b
8369: where tax_regime_code = rates.tax_regime_code
8370: and tax = rates.tax
8371: and content_owner_id= rates.content_owner_id
8372: )

Line 8493: zx_taxes_b taxes,

8489: fnd_global.user_id ,
8490: fnd_global.conc_login_id ,
8491: taxes.tax_id
8492: FROM
8493: zx_taxes_b taxes,
8494: zx_rates_b rates,
8495: fnd_lookup_values flv,
8496: ap_tax_codes_all ap_code
8497: WHERE

Line 8543: zx_taxes_b taxes,

8539: fnd_global.user_id ,
8540: fnd_global.conc_login_id ,
8541: taxes.tax_id
8542: FROM
8543: zx_taxes_b taxes,
8544: zx_rates_b rates,
8545: fnd_lookup_values flv,
8546: ap_tax_codes_all ap_code
8547: WHERE

Line 8590: zx_taxes_b taxes,

8586: fnd_global.user_id ,
8587: fnd_global.conc_login_id ,
8588: taxes.tax_id
8589: FROM
8590: zx_taxes_b taxes,
8591: zx_rates_b rates,
8592: fnd_lookup_values flv,
8593: ap_tax_codes_all ap_code
8594: WHERE

Line 8637: zx_taxes_b taxes,

8633: fnd_global.user_id ,
8634: fnd_global.conc_login_id ,
8635: taxes.tax_id
8636: FROM
8637: zx_taxes_b taxes,
8638: zx_rates_b rates,
8639: fnd_lookup_values flv,
8640: ap_tax_codes_all ap_code
8641: WHERE

Line 8694: ZX_TAXES_B B

8690: fnd_global.conc_login_id ,
8691: B.TAX_ID
8692: FROM
8693: FND_LANGUAGES L,
8694: ZX_TAXES_B B
8695: WHERE
8696: L.INSTALLED_FLAG in ('I', 'B')
8697: AND RECORD_TYPE_CODE = 'MIGRATED'
8698: AND not exists

Line 8707: --Bug : 5092560 : This is to populate the ZX_TAXES_B.legal_reporting_status_def_val with '000000000000000'

8703: EXCEPTION WHEN OTHERS THEN
8704: NULL;
8705: END;
8706:
8707: --Bug : 5092560 : This is to populate the ZX_TAXES_B.legal_reporting_status_def_val with '000000000000000'
8708:
8709: BEGIN
8710:
8711: update zx_taxes_b_tmp

Line 8711: update zx_taxes_b_tmp

8707: --Bug : 5092560 : This is to populate the ZX_TAXES_B.legal_reporting_status_def_val with '000000000000000'
8708:
8709: BEGIN
8710:
8711: update zx_taxes_b_tmp
8712: set legal_reporting_status_def_val = '000000000000000'
8713: WHERE record_type_code = 'MIGRATED'
8714: AND tax_regime_code in (
8715: select distinct tax_regime_code from zx_regimes_b

Line 10389: ZX_TAXES_B taxes

10385: accounts.internal_organization_id
10386: FROM
10387: ZX_ACCOUNTS accounts,
10388: ZX_RATES_B rates,
10389: ZX_TAXES_B taxes
10390: WHERE taxes.tax = rates.tax
10391: and taxes.tax_regime_code = rates.tax_regime_code
10392: and taxes.content_owner_id = rates.content_owner_id
10393: and rates.tax_rate_id = accounts.tax_account_entity_id

Line 10404: TYPE tax_id_tab IS TABLE OF ZX_TAXES_B.TAX_ID%TYPE

10400:
10401:
10402:
10403: ------------------------pl/sql table declarations----------------------------
10404: TYPE tax_id_tab IS TABLE OF ZX_TAXES_B.TAX_ID%TYPE
10405: INDEX BY BINARY_INTEGER;
10406:
10407: TYPE ac_id_tab IS TABLE OF ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE
10408: INDEX BY BINARY_INTEGER;

Line 10441: v_prev_tax_id ZX_TAXES_B.TAX_ID%TYPE;

10437: v_max_row_index number;
10438: v_count number;
10439: v_insert_flag boolean;
10440:
10441: v_prev_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10442: v_prev_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10443: v_current_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10444: v_current_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10445:

Line 10443: v_current_tax_id ZX_TAXES_B.TAX_ID%TYPE;

10439: v_insert_flag boolean;
10440:
10441: v_prev_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10442: v_prev_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10443: v_current_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10444: v_current_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10445:
10446:
10447: BEGIN