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_STATUS_B

Line 6202: | This routine inserts data into ZX_STATUS_B,_TL based on the |

6198: | PROCEDURE |
6199: | create_zx_statuses |
6200: | |
6201: | DESCRIPTION |
6202: | This routine inserts data into ZX_STATUS_B,_TL based on the |
6203: | above inserted data into ZX_RATES_B. |
6204: | |
6205: | SCOPE - PUBLIC |
6206: | |

Line 6232: INSERT INTO ZX_STATUS_B_TMP

6228: END IF;
6229:
6230: BEGIN
6231:
6232: INSERT INTO ZX_STATUS_B_TMP
6233: (
6234: TAX_STATUS_ID,
6235: TAX_STATUS_CODE,
6236: EFFECTIVE_FROM,

Line 6278: ZX_STATUS_B_S.NEXTVAL,

6274: OBJECT_VERSION_NUMBER
6275: )
6276:
6277: SELECT
6278: ZX_STATUS_B_S.NEXTVAL,
6279: TAX_STATUS_CODE,
6280: EFFECTIVE_FROM,
6281: NULL,
6282: TAX,

Line 6331: AND not exists (select 1 from zx_status_b

6327: rates.record_type_code = 'MIGRATED'
6328: AND rates.tax_status_code IS NOT NULL
6329: --Added following conditions for Sync process
6330: AND rates.tax_rate_id = nvl(p_tax_id,rates.tax_rate_id)
6331: AND not exists (select 1 from zx_status_b
6332: where tax_regime_code = rates.tax_regime_code
6333: and tax = rates.tax
6334: and tax_status_code = rates.tax_status_code
6335: and content_owner_id = rates.content_owner_id

Line 6369: INSERT INTO ZX_STATUS_B_TMP

6365: IF L_MULTI_ORG_FLAG = 'Y'
6366: THEN
6367:
6368: -- For Unused JATW_GOVERNMENT_TAX_TYPE lookup code
6369: INSERT INTO ZX_STATUS_B_TMP
6370: (
6371: TAX_STATUS_ID,
6372: TAX_STATUS_CODE,
6373: EFFECTIVE_FROM,

Line 6414: ZX_STATUS_B_S.NEXTVAL,

6410: REQUEST_ID,
6411: OBJECT_VERSION_NUMBER
6412: )
6413: SELECT
6414: ZX_STATUS_B_S.NEXTVAL,
6415: lookups.lookup_code, --TAX_STATUS_CODE
6416: EFFECTIVE_FROM,
6417: NULL,
6418: TAX,

Line 6492: (SELECT 1 FROM ZX_STATUS_B

6488: WHERE global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES'
6489: and global_attribute1 is not null
6490: ) lookups
6491: WHERE NOT EXISTS
6492: (SELECT 1 FROM ZX_STATUS_B
6493: WHERE
6494: TAX_REGIME_CODE= Statuses.TAX_REGIME_CODE
6495: AND TAX = Statuses.TAX
6496: AND TAX_STATUS_CODE=lookups.lookup_code

Line 6502: INSERT INTO ZX_STATUS_B_TMP

6498: );
6499:
6500:
6501: ELSE
6502: INSERT INTO ZX_STATUS_B_TMP
6503: (
6504: TAX_STATUS_ID,
6505: TAX_STATUS_CODE,
6506: EFFECTIVE_FROM,

Line 6547: ZX_STATUS_B_S.NEXTVAL,

6543: REQUEST_ID,
6544: OBJECT_VERSION_NUMBER
6545: )
6546: SELECT
6547: ZX_STATUS_B_S.NEXTVAL,
6548: lookups.lookup_code, --TAX_STATUS_CODE
6549: EFFECTIVE_FROM,
6550: NULL,
6551: TAX,

Line 6625: (SELECT 1 FROM ZX_STATUS_B

6621: WHERE global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES'
6622: and global_attribute1 is not null
6623: ) lookups
6624: WHERE NOT EXISTS
6625: (SELECT 1 FROM ZX_STATUS_B
6626: WHERE
6627: TAX_REGIME_CODE= Statuses.TAX_REGIME_CODE
6628: AND TAX = Statuses.TAX
6629: AND TAX_STATUS_CODE=lookups.lookup_code

Line 6667: ZX_STATUS_B Status,

6663: L.LANGUAGE_CODE,
6664: userenv('LANG')
6665: FROM
6666: FND_LANGUAGES L,
6667: ZX_STATUS_B Status,
6668: JA_LOOKUPS lookups,
6669: ap_tax_codes_all codes,
6670: ZX_RATES_B rates
6671: WHERE

Line 6730: ZX_STATUS_B B

6726: L.LANGUAGE_CODE,
6727: userenv('LANG')
6728: FROM
6729: FND_LANGUAGES L,
6730: ZX_STATUS_B B
6731: WHERE
6732: L.INSTALLED_FLAG in ('I', 'B')
6733: AND RECORD_TYPE_CODE = 'MIGRATED'
6734: AND not exists