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 5622: (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)

5618: 'RECOVERY' RATE_TYPE_CODE,
5619: nvl(codes.tax_recovery_rate,0) PERCENTAGE_RATE,--Bug 5118399
5620: NULL QUANTITY_RATE ,
5621: NULL UOM_CODE,
5622: (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)
5623: TAX_JURISDICTION_CODE,--Bug 4943105
5624: 'STANDARD' RECOVERY_TYPE_CODE, --important
5625: 'Y' ACTIVE_FLAG,
5626: 'N' DEFAULT_RATE_FLAG ,

Line 5657: and tax_jurisdiction_code = (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: AND ROWNUM = 1
5654: AND not exists (select 1 from zx_rates_b_tmp
5655: where SUBSTRB(tax_rate_code,1,24) = substrb(rates.default_rec_rate_code,1,24) --Bug 4943105
5656: and content_owner_id = rates.content_owner_id
5657: and tax_jurisdiction_code = (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)
5658: )
5659: );
5660:
5661:

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

5887: 'RECOVERY' RATE_TYPE_CODE,
5888: rates.recovery_rate PERCENTAGE_RATE,
5889: NULL QUANTITY_RATE ,
5890: NULL UOM_CODE,
5891: (select tax_id from zx_taxes_b where tax = zx_rates.tax and tax_regime_code
5892: = zx_rates.tax_regime_code and content_owner_id = zx_rates.content_owner_id )
5893: TAX_JURISDICTION_CODE,
5894: 'STANDARD' RECOVERY_TYPE_CODE, --important
5895: rates.enabled_flag ACTIVE_FLAG,

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

5922: 0,tax_rate_code,
5923: substrb(tax_rate_code,1,instrb(tax_rate_code,'-',1,2)-1)) = 'STANDARD-'|| rates.recovery_rate -- Bug 4644762
5924: and rate_type_code = 'RECOVERY'
5925: and content_owner_id = zx_rates.content_owner_id
5926: AND tax_jurisdiction_code = (select tax_id from zx_taxes_b where tax = zx_rates.tax and tax_regime_code
5927: = zx_rates.tax_regime_code and content_owner_id = zx_rates.content_owner_id )
5928: )
5929: );
5930: exception when others then

Line 6094: zx_taxes_b taxes

