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 6171: | This routine inserts data into ZX_STATUS_B,_TL based on the |

6167: | PROCEDURE |
6168: | create_zx_statuses |
6169: | |
6170: | DESCRIPTION |
6171: | This routine inserts data into ZX_STATUS_B,_TL based on the |
6172: | above inserted data into ZX_RATES_B. |
6173: | |
6174: | SCOPE - PUBLIC |
6175: | |

Line 6201: INSERT INTO ZX_STATUS_B_TMP

6197: END IF;
6198:
6199: BEGIN
6200:
6201: INSERT INTO ZX_STATUS_B_TMP
6202: (
6203: TAX_STATUS_ID,
6204: TAX_STATUS_CODE,
6205: EFFECTIVE_FROM,

Line 6247: ZX_STATUS_B_S.NEXTVAL,

6243: OBJECT_VERSION_NUMBER
6244: )
6245:
6246: SELECT
6247: ZX_STATUS_B_S.NEXTVAL,
6248: TAX_STATUS_CODE,
6249: EFFECTIVE_FROM,
6250: NULL,
6251: TAX,

Line 6300: AND not exists (select 1 from zx_status_b

6296: rates.record_type_code = 'MIGRATED'
6297: AND rates.tax_status_code IS NOT NULL
6298: --Added following conditions for Sync process
6299: AND rates.tax_rate_id = nvl(p_tax_id,rates.tax_rate_id)
6300: AND not exists (select 1 from zx_status_b
6301: where tax_regime_code = rates.tax_regime_code
6302: and tax = rates.tax
6303: and tax_status_code = rates.tax_status_code
6304: and content_owner_id = rates.content_owner_id

Line 6338: INSERT INTO ZX_STATUS_B_TMP

6334: IF L_MULTI_ORG_FLAG = 'Y'
6335: THEN
6336:
6337: -- For Unused JATW_GOVERNMENT_TAX_TYPE lookup code
6338: INSERT INTO ZX_STATUS_B_TMP
6339: (
6340: TAX_STATUS_ID,
6341: TAX_STATUS_CODE,
6342: EFFECTIVE_FROM,

Line 6383: ZX_STATUS_B_S.NEXTVAL,

6379: REQUEST_ID,
6380: OBJECT_VERSION_NUMBER
6381: )
6382: SELECT
6383: ZX_STATUS_B_S.NEXTVAL,
6384: lookups.lookup_code, --TAX_STATUS_CODE
6385: EFFECTIVE_FROM,
6386: NULL,
6387: TAX,

Line 6461: (SELECT 1 FROM ZX_STATUS_B

6457: WHERE global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES'
6458: and global_attribute1 is not null
6459: ) lookups
6460: WHERE NOT EXISTS
6461: (SELECT 1 FROM ZX_STATUS_B
6462: WHERE
6463: TAX_REGIME_CODE= Statuses.TAX_REGIME_CODE
6464: AND TAX = Statuses.TAX
6465: AND TAX_STATUS_CODE=lookups.lookup_code

Line 6471: INSERT INTO ZX_STATUS_B_TMP

6467: );
6468:
6469:
6470: ELSE
6471: INSERT INTO ZX_STATUS_B_TMP
6472: (
6473: TAX_STATUS_ID,
6474: TAX_STATUS_CODE,
6475: EFFECTIVE_FROM,

Line 6516: ZX_STATUS_B_S.NEXTVAL,

6512: REQUEST_ID,
6513: OBJECT_VERSION_NUMBER
6514: )
6515: SELECT
6516: ZX_STATUS_B_S.NEXTVAL,
6517: lookups.lookup_code, --TAX_STATUS_CODE
6518: EFFECTIVE_FROM,
6519: NULL,
6520: TAX,

Line 6594: (SELECT 1 FROM ZX_STATUS_B

6590: WHERE global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES'
6591: and global_attribute1 is not null
6592: ) lookups
6593: WHERE NOT EXISTS
6594: (SELECT 1 FROM ZX_STATUS_B
6595: WHERE
6596: TAX_REGIME_CODE= Statuses.TAX_REGIME_CODE
6597: AND TAX = Statuses.TAX
6598: AND TAX_STATUS_CODE=lookups.lookup_code

Line 6636: ZX_STATUS_B Status,

6632: L.LANGUAGE_CODE,
6633: userenv('LANG')
6634: FROM
6635: FND_LANGUAGES L,
6636: ZX_STATUS_B Status,
6637: JA_LOOKUPS lookups,
6638: ap_tax_codes_all codes,
6639: ZX_RATES_B rates
6640: WHERE

Line 6699: ZX_STATUS_B B

6695: L.LANGUAGE_CODE,
6696: userenv('LANG')
6697: FROM
6698: FND_LANGUAGES L,
6699: ZX_STATUS_B B
6700: WHERE
6701: L.INSTALLED_FLAG in ('I', 'B')
6702: AND RECORD_TYPE_CODE = 'MIGRATED'
6703: AND not exists