6090: NULL RECOVERY_RULE_CODE ,
6091: NULL DEF_REC_SETTLEMENT_OPTION_CODE,
6092: 'MIGRATED' RECORD_TYPE_CODE
6093: FROM
6094: zx_taxes_b taxes
6095: WHERE taxes.ALLOW_RECOVERABILITY_FLAG = 'Y'
6096: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
6097: -- Re-runnability Check
6098: AND not exists (select 1 from zx_rates_b

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

6728: | PROCEDURE |
6729: | create_zx_taxes |
6730: | |
6731: | DESCRIPTION |
6732: | This routine inserts data into ZX_TAXES_B,_TL based on the |
6733: | above inserted data into ZX_RATES_B. |
6734: | |
6735: | SCOPE - PUBLIC |
6736: | |

Line 6763: INSERT INTO ZX_TAXES_B_TMP

6759: BEGIN
6760:
6761: IF L_MULTI_ORG_FLAG = 'Y'
6762: THEN
6763: INSERT INTO ZX_TAXES_B_TMP
6764: (
6765: TAX ,
6766: EFFECTIVE_FROM ,
6767: EFFECTIVE_TO ,

Line 7016: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID

7012: NULL ,--PARENT_GEOGRAPHY_TYPE
7013: NULL ,--PARENT_GEOGRAPHY_ID
7014: 'N' ,--ALLOW_MASS_CREATE_FLAG
7015: 'P' ,--APPLIED_AMT_HANDLING_FLAG
7016: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID
7017: l_CONTENT_OWNER_ID ,
7018: REP_TAX_AUTHORITY_ID ,
7019: COLL_TAX_AUTHORITY_ID ,
7020: NULL ,--THRSHLD_CHK_TMPLT_CODE

Line 7117: AND not exists (select 1 from zx_taxes_b

7113: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
7114: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
7115: --Added following conditions for Sync process
7116: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
7117: AND not exists (select 1 from zx_taxes_b
7118: where tax_regime_code = rates.tax_regime_code
7119: and tax = rates.tax
7120: and content_owner_id= rates.content_owner_id
7121: )

Line 7159: INSERT INTO ZX_TAXES_B_TMP

7155:
7156: );
7157: ELSE
7158:
7159: INSERT INTO ZX_TAXES_B_TMP
7160: (
7161: TAX ,
7162: EFFECTIVE_FROM ,
7163: EFFECTIVE_TO ,

Line 7412: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID

7408: NULL ,--PARENT_GEOGRAPHY_TYPE
7409: NULL ,--PARENT_GEOGRAPHY_ID
7410: 'N' ,--ALLOW_MASS_CREATE_FLAG
7411: 'P' ,--APPLIED_AMT_HANDLING_FLAG
7412: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID
7413: l_CONTENT_OWNER_ID ,
7414: REP_TAX_AUTHORITY_ID ,
7415: COLL_TAX_AUTHORITY_ID ,
7416: NULL ,--THRSHLD_CHK_TMPLT_CODE

Line 7514: AND not exists (select 1 from zx_taxes_b

7510: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
7511: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
7512: --Added following conditions for Sync process
7513: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
7514: AND not exists (select 1 from zx_taxes_b
7515: where tax_regime_code = rates.tax_regime_code
7516: and tax = rates.tax
7517: and content_owner_id= rates.content_owner_id
7518: )

Line 7567: INSERT INTO ZX_TAXES_B_TMP

7563:
7564: IF L_MULTI_ORG_FLAG = 'Y'
7565: THEN
7566:
7567: INSERT INTO ZX_TAXES_B_TMP
7568: (
7569: TAX ,
7570: EFFECTIVE_FROM ,
7571: EFFECTIVE_TO ,

Line 7817: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID

7813: NULL ,--PARENT_GEOGRAPHY_TYPE
7814: NULL ,--PARENT_GEOGRAPHY_ID
7815: 'N' ,--ALLOW_MASS_CREATE_FLAG
7816: 'P' ,--APPLIED_AMT_HANDLING_FLAG
7817: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID
7818: l_CONTENT_OWNER_ID ,
7819: REP_TAX_AUTHORITY_ID ,
7820: COLL_TAX_AUTHORITY_ID ,
7821: NULL ,--THRSHLD_CHK_TMPLT_CODE

Line 7920: AND not exists (select 1 from zx_taxes_b

7916: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
7917: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
7918: --Added following conditions for Sync process
7919: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
7920: AND not exists (select 1 from zx_taxes_b
7921: where tax_regime_code = rates.tax_regime_code
7922: and tax = rates.tax
7923: and content_owner_id= rates.content_owner_id
7924: )

Line 7992: INSERT INTO ZX_TAXES_B_TMP

7988: AND global_attribute1 = lookup_code) --Review1 changes
7989: ) lookups;
7990: ELSE
7991:
7992: INSERT INTO ZX_TAXES_B_TMP
7993: (
7994: TAX ,
7995: EFFECTIVE_FROM ,
7996: EFFECTIVE_TO ,

Line 8242: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID

8238: NULL ,--PARENT_GEOGRAPHY_TYPE
8239: NULL ,--PARENT_GEOGRAPHY_ID
8240: 'N' ,--ALLOW_MASS_CREATE_FLAG
8241: 'P' ,--APPLIED_AMT_HANDLING_FLAG
8242: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID
8243: l_CONTENT_OWNER_ID ,
8244: REP_TAX_AUTHORITY_ID ,
8245: COLL_TAX_AUTHORITY_ID ,
8246: NULL ,--THRSHLD_CHK_TMPLT_CODE

Line 8346: AND not exists (select 1 from zx_taxes_b

8342: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
8343: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
8344: --Added following conditions for Sync process
8345: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
8346: AND not exists (select 1 from zx_taxes_b
8347: where tax_regime_code = rates.tax_regime_code
8348: and tax = rates.tax
8349: and content_owner_id= rates.content_owner_id
8350: )

Line 8471: zx_taxes_b taxes,

8467: fnd_global.user_id ,
8468: fnd_global.conc_login_id ,
8469: taxes.tax_id
8470: FROM
8471: zx_taxes_b taxes,
8472: zx_rates_b rates,
8473: fnd_lookup_values flv,
8474: ap_tax_codes_all ap_code
8475: WHERE

Line 8521: zx_taxes_b taxes,

8517: fnd_global.user_id ,
8518: fnd_global.conc_login_id ,
8519: taxes.tax_id
8520: FROM
8521: zx_taxes_b taxes,
8522: zx_rates_b rates,
8523: fnd_lookup_values flv,
8524: ap_tax_codes_all ap_code
8525: WHERE

Line 8568: zx_taxes_b taxes,

8564: fnd_global.user_id ,
8565: fnd_global.conc_login_id ,
8566: taxes.tax_id
8567: FROM
8568: zx_taxes_b taxes,
8569: zx_rates_b rates,
8570: fnd_lookup_values flv,
8571: ap_tax_codes_all ap_code
8572: WHERE

Line 8615: zx_taxes_b taxes,

8611: fnd_global.user_id ,
8612: fnd_global.conc_login_id ,
8613: taxes.tax_id
8614: FROM
8615: zx_taxes_b taxes,
8616: zx_rates_b rates,
8617: fnd_lookup_values flv,
8618: ap_tax_codes_all ap_code
8619: WHERE

Line 8672: ZX_TAXES_B B

8668: fnd_global.conc_login_id ,
8669: B.TAX_ID
8670: FROM
8671: FND_LANGUAGES L,
8672: ZX_TAXES_B B
8673: WHERE
8674: L.INSTALLED_FLAG in ('I', 'B')
8675: AND RECORD_TYPE_CODE = 'MIGRATED'
8676: AND not exists

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

8681: EXCEPTION WHEN OTHERS THEN
8682: NULL;
8683: END;
8684:
8685: --Bug : 5092560 : This is to populate the ZX_TAXES_B.legal_reporting_status_def_val with '000000000000000'
8686:
8687: BEGIN
8688:
8689: update zx_taxes_b_tmp

Line 8689: update zx_taxes_b_tmp

8685: --Bug : 5092560 : This is to populate the ZX_TAXES_B.legal_reporting_status_def_val with '000000000000000'
8686:
8687: BEGIN
8688:
8689: update zx_taxes_b_tmp
8690: set legal_reporting_status_def_val = '000000000000000'
8691: WHERE record_type_code = 'MIGRATED'
8692: AND tax_regime_code in (
8693: select distinct tax_regime_code from zx_regimes_b

Line 10058: ZX_TAXES_B taxes

10054: accounts.internal_organization_id
10055: FROM
10056: ZX_ACCOUNTS accounts,
10057: ZX_RATES_B rates,
10058: ZX_TAXES_B taxes
10059: WHERE taxes.tax = rates.tax
10060: and taxes.tax_regime_code = rates.tax_regime_code
10061: and taxes.content_owner_id = rates.content_owner_id
10062: and rates.tax_rate_id = accounts.tax_account_entity_id

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

10067:
10068:
10069:
10070: ------------------------pl/sql table declarations----------------------------
10071: TYPE tax_id_tab IS TABLE OF ZX_TAXES_B.TAX_ID%TYPE
10072: INDEX BY BINARY_INTEGER;
10073:
10074: TYPE ac_id_tab IS TABLE OF ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE
10075: INDEX BY BINARY_INTEGER;

Line 10108: v_prev_tax_id ZX_TAXES_B.TAX_ID%TYPE;

10104: v_max_row_index number;
10105: v_count number;
10106: v_insert_flag boolean;
10107:
10108: v_prev_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10109: v_prev_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10110: v_current_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10111: v_current_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10112:

Line 10110: v_current_tax_id ZX_TAXES_B.TAX_ID%TYPE;

10106: v_insert_flag boolean;
10107:
10108: v_prev_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10109: v_prev_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10110: v_current_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10111: v_current_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10112:
10113:
10114: BEGIN