[Home] [Help]
1244: NULL ,--THRSHLD_CHK_TMPLT_CODE
1245: NULL ,--PERIOD_SET_NAME
1246: NULL ,--REP_TAX_AUTHORITY_ID
1247: NULL ,--COLL_TAX_AUTHORITY_ID
1248: fnd_global.user_id ,
1249: SYSDATE ,
1250: fnd_global.user_id ,
1251: SYSDATE ,
1252: fnd_global.conc_login_id ,
1246: NULL ,--REP_TAX_AUTHORITY_ID
1247: NULL ,--COLL_TAX_AUTHORITY_ID
1248: fnd_global.user_id ,
1249: SYSDATE ,
1250: fnd_global.user_id ,
1251: SYSDATE ,
1252: fnd_global.conc_login_id ,
1253: fnd_global.conc_request_id ,--Request Id
1254: fnd_global.prog_appl_id ,--Program Application ID
1248: fnd_global.user_id ,
1249: SYSDATE ,
1250: fnd_global.user_id ,
1251: SYSDATE ,
1252: fnd_global.conc_login_id ,
1253: fnd_global.conc_request_id ,--Request Id
1254: fnd_global.prog_appl_id ,--Program Application ID
1255: fnd_global.conc_program_id ,--Program Id
1256: fnd_global.conc_login_id , --Program Login ID
1249: SYSDATE ,
1250: fnd_global.user_id ,
1251: SYSDATE ,
1252: fnd_global.conc_login_id ,
1253: fnd_global.conc_request_id ,--Request Id
1254: fnd_global.prog_appl_id ,--Program Application ID
1255: fnd_global.conc_program_id ,--Program Id
1256: fnd_global.conc_login_id , --Program Login ID
1257: 1
1250: fnd_global.user_id ,
1251: SYSDATE ,
1252: fnd_global.conc_login_id ,
1253: fnd_global.conc_request_id ,--Request Id
1254: fnd_global.prog_appl_id ,--Program Application ID
1255: fnd_global.conc_program_id ,--Program Id
1256: fnd_global.conc_login_id , --Program Login ID
1257: 1
1258: )
1251: SYSDATE ,
1252: fnd_global.conc_login_id ,
1253: fnd_global.conc_request_id ,--Request Id
1254: fnd_global.prog_appl_id ,--Program Application ID
1255: fnd_global.conc_program_id ,--Program Id
1256: fnd_global.conc_login_id , --Program Login ID
1257: 1
1258: )
1259:
1252: fnd_global.conc_login_id ,
1253: fnd_global.conc_request_id ,--Request Id
1254: fnd_global.prog_appl_id ,--Program Application ID
1255: fnd_global.conc_program_id ,--Program Id
1256: fnd_global.conc_login_id , --Program Login ID
1257: 1
1258: )
1259:
1260: WHEN (NOT EXISTS (SELECT 1
1279: userenv('LANG'),
1280: userenv('LANG'),
1281: l_tax_regime_name,
1282: SYSDATE,
1283: fnd_global.user_id ,
1284: SYSDATE ,
1285: fnd_global.user_id ,
1286: fnd_global.conc_login_id ,
1287: ZX_REGIMES_B_S.NEXTVAL
1281: l_tax_regime_name,
1282: SYSDATE,
1283: fnd_global.user_id ,
1284: SYSDATE ,
1285: fnd_global.user_id ,
1286: fnd_global.conc_login_id ,
1287: ZX_REGIMES_B_S.NEXTVAL
1288: )
1289: SELECT 1 FROM DUAL;
1282: SYSDATE,
1283: fnd_global.user_id ,
1284: SYSDATE ,
1285: fnd_global.user_id ,
1286: fnd_global.conc_login_id ,
1287: ZX_REGIMES_B_S.NEXTVAL
1288: )
1289: SELECT 1 FROM DUAL;
1290:
2077: NULL L_COLL_TAX_AUTHORITY_ID,
2078: NULL L_THRSHLD_CHK_TMPLT_CODE,
2079: NULL L_DEF_PRIMARY_REC_RATE_CODE,
2080: NULL L_DEF_SECONDARY_REC_RATE_CODE,
2081: fnd_global.user_id L_CREATED_BY,
2082: SYSDATE L_CREATION_DATE,
2083: fnd_global.user_id L_LAST_UPDATED_BY,
2084: SYSDATE L_LAST_UPDATE_DATE,
2085: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2079: NULL L_DEF_PRIMARY_REC_RATE_CODE,
2080: NULL L_DEF_SECONDARY_REC_RATE_CODE,
2081: fnd_global.user_id L_CREATED_BY,
2082: SYSDATE L_CREATION_DATE,
2083: fnd_global.user_id L_LAST_UPDATED_BY,
2084: SYSDATE L_LAST_UPDATE_DATE,
2085: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2086: fnd_global.conc_request_id L_REQUEST_ID,
2087: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2081: fnd_global.user_id L_CREATED_BY,
2082: SYSDATE L_CREATION_DATE,
2083: fnd_global.user_id L_LAST_UPDATED_BY,
2084: SYSDATE L_LAST_UPDATE_DATE,
2085: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2086: fnd_global.conc_request_id L_REQUEST_ID,
2087: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2088: fnd_global.conc_program_id L_PROGRAM_ID,
2089: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2082: SYSDATE L_CREATION_DATE,
2083: fnd_global.user_id L_LAST_UPDATED_BY,
2084: SYSDATE L_LAST_UPDATE_DATE,
2085: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2086: fnd_global.conc_request_id L_REQUEST_ID,
2087: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2088: fnd_global.conc_program_id L_PROGRAM_ID,
2089: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2090: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2083: fnd_global.user_id L_LAST_UPDATED_BY,
2084: SYSDATE L_LAST_UPDATE_DATE,
2085: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2086: fnd_global.conc_request_id L_REQUEST_ID,
2087: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2088: fnd_global.conc_program_id L_PROGRAM_ID,
2089: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2090: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2091: NULL L_TAX_ACCOUNT_SOURCE_TAX , --Bug 4204464
2084: SYSDATE L_LAST_UPDATE_DATE,
2085: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2086: fnd_global.conc_request_id L_REQUEST_ID,
2087: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2088: fnd_global.conc_program_id L_PROGRAM_ID,
2089: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2090: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2091: NULL L_TAX_ACCOUNT_SOURCE_TAX , --Bug 4204464
2092: 'CREATE_EXEMPTIONS' L_TAX_EXMPT_CR_MTHD_CD , --Bug 4204464
2085: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2086: fnd_global.conc_request_id L_REQUEST_ID,
2087: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2088: fnd_global.conc_program_id L_PROGRAM_ID,
2089: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2090: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2091: NULL L_TAX_ACCOUNT_SOURCE_TAX , --Bug 4204464
2092: 'CREATE_EXEMPTIONS' L_TAX_EXMPT_CR_MTHD_CD , --Bug 4204464
2093: NULL L_TAX_EXMPT_SOURCE_TAX,
2491: NULL L_COLL_TAX_AUTHORITY_ID,
2492: NULL L_THRSHLD_CHK_TMPLT_CODE,
2493: NULL L_DEF_PRIMARY_REC_RATE_CODE,
2494: NULL L_DEF_SECONDARY_REC_RATE_CODE,
2495: fnd_global.user_id L_CREATED_BY,
2496: SYSDATE L_CREATION_DATE,
2497: fnd_global.user_id L_LAST_UPDATED_BY,
2498: SYSDATE L_LAST_UPDATE_DATE,
2499: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2493: NULL L_DEF_PRIMARY_REC_RATE_CODE,
2494: NULL L_DEF_SECONDARY_REC_RATE_CODE,
2495: fnd_global.user_id L_CREATED_BY,
2496: SYSDATE L_CREATION_DATE,
2497: fnd_global.user_id L_LAST_UPDATED_BY,
2498: SYSDATE L_LAST_UPDATE_DATE,
2499: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2500: fnd_global.conc_request_id L_REQUEST_ID,
2501: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2495: fnd_global.user_id L_CREATED_BY,
2496: SYSDATE L_CREATION_DATE,
2497: fnd_global.user_id L_LAST_UPDATED_BY,
2498: SYSDATE L_LAST_UPDATE_DATE,
2499: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2500: fnd_global.conc_request_id L_REQUEST_ID,
2501: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2502: fnd_global.conc_program_id L_PROGRAM_ID,
2503: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2496: SYSDATE L_CREATION_DATE,
2497: fnd_global.user_id L_LAST_UPDATED_BY,
2498: SYSDATE L_LAST_UPDATE_DATE,
2499: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2500: fnd_global.conc_request_id L_REQUEST_ID,
2501: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2502: fnd_global.conc_program_id L_PROGRAM_ID,
2503: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2504: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2497: fnd_global.user_id L_LAST_UPDATED_BY,
2498: SYSDATE L_LAST_UPDATE_DATE,
2499: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2500: fnd_global.conc_request_id L_REQUEST_ID,
2501: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2502: fnd_global.conc_program_id L_PROGRAM_ID,
2503: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2504: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2505: NULL L_TAX_ACCOUNT_SOURCE_TAX , --Bug 4204464
2498: SYSDATE L_LAST_UPDATE_DATE,
2499: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2500: fnd_global.conc_request_id L_REQUEST_ID,
2501: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2502: fnd_global.conc_program_id L_PROGRAM_ID,
2503: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2504: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2505: NULL L_TAX_ACCOUNT_SOURCE_TAX , --Bug 4204464
2506: 'CREATE_EXEMPTIONS' L_TAX_EXMPT_CR_MTHD_CD , --Bug 4204464
2499: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2500: fnd_global.conc_request_id L_REQUEST_ID,
2501: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2502: fnd_global.conc_program_id L_PROGRAM_ID,
2503: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2504: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2505: NULL L_TAX_ACCOUNT_SOURCE_TAX , --Bug 4204464
2506: 'CREATE_EXEMPTIONS' L_TAX_EXMPT_CR_MTHD_CD , --Bug 4204464
2507: NULL L_TAX_EXMPT_SOURCE_TAX,
2682: NULL l_attribute14,
2683: NULL l_attribute15,
2684: NULL l_attribute_category,
2685: SYSDATE l_creation_date,
2686: fnd_global.user_id l_created_by,
2687: SYSDATE l_last_update_date,
2688: fnd_global.user_id l_last_updated_by,
2689: fnd_global.conc_login_id l_last_update_login,
2690: fnd_global.conc_request_id l_request_id
2684: NULL l_attribute_category,
2685: SYSDATE l_creation_date,
2686: fnd_global.user_id l_created_by,
2687: SYSDATE l_last_update_date,
2688: fnd_global.user_id l_last_updated_by,
2689: fnd_global.conc_login_id l_last_update_login,
2690: fnd_global.conc_request_id l_request_id
2691: FROM zx_taxes_b tax
2692: WHERE tax.tax_regime_code like '%-SALES-TAX-%'
2685: SYSDATE l_creation_date,
2686: fnd_global.user_id l_created_by,
2687: SYSDATE l_last_update_date,
2688: fnd_global.user_id l_last_updated_by,
2689: fnd_global.conc_login_id l_last_update_login,
2690: fnd_global.conc_request_id l_request_id
2691: FROM zx_taxes_b tax
2692: WHERE tax.tax_regime_code like '%-SALES-TAX-%'
2693: AND NOT EXISTS (SELECT 1
2686: fnd_global.user_id l_created_by,
2687: SYSDATE l_last_update_date,
2688: fnd_global.user_id l_last_updated_by,
2689: fnd_global.conc_login_id l_last_update_login,
2690: fnd_global.conc_request_id l_request_id
2691: FROM zx_taxes_b tax
2692: WHERE tax.tax_regime_code like '%-SALES-TAX-%'
2693: AND NOT EXISTS (SELECT 1
2694: FROM zx_status_b status
2808: 'STANDARD_TB' , --taxable_basis_formula_code
2809: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
2810: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
2811: 'MIGRATED' , --record_type_code
2812: fnd_global.user_id , --created_by
2813: SYSDATE , --creation_date
2814: fnd_global.user_id , --last_updated_by
2815: SYSDATE , --last_update_date
2816: fnd_global.user_id , --last_update_login
2810: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
2811: 'MIGRATED' , --record_type_code
2812: fnd_global.user_id , --created_by
2813: SYSDATE , --creation_date
2814: fnd_global.user_id , --last_updated_by
2815: SYSDATE , --last_update_date
2816: fnd_global.user_id , --last_update_login
2817: fnd_global.conc_request_id , --request_id
2818: fnd_global.prog_appl_id , --program_application_id
2812: fnd_global.user_id , --created_by
2813: SYSDATE , --creation_date
2814: fnd_global.user_id , --last_updated_by
2815: SYSDATE , --last_update_date
2816: fnd_global.user_id , --last_update_login
2817: fnd_global.conc_request_id , --request_id
2818: fnd_global.prog_appl_id , --program_application_id
2819: fnd_global.conc_program_id , --program_id
2820: fnd_global.conc_login_id , --program_login_id
2813: SYSDATE , --creation_date
2814: fnd_global.user_id , --last_updated_by
2815: SYSDATE , --last_update_date
2816: fnd_global.user_id , --last_update_login
2817: fnd_global.conc_request_id , --request_id
2818: fnd_global.prog_appl_id , --program_application_id
2819: fnd_global.conc_program_id , --program_id
2820: fnd_global.conc_login_id , --program_login_id
2821: L_ATTRIBUTE1 ,
2814: fnd_global.user_id , --last_updated_by
2815: SYSDATE , --last_update_date
2816: fnd_global.user_id , --last_update_login
2817: fnd_global.conc_request_id , --request_id
2818: fnd_global.prog_appl_id , --program_application_id
2819: fnd_global.conc_program_id , --program_id
2820: fnd_global.conc_login_id , --program_login_id
2821: L_ATTRIBUTE1 ,
2822: L_ATTRIBUTE2 ,
2815: SYSDATE , --last_update_date
2816: fnd_global.user_id , --last_update_login
2817: fnd_global.conc_request_id , --request_id
2818: fnd_global.prog_appl_id , --program_application_id
2819: fnd_global.conc_program_id , --program_id
2820: fnd_global.conc_login_id , --program_login_id
2821: L_ATTRIBUTE1 ,
2822: L_ATTRIBUTE2 ,
2823: L_ATTRIBUTE3 ,
2816: fnd_global.user_id , --last_update_login
2817: fnd_global.conc_request_id , --request_id
2818: fnd_global.prog_appl_id , --program_application_id
2819: fnd_global.conc_program_id , --program_id
2820: fnd_global.conc_login_id , --program_login_id
2821: L_ATTRIBUTE1 ,
2822: L_ATTRIBUTE2 ,
2823: L_ATTRIBUTE3 ,
2824: L_ATTRIBUTE4 ,
2995: codes.FINCHRG_NON_REC_TAX_CCID L_FINCHRG_NON_REC_TAX_CCID,
2996: NULL L_NON_REC_ACCOUNT_CCID,
2997: 'RATES' L_ADJ_FOR_ADHOC_AMT_CODE,
2998: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
2999: fnd_global.user_id L_CREATED_BY,
3000: SYSDATE L_CREATION_DATE,
3001: fnd_global.user_id L_LAST_UPDATED_BY,
3002: SYSDATE L_LAST_UPDATE_DATE,
3003: fnd_global.user_id L_LAST_UPDATE_LOGIN,
2997: 'RATES' L_ADJ_FOR_ADHOC_AMT_CODE,
2998: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
2999: fnd_global.user_id L_CREATED_BY,
3000: SYSDATE L_CREATION_DATE,
3001: fnd_global.user_id L_LAST_UPDATED_BY,
3002: SYSDATE L_LAST_UPDATE_DATE,
3003: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3004: fnd_global.conc_request_id L_REQUEST_ID,
3005: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2999: fnd_global.user_id L_CREATED_BY,
3000: SYSDATE L_CREATION_DATE,
3001: fnd_global.user_id L_LAST_UPDATED_BY,
3002: SYSDATE L_LAST_UPDATE_DATE,
3003: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3004: fnd_global.conc_request_id L_REQUEST_ID,
3005: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3006: fnd_global.conc_program_id L_PROGRAM_ID,
3007: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3000: SYSDATE L_CREATION_DATE,
3001: fnd_global.user_id L_LAST_UPDATED_BY,
3002: SYSDATE L_LAST_UPDATE_DATE,
3003: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3004: fnd_global.conc_request_id L_REQUEST_ID,
3005: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3006: fnd_global.conc_program_id L_PROGRAM_ID,
3007: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3008: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3001: fnd_global.user_id L_LAST_UPDATED_BY,
3002: SYSDATE L_LAST_UPDATE_DATE,
3003: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3004: fnd_global.conc_request_id L_REQUEST_ID,
3005: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3006: fnd_global.conc_program_id L_PROGRAM_ID,
3007: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3008: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3009: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3002: SYSDATE L_LAST_UPDATE_DATE,
3003: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3004: fnd_global.conc_request_id L_REQUEST_ID,
3005: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3006: fnd_global.conc_program_id L_PROGRAM_ID,
3007: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3008: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3009: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3010: FROM
3003: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3004: fnd_global.conc_request_id L_REQUEST_ID,
3005: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3006: fnd_global.conc_program_id L_PROGRAM_ID,
3007: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3008: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3009: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3010: FROM
3011: zx_status_b status,
3143: 'STANDARD_TB' , --taxable_basis_formula_code
3144: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
3145: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
3146: 'MIGRATED' , --record_type_code
3147: fnd_global.user_id , --created_by
3148: SYSDATE , --creation_date
3149: fnd_global.user_id , --last_updated_by
3150: SYSDATE , --last_update_date
3151: fnd_global.user_id , --last_update_login
3145: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
3146: 'MIGRATED' , --record_type_code
3147: fnd_global.user_id , --created_by
3148: SYSDATE , --creation_date
3149: fnd_global.user_id , --last_updated_by
3150: SYSDATE , --last_update_date
3151: fnd_global.user_id , --last_update_login
3152: fnd_global.conc_request_id , --request_id
3153: fnd_global.prog_appl_id , --program_application_id
3147: fnd_global.user_id , --created_by
3148: SYSDATE , --creation_date
3149: fnd_global.user_id , --last_updated_by
3150: SYSDATE , --last_update_date
3151: fnd_global.user_id , --last_update_login
3152: fnd_global.conc_request_id , --request_id
3153: fnd_global.prog_appl_id , --program_application_id
3154: fnd_global.conc_program_id , --program_id
3155: fnd_global.conc_login_id , --program_login_id
3148: SYSDATE , --creation_date
3149: fnd_global.user_id , --last_updated_by
3150: SYSDATE , --last_update_date
3151: fnd_global.user_id , --last_update_login
3152: fnd_global.conc_request_id , --request_id
3153: fnd_global.prog_appl_id , --program_application_id
3154: fnd_global.conc_program_id , --program_id
3155: fnd_global.conc_login_id , --program_login_id
3156: L_ATTRIBUTE1 ,
3149: fnd_global.user_id , --last_updated_by
3150: SYSDATE , --last_update_date
3151: fnd_global.user_id , --last_update_login
3152: fnd_global.conc_request_id , --request_id
3153: fnd_global.prog_appl_id , --program_application_id
3154: fnd_global.conc_program_id , --program_id
3155: fnd_global.conc_login_id , --program_login_id
3156: L_ATTRIBUTE1 ,
3157: L_ATTRIBUTE2 ,
3150: SYSDATE , --last_update_date
3151: fnd_global.user_id , --last_update_login
3152: fnd_global.conc_request_id , --request_id
3153: fnd_global.prog_appl_id , --program_application_id
3154: fnd_global.conc_program_id , --program_id
3155: fnd_global.conc_login_id , --program_login_id
3156: L_ATTRIBUTE1 ,
3157: L_ATTRIBUTE2 ,
3158: L_ATTRIBUTE3 ,
3151: fnd_global.user_id , --last_update_login
3152: fnd_global.conc_request_id , --request_id
3153: fnd_global.prog_appl_id , --program_application_id
3154: fnd_global.conc_program_id , --program_id
3155: fnd_global.conc_login_id , --program_login_id
3156: L_ATTRIBUTE1 ,
3157: L_ATTRIBUTE2 ,
3158: L_ATTRIBUTE3 ,
3159: L_ATTRIBUTE4 ,
3330: codes.FINCHRG_NON_REC_TAX_CCID L_FINCHRG_NON_REC_TAX_CCID,
3331: NULL L_NON_REC_ACCOUNT_CCID,
3332: 'RATES' L_ADJ_FOR_ADHOC_AMT_CODE,
3333: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
3334: fnd_global.user_id L_CREATED_BY,
3335: SYSDATE L_CREATION_DATE,
3336: fnd_global.user_id L_LAST_UPDATED_BY,
3337: SYSDATE L_LAST_UPDATE_DATE,
3338: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3332: 'RATES' L_ADJ_FOR_ADHOC_AMT_CODE,
3333: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
3334: fnd_global.user_id L_CREATED_BY,
3335: SYSDATE L_CREATION_DATE,
3336: fnd_global.user_id L_LAST_UPDATED_BY,
3337: SYSDATE L_LAST_UPDATE_DATE,
3338: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3339: fnd_global.conc_request_id L_REQUEST_ID,
3340: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3334: fnd_global.user_id L_CREATED_BY,
3335: SYSDATE L_CREATION_DATE,
3336: fnd_global.user_id L_LAST_UPDATED_BY,
3337: SYSDATE L_LAST_UPDATE_DATE,
3338: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3339: fnd_global.conc_request_id L_REQUEST_ID,
3340: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3341: fnd_global.conc_program_id L_PROGRAM_ID,
3342: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3335: SYSDATE L_CREATION_DATE,
3336: fnd_global.user_id L_LAST_UPDATED_BY,
3337: SYSDATE L_LAST_UPDATE_DATE,
3338: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3339: fnd_global.conc_request_id L_REQUEST_ID,
3340: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3341: fnd_global.conc_program_id L_PROGRAM_ID,
3342: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3343: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3336: fnd_global.user_id L_LAST_UPDATED_BY,
3337: SYSDATE L_LAST_UPDATE_DATE,
3338: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3339: fnd_global.conc_request_id L_REQUEST_ID,
3340: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3341: fnd_global.conc_program_id L_PROGRAM_ID,
3342: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3343: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3344: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3337: SYSDATE L_LAST_UPDATE_DATE,
3338: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3339: fnd_global.conc_request_id L_REQUEST_ID,
3340: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3341: fnd_global.conc_program_id L_PROGRAM_ID,
3342: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3343: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3344: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3345: FROM
3338: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3339: fnd_global.conc_request_id L_REQUEST_ID,
3340: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3341: fnd_global.conc_program_id L_PROGRAM_ID,
3342: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3343: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3344: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3345: FROM
3346: zx_status_b status,
3941: NULL l_attribute14,
3942: NULL l_attribute15,
3943: NULL l_attribute_category,
3944: SYSDATE l_creation_date,
3945: fnd_global.user_id l_created_by,
3946: SYSDATE l_last_update_date,
3947: fnd_global.user_id l_last_updated_by,
3948: fnd_global.conc_login_id l_last_update_login,
3949: fnd_global.conc_request_id l_request_id
3943: NULL l_attribute_category,
3944: SYSDATE l_creation_date,
3945: fnd_global.user_id l_created_by,
3946: SYSDATE l_last_update_date,
3947: fnd_global.user_id l_last_updated_by,
3948: fnd_global.conc_login_id l_last_update_login,
3949: fnd_global.conc_request_id l_request_id
3950: FROM zx_taxes_b ztb,
3951: ar_system_parameters_all asp
3944: SYSDATE l_creation_date,
3945: fnd_global.user_id l_created_by,
3946: SYSDATE l_last_update_date,
3947: fnd_global.user_id l_last_updated_by,
3948: fnd_global.conc_login_id l_last_update_login,
3949: fnd_global.conc_request_id l_request_id
3950: FROM zx_taxes_b ztb,
3951: ar_system_parameters_all asp
3952: WHERE ztb.tax_regime_code LIKE 'US-SALES-TAX-%'
3945: fnd_global.user_id l_created_by,
3946: SYSDATE l_last_update_date,
3947: fnd_global.user_id l_last_updated_by,
3948: fnd_global.conc_login_id l_last_update_login,
3949: fnd_global.conc_request_id l_request_id
3950: FROM zx_taxes_b ztb,
3951: ar_system_parameters_all asp
3952: WHERE ztb.tax_regime_code LIKE 'US-SALES-TAX-%'
3953: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
4078: NULL l_attribute14,
4079: NULL l_attribute15,
4080: NULL l_attribute_category,
4081: SYSDATE l_creation_date,
4082: fnd_global.user_id l_created_by,
4083: SYSDATE l_last_update_date,
4084: fnd_global.user_id l_last_updated_by,
4085: fnd_global.conc_login_id l_last_update_login,
4086: fnd_global.conc_request_id l_request_id
4080: NULL l_attribute_category,
4081: SYSDATE l_creation_date,
4082: fnd_global.user_id l_created_by,
4083: SYSDATE l_last_update_date,
4084: fnd_global.user_id l_last_updated_by,
4085: fnd_global.conc_login_id l_last_update_login,
4086: fnd_global.conc_request_id l_request_id
4087: FROM zx_taxes_b ztb,
4088: ar_system_parameters_all asp
4081: SYSDATE l_creation_date,
4082: fnd_global.user_id l_created_by,
4083: SYSDATE l_last_update_date,
4084: fnd_global.user_id l_last_updated_by,
4085: fnd_global.conc_login_id l_last_update_login,
4086: fnd_global.conc_request_id l_request_id
4087: FROM zx_taxes_b ztb,
4088: ar_system_parameters_all asp
4089: WHERE ztb.tax_regime_code LIKE 'US-SALES-TAX-%'
4082: fnd_global.user_id l_created_by,
4083: SYSDATE l_last_update_date,
4084: fnd_global.user_id l_last_updated_by,
4085: fnd_global.conc_login_id l_last_update_login,
4086: fnd_global.conc_request_id l_request_id
4087: FROM zx_taxes_b ztb,
4088: ar_system_parameters_all asp
4089: WHERE ztb.tax_regime_code LIKE 'US-SALES-TAX-%'
4090: AND TO_CHAR(asp.location_structure_id) = LTRIM(tax_regime_code, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-_')
4218: 'STANDARD_TB' , --taxable_basis_formula_code
4219: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
4220: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
4221: 'MIGRATED' , --record_type_code
4222: fnd_global.user_id , --created_by
4223: SYSDATE , --creation_date
4224: fnd_global.user_id , --last_updated_by
4225: SYSDATE , --last_update_date
4226: fnd_global.user_id , --last_update_login
4220: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
4221: 'MIGRATED' , --record_type_code
4222: fnd_global.user_id , --created_by
4223: SYSDATE , --creation_date
4224: fnd_global.user_id , --last_updated_by
4225: SYSDATE , --last_update_date
4226: fnd_global.user_id , --last_update_login
4227: fnd_global.conc_request_id , --request_id
4228: fnd_global.prog_appl_id , --program_application_id
4222: fnd_global.user_id , --created_by
4223: SYSDATE , --creation_date
4224: fnd_global.user_id , --last_updated_by
4225: SYSDATE , --last_update_date
4226: fnd_global.user_id , --last_update_login
4227: fnd_global.conc_request_id , --request_id
4228: fnd_global.prog_appl_id , --program_application_id
4229: fnd_global.conc_program_id , --program_id
4230: fnd_global.conc_login_id , --program_login_id
4223: SYSDATE , --creation_date
4224: fnd_global.user_id , --last_updated_by
4225: SYSDATE , --last_update_date
4226: fnd_global.user_id , --last_update_login
4227: fnd_global.conc_request_id , --request_id
4228: fnd_global.prog_appl_id , --program_application_id
4229: fnd_global.conc_program_id , --program_id
4230: fnd_global.conc_login_id , --program_login_id
4231: L_ATTRIBUTE1 ,
4224: fnd_global.user_id , --last_updated_by
4225: SYSDATE , --last_update_date
4226: fnd_global.user_id , --last_update_login
4227: fnd_global.conc_request_id , --request_id
4228: fnd_global.prog_appl_id , --program_application_id
4229: fnd_global.conc_program_id , --program_id
4230: fnd_global.conc_login_id , --program_login_id
4231: L_ATTRIBUTE1 ,
4232: L_ATTRIBUTE2 ,
4225: SYSDATE , --last_update_date
4226: fnd_global.user_id , --last_update_login
4227: fnd_global.conc_request_id , --request_id
4228: fnd_global.prog_appl_id , --program_application_id
4229: fnd_global.conc_program_id , --program_id
4230: fnd_global.conc_login_id , --program_login_id
4231: L_ATTRIBUTE1 ,
4232: L_ATTRIBUTE2 ,
4233: L_ATTRIBUTE3 ,
4226: fnd_global.user_id , --last_update_login
4227: fnd_global.conc_request_id , --request_id
4228: fnd_global.prog_appl_id , --program_application_id
4229: fnd_global.conc_program_id , --program_id
4230: fnd_global.conc_login_id , --program_login_id
4231: L_ATTRIBUTE1 ,
4232: L_ATTRIBUTE2 ,
4233: L_ATTRIBUTE3 ,
4234: L_ATTRIBUTE4 ,
4405: avt.FINCHRG_NON_REC_TAX_CCID L_FINCHRG_NON_REC_TAX_CCID,
4406: NULL L_NON_REC_ACCOUNT_CCID,
4407: 'TAX_RATE' L_ADJ_FOR_ADHOC_AMT_CODE,
4408: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
4409: fnd_global.user_id L_CREATED_BY,
4410: SYSDATE L_CREATION_DATE,
4411: fnd_global.user_id L_LAST_UPDATED_BY,
4412: SYSDATE L_LAST_UPDATE_DATE,
4413: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4407: 'TAX_RATE' L_ADJ_FOR_ADHOC_AMT_CODE,
4408: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
4409: fnd_global.user_id L_CREATED_BY,
4410: SYSDATE L_CREATION_DATE,
4411: fnd_global.user_id L_LAST_UPDATED_BY,
4412: SYSDATE L_LAST_UPDATE_DATE,
4413: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4414: fnd_global.conc_request_id L_REQUEST_ID,
4415: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4409: fnd_global.user_id L_CREATED_BY,
4410: SYSDATE L_CREATION_DATE,
4411: fnd_global.user_id L_LAST_UPDATED_BY,
4412: SYSDATE L_LAST_UPDATE_DATE,
4413: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4414: fnd_global.conc_request_id L_REQUEST_ID,
4415: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4416: fnd_global.conc_program_id L_PROGRAM_ID,
4417: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4410: SYSDATE L_CREATION_DATE,
4411: fnd_global.user_id L_LAST_UPDATED_BY,
4412: SYSDATE L_LAST_UPDATE_DATE,
4413: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4414: fnd_global.conc_request_id L_REQUEST_ID,
4415: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4416: fnd_global.conc_program_id L_PROGRAM_ID,
4417: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4418: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4411: fnd_global.user_id L_LAST_UPDATED_BY,
4412: SYSDATE L_LAST_UPDATE_DATE,
4413: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4414: fnd_global.conc_request_id L_REQUEST_ID,
4415: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4416: fnd_global.conc_program_id L_PROGRAM_ID,
4417: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4418: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4419: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4412: SYSDATE L_LAST_UPDATE_DATE,
4413: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4414: fnd_global.conc_request_id L_REQUEST_ID,
4415: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4416: fnd_global.conc_program_id L_PROGRAM_ID,
4417: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4418: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4419: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4420: FROM
4413: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4414: fnd_global.conc_request_id L_REQUEST_ID,
4415: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4416: fnd_global.conc_program_id L_PROGRAM_ID,
4417: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4418: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4419: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4420: FROM
4421: ar_vat_tax_all_b avt,
4550: 'STANDARD_TB' , --taxable_basis_formula_code
4551: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
4552: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
4553: 'MIGRATED' , --record_type_code
4554: fnd_global.user_id , --created_by
4555: SYSDATE , --creation_date
4556: fnd_global.user_id , --last_updated_by
4557: SYSDATE , --last_update_date
4558: fnd_global.user_id , --last_update_login
4552: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
4553: 'MIGRATED' , --record_type_code
4554: fnd_global.user_id , --created_by
4555: SYSDATE , --creation_date
4556: fnd_global.user_id , --last_updated_by
4557: SYSDATE , --last_update_date
4558: fnd_global.user_id , --last_update_login
4559: fnd_global.conc_request_id , --request_id
4560: fnd_global.prog_appl_id , --program_application_id
4554: fnd_global.user_id , --created_by
4555: SYSDATE , --creation_date
4556: fnd_global.user_id , --last_updated_by
4557: SYSDATE , --last_update_date
4558: fnd_global.user_id , --last_update_login
4559: fnd_global.conc_request_id , --request_id
4560: fnd_global.prog_appl_id , --program_application_id
4561: fnd_global.conc_program_id , --program_id
4562: fnd_global.conc_login_id , --program_login_id
4555: SYSDATE , --creation_date
4556: fnd_global.user_id , --last_updated_by
4557: SYSDATE , --last_update_date
4558: fnd_global.user_id , --last_update_login
4559: fnd_global.conc_request_id , --request_id
4560: fnd_global.prog_appl_id , --program_application_id
4561: fnd_global.conc_program_id , --program_id
4562: fnd_global.conc_login_id , --program_login_id
4563: L_ATTRIBUTE1 ,
4556: fnd_global.user_id , --last_updated_by
4557: SYSDATE , --last_update_date
4558: fnd_global.user_id , --last_update_login
4559: fnd_global.conc_request_id , --request_id
4560: fnd_global.prog_appl_id , --program_application_id
4561: fnd_global.conc_program_id , --program_id
4562: fnd_global.conc_login_id , --program_login_id
4563: L_ATTRIBUTE1 ,
4564: L_ATTRIBUTE2 ,
4557: SYSDATE , --last_update_date
4558: fnd_global.user_id , --last_update_login
4559: fnd_global.conc_request_id , --request_id
4560: fnd_global.prog_appl_id , --program_application_id
4561: fnd_global.conc_program_id , --program_id
4562: fnd_global.conc_login_id , --program_login_id
4563: L_ATTRIBUTE1 ,
4564: L_ATTRIBUTE2 ,
4565: L_ATTRIBUTE3 ,
4558: fnd_global.user_id , --last_update_login
4559: fnd_global.conc_request_id , --request_id
4560: fnd_global.prog_appl_id , --program_application_id
4561: fnd_global.conc_program_id , --program_id
4562: fnd_global.conc_login_id , --program_login_id
4563: L_ATTRIBUTE1 ,
4564: L_ATTRIBUTE2 ,
4565: L_ATTRIBUTE3 ,
4566: L_ATTRIBUTE4 ,
4737: avt.FINCHRG_NON_REC_TAX_CCID L_FINCHRG_NON_REC_TAX_CCID,
4738: NULL L_NON_REC_ACCOUNT_CCID,
4739: 'TAX_RATE' L_ADJ_FOR_ADHOC_AMT_CODE,
4740: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
4741: fnd_global.user_id L_CREATED_BY,
4742: SYSDATE L_CREATION_DATE,
4743: fnd_global.user_id L_LAST_UPDATED_BY,
4744: SYSDATE L_LAST_UPDATE_DATE,
4745: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4739: 'TAX_RATE' L_ADJ_FOR_ADHOC_AMT_CODE,
4740: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
4741: fnd_global.user_id L_CREATED_BY,
4742: SYSDATE L_CREATION_DATE,
4743: fnd_global.user_id L_LAST_UPDATED_BY,
4744: SYSDATE L_LAST_UPDATE_DATE,
4745: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4746: fnd_global.conc_request_id L_REQUEST_ID,
4747: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4741: fnd_global.user_id L_CREATED_BY,
4742: SYSDATE L_CREATION_DATE,
4743: fnd_global.user_id L_LAST_UPDATED_BY,
4744: SYSDATE L_LAST_UPDATE_DATE,
4745: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4746: fnd_global.conc_request_id L_REQUEST_ID,
4747: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4748: fnd_global.conc_program_id L_PROGRAM_ID,
4749: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4742: SYSDATE L_CREATION_DATE,
4743: fnd_global.user_id L_LAST_UPDATED_BY,
4744: SYSDATE L_LAST_UPDATE_DATE,
4745: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4746: fnd_global.conc_request_id L_REQUEST_ID,
4747: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4748: fnd_global.conc_program_id L_PROGRAM_ID,
4749: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4750: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4743: fnd_global.user_id L_LAST_UPDATED_BY,
4744: SYSDATE L_LAST_UPDATE_DATE,
4745: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4746: fnd_global.conc_request_id L_REQUEST_ID,
4747: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4748: fnd_global.conc_program_id L_PROGRAM_ID,
4749: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4750: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4751: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4744: SYSDATE L_LAST_UPDATE_DATE,
4745: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4746: fnd_global.conc_request_id L_REQUEST_ID,
4747: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4748: fnd_global.conc_program_id L_PROGRAM_ID,
4749: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4750: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4751: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4752: FROM
4745: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4746: fnd_global.conc_request_id L_REQUEST_ID,
4747: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4748: fnd_global.conc_program_id L_PROGRAM_ID,
4749: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4750: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4751: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4752: FROM
4753: ar_vat_tax_all_b avt,
5031: L_TAXABLE_BASIS_FORMULA , --taxable_basis_formula_code
5032: INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
5033: TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
5034: 'MIGRATED' , --record_type_code
5035: fnd_global.user_id , --created_by
5036: SYSDATE , --creation_date
5037: fnd_global.user_id , --last_updated_by
5038: SYSDATE , --last_update_date
5039: fnd_global.user_id , --last_update_login
5033: TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
5034: 'MIGRATED' , --record_type_code
5035: fnd_global.user_id , --created_by
5036: SYSDATE , --creation_date
5037: fnd_global.user_id , --last_updated_by
5038: SYSDATE , --last_update_date
5039: fnd_global.user_id , --last_update_login
5040: fnd_global.conc_request_id , --request_id
5041: fnd_global.prog_appl_id , --program_application_id
5035: fnd_global.user_id , --created_by
5036: SYSDATE , --creation_date
5037: fnd_global.user_id , --last_updated_by
5038: SYSDATE , --last_update_date
5039: fnd_global.user_id , --last_update_login
5040: fnd_global.conc_request_id , --request_id
5041: fnd_global.prog_appl_id , --program_application_id
5042: fnd_global.conc_program_id , --program_id
5043: fnd_global.conc_login_id , --program_login_id
5036: SYSDATE , --creation_date
5037: fnd_global.user_id , --last_updated_by
5038: SYSDATE , --last_update_date
5039: fnd_global.user_id , --last_update_login
5040: fnd_global.conc_request_id , --request_id
5041: fnd_global.prog_appl_id , --program_application_id
5042: fnd_global.conc_program_id , --program_id
5043: fnd_global.conc_login_id , --program_login_id
5044: ATTRIBUTE1 ,
5037: fnd_global.user_id , --last_updated_by
5038: SYSDATE , --last_update_date
5039: fnd_global.user_id , --last_update_login
5040: fnd_global.conc_request_id , --request_id
5041: fnd_global.prog_appl_id , --program_application_id
5042: fnd_global.conc_program_id , --program_id
5043: fnd_global.conc_login_id , --program_login_id
5044: ATTRIBUTE1 ,
5045: ATTRIBUTE2 ,
5038: SYSDATE , --last_update_date
5039: fnd_global.user_id , --last_update_login
5040: fnd_global.conc_request_id , --request_id
5041: fnd_global.prog_appl_id , --program_application_id
5042: fnd_global.conc_program_id , --program_id
5043: fnd_global.conc_login_id , --program_login_id
5044: ATTRIBUTE1 ,
5045: ATTRIBUTE2 ,
5046: ATTRIBUTE3 ,
5039: fnd_global.user_id , --last_update_login
5040: fnd_global.conc_request_id , --request_id
5041: fnd_global.prog_appl_id , --program_application_id
5042: fnd_global.conc_program_id , --program_id
5043: fnd_global.conc_login_id , --program_login_id
5044: ATTRIBUTE1 ,
5045: ATTRIBUTE2 ,
5046: ATTRIBUTE3 ,
5047: ATTRIBUTE4 ,
5143: NULL ,
5144: NULL ,
5145: NULL ,
5146: NULL ,
5147: fnd_global.user_id ,
5148: SYSDATE ,
5149: fnd_global.user_id ,
5150: SYSDATE ,
5151: fnd_global.conc_login_id ,
5145: NULL ,
5146: NULL ,
5147: fnd_global.user_id ,
5148: SYSDATE ,
5149: fnd_global.user_id ,
5150: SYSDATE ,
5151: fnd_global.conc_login_id ,
5152: fnd_global.conc_request_id , -- Request Id
5153: fnd_global.prog_appl_id , -- Program Application ID
5147: fnd_global.user_id ,
5148: SYSDATE ,
5149: fnd_global.user_id ,
5150: SYSDATE ,
5151: fnd_global.conc_login_id ,
5152: fnd_global.conc_request_id , -- Request Id
5153: fnd_global.prog_appl_id , -- Program Application ID
5154: fnd_global.conc_program_id , -- Program Id
5155: fnd_global.conc_login_id , -- Program Login ID
5148: SYSDATE ,
5149: fnd_global.user_id ,
5150: SYSDATE ,
5151: fnd_global.conc_login_id ,
5152: fnd_global.conc_request_id , -- Request Id
5153: fnd_global.prog_appl_id , -- Program Application ID
5154: fnd_global.conc_program_id , -- Program Id
5155: fnd_global.conc_login_id , -- Program Login ID
5156: 1
5149: fnd_global.user_id ,
5150: SYSDATE ,
5151: fnd_global.conc_login_id ,
5152: fnd_global.conc_request_id , -- Request Id
5153: fnd_global.prog_appl_id , -- Program Application ID
5154: fnd_global.conc_program_id , -- Program Id
5155: fnd_global.conc_login_id , -- Program Login ID
5156: 1
5157: )
5150: SYSDATE ,
5151: fnd_global.conc_login_id ,
5152: fnd_global.conc_request_id , -- Request Id
5153: fnd_global.prog_appl_id , -- Program Application ID
5154: fnd_global.conc_program_id , -- Program Id
5155: fnd_global.conc_login_id , -- Program Login ID
5156: 1
5157: )
5158: SELECT
5151: fnd_global.conc_login_id ,
5152: fnd_global.conc_request_id , -- Request Id
5153: fnd_global.prog_appl_id , -- Program Application ID
5154: fnd_global.conc_program_id , -- Program Id
5155: fnd_global.conc_login_id , -- Program Login ID
5156: 1
5157: )
5158: SELECT
5159: results.tax_code_id TAX_RATE_ID,
5378: L_TAXABLE_BASIS_FORMULA , --taxable_basis_formula_code
5379: INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
5380: TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
5381: 'MIGRATED' , --record_type_code
5382: fnd_global.user_id , --created_by
5383: SYSDATE , --creation_date
5384: fnd_global.user_id , --last_updated_by
5385: SYSDATE , --last_update_date
5386: fnd_global.user_id , --last_update_login
5380: TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
5381: 'MIGRATED' , --record_type_code
5382: fnd_global.user_id , --created_by
5383: SYSDATE , --creation_date
5384: fnd_global.user_id , --last_updated_by
5385: SYSDATE , --last_update_date
5386: fnd_global.user_id , --last_update_login
5387: fnd_global.conc_request_id , --request_id
5388: fnd_global.prog_appl_id , --program_application_id
5382: fnd_global.user_id , --created_by
5383: SYSDATE , --creation_date
5384: fnd_global.user_id , --last_updated_by
5385: SYSDATE , --last_update_date
5386: fnd_global.user_id , --last_update_login
5387: fnd_global.conc_request_id , --request_id
5388: fnd_global.prog_appl_id , --program_application_id
5389: fnd_global.conc_program_id , --program_id
5390: fnd_global.conc_login_id , --program_login_id
5383: SYSDATE , --creation_date
5384: fnd_global.user_id , --last_updated_by
5385: SYSDATE , --last_update_date
5386: fnd_global.user_id , --last_update_login
5387: fnd_global.conc_request_id , --request_id
5388: fnd_global.prog_appl_id , --program_application_id
5389: fnd_global.conc_program_id , --program_id
5390: fnd_global.conc_login_id , --program_login_id
5391: ATTRIBUTE1 ,
5384: fnd_global.user_id , --last_updated_by
5385: SYSDATE , --last_update_date
5386: fnd_global.user_id , --last_update_login
5387: fnd_global.conc_request_id , --request_id
5388: fnd_global.prog_appl_id , --program_application_id
5389: fnd_global.conc_program_id , --program_id
5390: fnd_global.conc_login_id , --program_login_id
5391: ATTRIBUTE1 ,
5392: ATTRIBUTE2 ,
5385: SYSDATE , --last_update_date
5386: fnd_global.user_id , --last_update_login
5387: fnd_global.conc_request_id , --request_id
5388: fnd_global.prog_appl_id , --program_application_id
5389: fnd_global.conc_program_id , --program_id
5390: fnd_global.conc_login_id , --program_login_id
5391: ATTRIBUTE1 ,
5392: ATTRIBUTE2 ,
5393: ATTRIBUTE3 ,
5386: fnd_global.user_id , --last_update_login
5387: fnd_global.conc_request_id , --request_id
5388: fnd_global.prog_appl_id , --program_application_id
5389: fnd_global.conc_program_id , --program_id
5390: fnd_global.conc_login_id , --program_login_id
5391: ATTRIBUTE1 ,
5392: ATTRIBUTE2 ,
5393: ATTRIBUTE3 ,
5394: ATTRIBUTE4 ,
5490: NULL ,
5491: NULL ,
5492: NULL ,
5493: NULL ,
5494: fnd_global.user_id ,
5495: SYSDATE ,
5496: fnd_global.user_id ,
5497: SYSDATE ,
5498: fnd_global.conc_login_id ,
5492: NULL ,
5493: NULL ,
5494: fnd_global.user_id ,
5495: SYSDATE ,
5496: fnd_global.user_id ,
5497: SYSDATE ,
5498: fnd_global.conc_login_id ,
5499: fnd_global.conc_request_id , -- Request Id
5500: fnd_global.prog_appl_id , -- Program Application ID
5494: fnd_global.user_id ,
5495: SYSDATE ,
5496: fnd_global.user_id ,
5497: SYSDATE ,
5498: fnd_global.conc_login_id ,
5499: fnd_global.conc_request_id , -- Request Id
5500: fnd_global.prog_appl_id , -- Program Application ID
5501: fnd_global.conc_program_id , -- Program Id
5502: fnd_global.conc_login_id , -- Program Login ID
5495: SYSDATE ,
5496: fnd_global.user_id ,
5497: SYSDATE ,
5498: fnd_global.conc_login_id ,
5499: fnd_global.conc_request_id , -- Request Id
5500: fnd_global.prog_appl_id , -- Program Application ID
5501: fnd_global.conc_program_id , -- Program Id
5502: fnd_global.conc_login_id , -- Program Login ID
5503: 1
5496: fnd_global.user_id ,
5497: SYSDATE ,
5498: fnd_global.conc_login_id ,
5499: fnd_global.conc_request_id , -- Request Id
5500: fnd_global.prog_appl_id , -- Program Application ID
5501: fnd_global.conc_program_id , -- Program Id
5502: fnd_global.conc_login_id , -- Program Login ID
5503: 1
5504: )
5497: SYSDATE ,
5498: fnd_global.conc_login_id ,
5499: fnd_global.conc_request_id , -- Request Id
5500: fnd_global.prog_appl_id , -- Program Application ID
5501: fnd_global.conc_program_id , -- Program Id
5502: fnd_global.conc_login_id , -- Program Login ID
5503: 1
5504: )
5505: SELECT
5498: fnd_global.conc_login_id ,
5499: fnd_global.conc_request_id , -- Request Id
5500: fnd_global.prog_appl_id , -- Program Application ID
5501: fnd_global.conc_program_id , -- Program Id
5502: fnd_global.conc_login_id , -- Program Login ID
5503: 1
5504: )
5505: SELECT
5506: results.tax_code_id TAX_RATE_ID,
5731: L_TAXABLE_BASIS_FORMULA , --taxable_basis_formula_code
5732: INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
5733: TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
5734: 'MIGRATED' , --record_type_code
5735: fnd_global.user_id , --created_by
5736: SYSDATE , --creation_date
5737: fnd_global.user_id , --last_updated_by
5738: SYSDATE , --last_update_date
5739: fnd_global.user_id , --last_update_login
5733: TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
5734: 'MIGRATED' , --record_type_code
5735: fnd_global.user_id , --created_by
5736: SYSDATE , --creation_date
5737: fnd_global.user_id , --last_updated_by
5738: SYSDATE , --last_update_date
5739: fnd_global.user_id , --last_update_login
5740: fnd_global.conc_request_id , --request_id
5741: fnd_global.prog_appl_id , --program_application_id
5735: fnd_global.user_id , --created_by
5736: SYSDATE , --creation_date
5737: fnd_global.user_id , --last_updated_by
5738: SYSDATE , --last_update_date
5739: fnd_global.user_id , --last_update_login
5740: fnd_global.conc_request_id , --request_id
5741: fnd_global.prog_appl_id , --program_application_id
5742: fnd_global.conc_program_id , --program_id
5743: fnd_global.conc_login_id , --program_login_id
5736: SYSDATE , --creation_date
5737: fnd_global.user_id , --last_updated_by
5738: SYSDATE , --last_update_date
5739: fnd_global.user_id , --last_update_login
5740: fnd_global.conc_request_id , --request_id
5741: fnd_global.prog_appl_id , --program_application_id
5742: fnd_global.conc_program_id , --program_id
5743: fnd_global.conc_login_id , --program_login_id
5744: ATTRIBUTE1 ,
5737: fnd_global.user_id , --last_updated_by
5738: SYSDATE , --last_update_date
5739: fnd_global.user_id , --last_update_login
5740: fnd_global.conc_request_id , --request_id
5741: fnd_global.prog_appl_id , --program_application_id
5742: fnd_global.conc_program_id , --program_id
5743: fnd_global.conc_login_id , --program_login_id
5744: ATTRIBUTE1 ,
5745: ATTRIBUTE2 ,
5738: SYSDATE , --last_update_date
5739: fnd_global.user_id , --last_update_login
5740: fnd_global.conc_request_id , --request_id
5741: fnd_global.prog_appl_id , --program_application_id
5742: fnd_global.conc_program_id , --program_id
5743: fnd_global.conc_login_id , --program_login_id
5744: ATTRIBUTE1 ,
5745: ATTRIBUTE2 ,
5746: ATTRIBUTE3 ,
5739: fnd_global.user_id , --last_update_login
5740: fnd_global.conc_request_id , --request_id
5741: fnd_global.prog_appl_id , --program_application_id
5742: fnd_global.conc_program_id , --program_id
5743: fnd_global.conc_login_id , --program_login_id
5744: ATTRIBUTE1 ,
5745: ATTRIBUTE2 ,
5746: ATTRIBUTE3 ,
5747: ATTRIBUTE4 ,
5842: NULL ,
5843: NULL ,
5844: NULL ,
5845: NULL ,
5846: fnd_global.user_id ,
5847: SYSDATE ,
5848: fnd_global.user_id ,
5849: SYSDATE ,
5850: fnd_global.conc_login_id ,
5844: NULL ,
5845: NULL ,
5846: fnd_global.user_id ,
5847: SYSDATE ,
5848: fnd_global.user_id ,
5849: SYSDATE ,
5850: fnd_global.conc_login_id ,
5851: fnd_global.conc_request_id , -- Request Id
5852: fnd_global.prog_appl_id , -- Program Application ID
5846: fnd_global.user_id ,
5847: SYSDATE ,
5848: fnd_global.user_id ,
5849: SYSDATE ,
5850: fnd_global.conc_login_id ,
5851: fnd_global.conc_request_id , -- Request Id
5852: fnd_global.prog_appl_id , -- Program Application ID
5853: fnd_global.conc_program_id , -- Program Id
5854: fnd_global.conc_login_id , -- Program Login ID
5847: SYSDATE ,
5848: fnd_global.user_id ,
5849: SYSDATE ,
5850: fnd_global.conc_login_id ,
5851: fnd_global.conc_request_id , -- Request Id
5852: fnd_global.prog_appl_id , -- Program Application ID
5853: fnd_global.conc_program_id , -- Program Id
5854: fnd_global.conc_login_id , -- Program Login ID
5855: 1
5848: fnd_global.user_id ,
5849: SYSDATE ,
5850: fnd_global.conc_login_id ,
5851: fnd_global.conc_request_id , -- Request Id
5852: fnd_global.prog_appl_id , -- Program Application ID
5853: fnd_global.conc_program_id , -- Program Id
5854: fnd_global.conc_login_id , -- Program Login ID
5855: 1
5856: )
5849: SYSDATE ,
5850: fnd_global.conc_login_id ,
5851: fnd_global.conc_request_id , -- Request Id
5852: fnd_global.prog_appl_id , -- Program Application ID
5853: fnd_global.conc_program_id , -- Program Id
5854: fnd_global.conc_login_id , -- Program Login ID
5855: 1
5856: )
5857: SELECT
5850: fnd_global.conc_login_id ,
5851: fnd_global.conc_request_id , -- Request Id
5852: fnd_global.prog_appl_id , -- Program Application ID
5853: fnd_global.conc_program_id , -- Program Id
5854: fnd_global.conc_login_id , -- Program Login ID
5855: 1
5856: )
5857: SELECT
5858: distinct
5983: SOURCE_LANG
5984: )
5985: SELECT avtt.vat_tax_id,
5986: avtt.printed_tax_name,
5987: fnd_global.user_id ,
5988: SYSDATE ,
5989: fnd_global.user_id ,
5990: SYSDATE ,
5991: fnd_global.conc_login_id ,
5985: SELECT avtt.vat_tax_id,
5986: avtt.printed_tax_name,
5987: fnd_global.user_id ,
5988: SYSDATE ,
5989: fnd_global.user_id ,
5990: SYSDATE ,
5991: fnd_global.conc_login_id ,
5992: avtt.language ,
5993: avtt.source_lang
5987: fnd_global.user_id ,
5988: SYSDATE ,
5989: fnd_global.user_id ,
5990: SYSDATE ,
5991: fnd_global.conc_login_id ,
5992: avtt.language ,
5993: avtt.source_lang
5994:
5995: FROM ar_vat_tax_all_tl avtt,
6484: NULL , -- COLL_TAX_AUTHORITY_ID
6485: NULL , -- THRSHLD_CHK_TMPLT_CODE
6486: NULL , -- DEF_PRIMARY_REC_RATE_CODE
6487: NULL , -- DEF_SECONDARY_REC_RATE_CODE
6488: fnd_global.user_id , -- CREATED_BY
6489: SYSDATE , -- CREATION_DATE
6490: fnd_global.user_id , -- LAST_UPDATED_BY
6491: SYSDATE , -- LAST_UPDATE_DATE
6492: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
6486: NULL , -- DEF_PRIMARY_REC_RATE_CODE
6487: NULL , -- DEF_SECONDARY_REC_RATE_CODE
6488: fnd_global.user_id , -- CREATED_BY
6489: SYSDATE , -- CREATION_DATE
6490: fnd_global.user_id , -- LAST_UPDATED_BY
6491: SYSDATE , -- LAST_UPDATE_DATE
6492: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
6493: fnd_global.conc_request_id , -- REQUEST_ID
6494: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
6488: fnd_global.user_id , -- CREATED_BY
6489: SYSDATE , -- CREATION_DATE
6490: fnd_global.user_id , -- LAST_UPDATED_BY
6491: SYSDATE , -- LAST_UPDATE_DATE
6492: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
6493: fnd_global.conc_request_id , -- REQUEST_ID
6494: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
6495: fnd_global.conc_program_id , -- PROGRAM_ID
6496: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
6489: SYSDATE , -- CREATION_DATE
6490: fnd_global.user_id , -- LAST_UPDATED_BY
6491: SYSDATE , -- LAST_UPDATE_DATE
6492: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
6493: fnd_global.conc_request_id , -- REQUEST_ID
6494: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
6495: fnd_global.conc_program_id , -- PROGRAM_ID
6496: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
6497: CASE WHEN p_country_code = 'US' AND p_seg_att_type IN ('STATE', 'COUNTY')
6490: fnd_global.user_id , -- LAST_UPDATED_BY
6491: SYSDATE , -- LAST_UPDATE_DATE
6492: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
6493: fnd_global.conc_request_id , -- REQUEST_ID
6494: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
6495: fnd_global.conc_program_id , -- PROGRAM_ID
6496: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
6497: CASE WHEN p_country_code = 'US' AND p_seg_att_type IN ('STATE', 'COUNTY')
6498: THEN
6491: SYSDATE , -- LAST_UPDATE_DATE
6492: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
6493: fnd_global.conc_request_id , -- REQUEST_ID
6494: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
6495: fnd_global.conc_program_id , -- PROGRAM_ID
6496: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
6497: CASE WHEN p_country_code = 'US' AND p_seg_att_type IN ('STATE', 'COUNTY')
6498: THEN
6499: substrb('US' || '_'|| 'OVERRIDE_ZONE_TYPE_' ||
6492: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
6493: fnd_global.conc_request_id , -- REQUEST_ID
6494: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
6495: fnd_global.conc_program_id , -- PROGRAM_ID
6496: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
6497: CASE WHEN p_country_code = 'US' AND p_seg_att_type IN ('STATE', 'COUNTY')
6498: THEN
6499: substrb('US' || '_'|| 'OVERRIDE_ZONE_TYPE_' ||
6500: substrb(to_char(p_loc_str_id), 1, 6),1,30)
6534: userenv('LANG'),
6535: userenv('LANG'),
6536: p_seg_att_type,
6537: SYSDATE,
6538: fnd_global.user_id,
6539: SYSDATE,
6540: fnd_global.user_id,
6541: fnd_global.conc_login_id,
6542: ZX_TAXES_B_S.NEXTVAL
6536: p_seg_att_type,
6537: SYSDATE,
6538: fnd_global.user_id,
6539: SYSDATE,
6540: fnd_global.user_id,
6541: fnd_global.conc_login_id,
6542: ZX_TAXES_B_S.NEXTVAL
6543: )*/
6544: SELECT 1 FROM DUAL;
6537: SYSDATE,
6538: fnd_global.user_id,
6539: SYSDATE,
6540: fnd_global.user_id,
6541: fnd_global.conc_login_id,
6542: ZX_TAXES_B_S.NEXTVAL
6543: )*/
6544: SELECT 1 FROM DUAL;
6545:
6660: NULL,
6661: NULL,
6662: NULL,
6663: SYSDATE,
6664: fnd_global.user_id,
6665: SYSDATE,
6666: fnd_global.user_id,
6667: fnd_global.conc_login_id,
6668: fnd_global.conc_request_id ,-- Request Id
6662: NULL,
6663: SYSDATE,
6664: fnd_global.user_id,
6665: SYSDATE,
6666: fnd_global.user_id,
6667: fnd_global.conc_login_id,
6668: fnd_global.conc_request_id ,-- Request Id
6669: 1
6670: FROM
6663: SYSDATE,
6664: fnd_global.user_id,
6665: SYSDATE,
6666: fnd_global.user_id,
6667: fnd_global.conc_login_id,
6668: fnd_global.conc_request_id ,-- Request Id
6669: 1
6670: FROM
6671: (SELECT RATES.TAX_REGIME_CODE tax_regime_code,
6664: fnd_global.user_id,
6665: SYSDATE,
6666: fnd_global.user_id,
6667: fnd_global.conc_login_id,
6668: fnd_global.conc_request_id ,-- Request Id
6669: 1
6670: FROM
6671: (SELECT RATES.TAX_REGIME_CODE tax_regime_code,
6672: RATES.CONTENT_OWNER_ID content_owner_id,
6786: NULL,
6787: NULL,
6788: NULL,
6789: SYSDATE,
6790: fnd_global.user_id,
6791: SYSDATE,
6792: fnd_global.user_id,
6793: fnd_global.conc_login_id,
6794: fnd_global.conc_request_id ,-- Request Id
6788: NULL,
6789: SYSDATE,
6790: fnd_global.user_id,
6791: SYSDATE,
6792: fnd_global.user_id,
6793: fnd_global.conc_login_id,
6794: fnd_global.conc_request_id ,-- Request Id
6795: 1
6796: FROM
6789: SYSDATE,
6790: fnd_global.user_id,
6791: SYSDATE,
6792: fnd_global.user_id,
6793: fnd_global.conc_login_id,
6794: fnd_global.conc_request_id ,-- Request Id
6795: 1
6796: FROM
6797: (SELECT RATES.TAX_REGIME_CODE tax_regime_code,
6790: fnd_global.user_id,
6791: SYSDATE,
6792: fnd_global.user_id,
6793: fnd_global.conc_login_id,
6794: fnd_global.conc_request_id ,-- Request Id
6795: 1
6796: FROM
6797: (SELECT RATES.TAX_REGIME_CODE tax_regime_code,
6798: RATES.CONTENT_OWNER_ID content_owner_id,
6921: NULL,
6922: NULL,
6923: NULL,
6924: SYSDATE,
6925: fnd_global.user_id,
6926: SYSDATE,
6927: fnd_global.user_id,
6928: fnd_global.conc_login_id,
6929: fnd_global.conc_request_id ,-- Request Id
6923: NULL,
6924: SYSDATE,
6925: fnd_global.user_id,
6926: SYSDATE,
6927: fnd_global.user_id,
6928: fnd_global.conc_login_id,
6929: fnd_global.conc_request_id ,-- Request Id
6930: 1
6931: FROM
6924: SYSDATE,
6925: fnd_global.user_id,
6926: SYSDATE,
6927: fnd_global.user_id,
6928: fnd_global.conc_login_id,
6929: fnd_global.conc_request_id ,-- Request Id
6930: 1
6931: FROM
6932: (SELECT RATES.TAX_REGIME_CODE tax_regime_code,
6925: fnd_global.user_id,
6926: SYSDATE,
6927: fnd_global.user_id,
6928: fnd_global.conc_login_id,
6929: fnd_global.conc_request_id ,-- Request Id
6930: 1
6931: FROM
6932: (SELECT RATES.TAX_REGIME_CODE tax_regime_code,
6933: RATES.CONTENT_OWNER_ID content_owner_id,
7062: NULL,
7063: NULL,
7064: NULL,
7065: SYSDATE,
7066: fnd_global.user_id,
7067: SYSDATE,
7068: fnd_global.user_id,
7069: fnd_global.conc_login_id,
7070: fnd_global.conc_request_id ,-- Request Id
7064: NULL,
7065: SYSDATE,
7066: fnd_global.user_id,
7067: SYSDATE,
7068: fnd_global.user_id,
7069: fnd_global.conc_login_id,
7070: fnd_global.conc_request_id ,-- Request Id
7071: 1
7072: FROM
7065: SYSDATE,
7066: fnd_global.user_id,
7067: SYSDATE,
7068: fnd_global.user_id,
7069: fnd_global.conc_login_id,
7070: fnd_global.conc_request_id ,-- Request Id
7071: 1
7072: FROM
7073: (SELECT rates.tax_regime_code TAX_REGIME_CODE,
7066: fnd_global.user_id,
7067: SYSDATE,
7068: fnd_global.user_id,
7069: fnd_global.conc_login_id,
7070: fnd_global.conc_request_id ,-- Request Id
7071: 1
7072: FROM
7073: (SELECT rates.tax_regime_code TAX_REGIME_CODE,
7074: rates.content_owner_id CONTENT_OWNER_ID,
7212: NULL,
7213: NULL,
7214: NULL,
7215: SYSDATE,
7216: fnd_global.user_id,
7217: SYSDATE,
7218: fnd_global.user_id,
7219: fnd_global.conc_login_id,
7220: fnd_global.conc_request_id ,-- Request Id
7214: NULL,
7215: SYSDATE,
7216: fnd_global.user_id,
7217: SYSDATE,
7218: fnd_global.user_id,
7219: fnd_global.conc_login_id,
7220: fnd_global.conc_request_id ,-- Request Id
7221: 1
7222: FROM
7215: SYSDATE,
7216: fnd_global.user_id,
7217: SYSDATE,
7218: fnd_global.user_id,
7219: fnd_global.conc_login_id,
7220: fnd_global.conc_request_id ,-- Request Id
7221: 1
7222: FROM
7223: (SELECT rates.tax_regime_code TAX_REGIME_CODE,
7216: fnd_global.user_id,
7217: SYSDATE,
7218: fnd_global.user_id,
7219: fnd_global.conc_login_id,
7220: fnd_global.conc_request_id ,-- Request Id
7221: 1
7222: FROM
7223: (SELECT rates.tax_regime_code TAX_REGIME_CODE,
7224: rates.content_owner_id CONTENT_OWNER_ID,
7305: SELECT
7306: TAX_STATUS_ID,
7307: TAX_STATUS_CODE,
7308: SYSDATE,
7309: fnd_global.user_id,
7310: SYSDATE,
7311: fnd_global.user_id,
7312: fnd_global.conc_login_id,
7313: L.LANGUAGE_CODE,
7307: TAX_STATUS_CODE,
7308: SYSDATE,
7309: fnd_global.user_id,
7310: SYSDATE,
7311: fnd_global.user_id,
7312: fnd_global.conc_login_id,
7313: L.LANGUAGE_CODE,
7314: userenv('LANG')
7315: FROM
7308: SYSDATE,
7309: fnd_global.user_id,
7310: SYSDATE,
7311: fnd_global.user_id,
7312: fnd_global.conc_login_id,
7313: L.LANGUAGE_CODE,
7314: userenv('LANG')
7315: FROM
7316: FND_LANGUAGES L,
7625: NULL ,--COLL_TAX_AUTHORITY_ID
7626: NULL ,--THRSHLD_CHK_TMPLT_CODE
7627: NULL ,--DEF_PRIMARY_REC_RATE_CODE
7628: NULL ,--DEF_SECONDARY_REC_RATE_CODE
7629: fnd_global.user_id ,
7630: SYSDATE ,
7631: fnd_global.user_id ,
7632: SYSDATE ,
7633: fnd_global.conc_login_id ,
7627: NULL ,--DEF_PRIMARY_REC_RATE_CODE
7628: NULL ,--DEF_SECONDARY_REC_RATE_CODE
7629: fnd_global.user_id ,
7630: SYSDATE ,
7631: fnd_global.user_id ,
7632: SYSDATE ,
7633: fnd_global.conc_login_id ,
7634: fnd_global.conc_request_id ,--Request Id
7635: fnd_global.prog_appl_id ,--Program Application ID
7629: fnd_global.user_id ,
7630: SYSDATE ,
7631: fnd_global.user_id ,
7632: SYSDATE ,
7633: fnd_global.conc_login_id ,
7634: fnd_global.conc_request_id ,--Request Id
7635: fnd_global.prog_appl_id ,--Program Application ID
7636: fnd_global.conc_program_id ,--Program Id
7637: fnd_global.conc_login_id ,--Program Login ID
7630: SYSDATE ,
7631: fnd_global.user_id ,
7632: SYSDATE ,
7633: fnd_global.conc_login_id ,
7634: fnd_global.conc_request_id ,--Request Id
7635: fnd_global.prog_appl_id ,--Program Application ID
7636: fnd_global.conc_program_id ,--Program Id
7637: fnd_global.conc_login_id ,--Program Login ID
7638: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
7631: fnd_global.user_id ,
7632: SYSDATE ,
7633: fnd_global.conc_login_id ,
7634: fnd_global.conc_request_id ,--Request Id
7635: fnd_global.prog_appl_id ,--Program Application ID
7636: fnd_global.conc_program_id ,--Program Id
7637: fnd_global.conc_login_id ,--Program Login ID
7638: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
7639: 1 ,--OBJECT_VERSION_NUMBER
7632: SYSDATE ,
7633: fnd_global.conc_login_id ,
7634: fnd_global.conc_request_id ,--Request Id
7635: fnd_global.prog_appl_id ,--Program Application ID
7636: fnd_global.conc_program_id ,--Program Id
7637: fnd_global.conc_login_id ,--Program Login ID
7638: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
7639: 1 ,--OBJECT_VERSION_NUMBER
7640: 'CREATE_ACCOUNTS' ,--TAX_ACCOUNT_CREATE_METHOD_CODE
7633: fnd_global.conc_login_id ,
7634: fnd_global.conc_request_id ,--Request Id
7635: fnd_global.prog_appl_id ,--Program Application ID
7636: fnd_global.conc_program_id ,--Program Id
7637: fnd_global.conc_login_id ,--Program Login ID
7638: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
7639: 1 ,--OBJECT_VERSION_NUMBER
7640: 'CREATE_ACCOUNTS' ,--TAX_ACCOUNT_CREATE_METHOD_CODE
7641: NULL ,--TAX_ACCOUNT_SOURCE_TAX
7978: NULL ,--COLL_TAX_AUTHORITY_ID
7979: NULL ,--THRSHLD_CHK_TMPLT_CODE
7980: NULL ,--DEF_PRIMARY_REC_RATE_CODE
7981: NULL ,--DEF_SECONDARY_REC_RATE_CODE
7982: fnd_global.user_id ,
7983: SYSDATE ,
7984: fnd_global.user_id ,
7985: SYSDATE ,
7986: fnd_global.conc_login_id ,
7980: NULL ,--DEF_PRIMARY_REC_RATE_CODE
7981: NULL ,--DEF_SECONDARY_REC_RATE_CODE
7982: fnd_global.user_id ,
7983: SYSDATE ,
7984: fnd_global.user_id ,
7985: SYSDATE ,
7986: fnd_global.conc_login_id ,
7987: fnd_global.conc_request_id ,--Request Id
7988: fnd_global.prog_appl_id ,--Program Application ID
7982: fnd_global.user_id ,
7983: SYSDATE ,
7984: fnd_global.user_id ,
7985: SYSDATE ,
7986: fnd_global.conc_login_id ,
7987: fnd_global.conc_request_id ,--Request Id
7988: fnd_global.prog_appl_id ,--Program Application ID
7989: fnd_global.conc_program_id ,--Program Id
7990: fnd_global.conc_login_id ,--Program Login ID
7983: SYSDATE ,
7984: fnd_global.user_id ,
7985: SYSDATE ,
7986: fnd_global.conc_login_id ,
7987: fnd_global.conc_request_id ,--Request Id
7988: fnd_global.prog_appl_id ,--Program Application ID
7989: fnd_global.conc_program_id ,--Program Id
7990: fnd_global.conc_login_id ,--Program Login ID
7991: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
7984: fnd_global.user_id ,
7985: SYSDATE ,
7986: fnd_global.conc_login_id ,
7987: fnd_global.conc_request_id ,--Request Id
7988: fnd_global.prog_appl_id ,--Program Application ID
7989: fnd_global.conc_program_id ,--Program Id
7990: fnd_global.conc_login_id ,--Program Login ID
7991: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
7992: 1 ,--OBJECT_VERSION_NUMBER
7985: SYSDATE ,
7986: fnd_global.conc_login_id ,
7987: fnd_global.conc_request_id ,--Request Id
7988: fnd_global.prog_appl_id ,--Program Application ID
7989: fnd_global.conc_program_id ,--Program Id
7990: fnd_global.conc_login_id ,--Program Login ID
7991: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
7992: 1 ,--OBJECT_VERSION_NUMBER
7993: 'CREATE_ACCOUNTS' ,--TAX_ACCOUNT_CREATE_METHOD_CODE
7986: fnd_global.conc_login_id ,
7987: fnd_global.conc_request_id ,--Request Id
7988: fnd_global.prog_appl_id ,--Program Application ID
7989: fnd_global.conc_program_id ,--Program Id
7990: fnd_global.conc_login_id ,--Program Login ID
7991: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
7992: 1 ,--OBJECT_VERSION_NUMBER
7993: 'CREATE_ACCOUNTS' ,--TAX_ACCOUNT_CREATE_METHOD_CODE
7994: NULL ,--TAX_ACCOUNT_SOURCE_TAX
8097: 'JL.BR.ARXSUVAT.AR_VAT_TAX', c.description,
8098: 'JL.CO.ARXSUVAT.AR_VAT_TAX', c.description,
8099: B.TAX) ,
8100: SYSDATE ,
8101: fnd_global.user_id ,
8102: SYSDATE ,
8103: fnd_global.user_id ,
8104: fnd_global.conc_login_id ,
8105: B.TAX_ID
8099: B.TAX) ,
8100: SYSDATE ,
8101: fnd_global.user_id ,
8102: SYSDATE ,
8103: fnd_global.user_id ,
8104: fnd_global.conc_login_id ,
8105: B.TAX_ID
8106: FROM
8107: FND_LANGUAGES L,
8100: SYSDATE ,
8101: fnd_global.user_id ,
8102: SYSDATE ,
8103: fnd_global.user_id ,
8104: fnd_global.conc_login_id ,
8105: B.TAX_ID
8106: FROM
8107: FND_LANGUAGES L,
8108: ZX_TAXES_B B,
8355: NULL ,--THRSHLD_CHK_TMPLT_CODE
8356: NULL ,--PERIOD_SET_NAME
8357: NULL ,--REP_TAX_AUTHORITY_ID
8358: NULL ,--COLL_TAX_AUTHORITY_ID
8359: fnd_global.user_id ,
8360: SYSDATE ,
8361: fnd_global.user_id ,
8362: SYSDATE ,
8363: fnd_global.conc_login_id ,
8357: NULL ,--REP_TAX_AUTHORITY_ID
8358: NULL ,--COLL_TAX_AUTHORITY_ID
8359: fnd_global.user_id ,
8360: SYSDATE ,
8361: fnd_global.user_id ,
8362: SYSDATE ,
8363: fnd_global.conc_login_id ,
8364: fnd_global.conc_request_id ,--Request Id
8365: fnd_global.prog_appl_id ,--Program Application ID
8359: fnd_global.user_id ,
8360: SYSDATE ,
8361: fnd_global.user_id ,
8362: SYSDATE ,
8363: fnd_global.conc_login_id ,
8364: fnd_global.conc_request_id ,--Request Id
8365: fnd_global.prog_appl_id ,--Program Application ID
8366: fnd_global.conc_program_id ,--Program Id
8367: fnd_global.conc_login_id --Program Login ID
8360: SYSDATE ,
8361: fnd_global.user_id ,
8362: SYSDATE ,
8363: fnd_global.conc_login_id ,
8364: fnd_global.conc_request_id ,--Request Id
8365: fnd_global.prog_appl_id ,--Program Application ID
8366: fnd_global.conc_program_id ,--Program Id
8367: fnd_global.conc_login_id --Program Login ID
8368:
8361: fnd_global.user_id ,
8362: SYSDATE ,
8363: fnd_global.conc_login_id ,
8364: fnd_global.conc_request_id ,--Request Id
8365: fnd_global.prog_appl_id ,--Program Application ID
8366: fnd_global.conc_program_id ,--Program Id
8367: fnd_global.conc_login_id --Program Login ID
8368:
8369: FROM
8362: SYSDATE ,
8363: fnd_global.conc_login_id ,
8364: fnd_global.conc_request_id ,--Request Id
8365: fnd_global.prog_appl_id ,--Program Application ID
8366: fnd_global.conc_program_id ,--Program Id
8367: fnd_global.conc_login_id --Program Login ID
8368:
8369: FROM
8370: (
8363: fnd_global.conc_login_id ,
8364: fnd_global.conc_request_id ,--Request Id
8365: fnd_global.prog_appl_id ,--Program Application ID
8366: fnd_global.conc_program_id ,--Program Id
8367: fnd_global.conc_login_id --Program Login ID
8368:
8369: FROM
8370: (
8371: SELECT RATES.TAX_REGIME_CODE TAX_REGIME_CODE,
8411: 'JL.BR.ARXSYSPA.SYS_PARAMETERS', d.meaning,
8412: 'JL.CO.ARXSYSPA.SYS_PARAMETERS', d.meaning,
8413: B.TAX_REGIME_CODE),
8414: SYSDATE ,
8415: fnd_global.user_id ,
8416: SYSDATE ,
8417: fnd_global.user_id ,
8418: fnd_global.conc_login_id ,
8419: B.TAX_REGIME_ID
8413: B.TAX_REGIME_CODE),
8414: SYSDATE ,
8415: fnd_global.user_id ,
8416: SYSDATE ,
8417: fnd_global.user_id ,
8418: fnd_global.conc_login_id ,
8419: B.TAX_REGIME_ID
8420: FROM
8421: FND_LANGUAGES L,
8414: SYSDATE ,
8415: fnd_global.user_id ,
8416: SYSDATE ,
8417: fnd_global.user_id ,
8418: fnd_global.conc_login_id ,
8419: B.TAX_REGIME_ID
8420: FROM
8421: FND_LANGUAGES L,
8422: ZX_REGIMES_B B,
8553: ATTRIBUTE14 ,
8554: ATTRIBUTE15 ,
8555: TAG ,
8556: SYSDATE ,
8557: fnd_global.user_id ,
8558: SYSDATE ,
8559: fnd_global.user_id ,
8560: fnd_global.conc_login_id
8561: FROM FND_LOOKUP_VALUES ap_lookups
8555: TAG ,
8556: SYSDATE ,
8557: fnd_global.user_id ,
8558: SYSDATE ,
8559: fnd_global.user_id ,
8560: fnd_global.conc_login_id
8561: FROM FND_LOOKUP_VALUES ap_lookups
8562: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
8563: AND NOT EXISTS
8556: SYSDATE ,
8557: fnd_global.user_id ,
8558: SYSDATE ,
8559: fnd_global.user_id ,
8560: fnd_global.conc_login_id
8561: FROM FND_LOOKUP_VALUES ap_lookups
8562: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
8563: AND NOT EXISTS
8564: (select 1 from FND_LOOKUP_VALUES
8602: ATTRIBUTE14 ,
8603: ATTRIBUTE15 ,
8604: TAG ,
8605: SYSDATE ,
8606: fnd_global.user_id ,
8607: SYSDATE ,
8608: fnd_global.user_id ,
8609: fnd_global.conc_login_id
8610: FROM FND_LOOKUP_VALUES ar_lookups
8604: TAG ,
8605: SYSDATE ,
8606: fnd_global.user_id ,
8607: SYSDATE ,
8608: fnd_global.user_id ,
8609: fnd_global.conc_login_id
8610: FROM FND_LOOKUP_VALUES ar_lookups
8611: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8612: /* AND NOT EXISTS
8605: SYSDATE ,
8606: fnd_global.user_id ,
8607: SYSDATE ,
8608: fnd_global.user_id ,
8609: fnd_global.conc_login_id
8610: FROM FND_LOOKUP_VALUES ar_lookups
8611: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8612: /* AND NOT EXISTS
8613: (select 1 from FND_LOOKUP_VALUES
8697: ATTRIBUTE14 ,
8698: ATTRIBUTE15 ,
8699: TAG ,
8700: SYSDATE ,
8701: fnd_global.user_id ,
8702: SYSDATE ,
8703: fnd_global.user_id ,
8704: fnd_global.conc_login_id
8705: FROM FND_LOOKUP_VALUES ar_lookups
8699: TAG ,
8700: SYSDATE ,
8701: fnd_global.user_id ,
8702: SYSDATE ,
8703: fnd_global.user_id ,
8704: fnd_global.conc_login_id
8705: FROM FND_LOOKUP_VALUES ar_lookups
8706: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8707: -- Changed the re-runnability check
8700: SYSDATE ,
8701: fnd_global.user_id ,
8702: SYSDATE ,
8703: fnd_global.user_id ,
8704: fnd_global.conc_login_id
8705: FROM FND_LOOKUP_VALUES ar_lookups
8706: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8707: -- Changed the re-runnability check
8708: AND NOT EXISTS
9066: codes.tag , --TAG --Bug 4562058
9067: SYSDATE , --CREATION_DATE
9068: -1087 , --CREATED_BY --Bug 4562058
9069: SYSDATE , --LAST_UPDATE_DATE
9070: fnd_global.user_id , --LAST_UPDATED_BY
9071: fnd_global.conc_login_id --LAST_UPDATE_LOGIN
9072: FROM
9073: (
9074: SELECT
9067: SYSDATE , --CREATION_DATE
9068: -1087 , --CREATED_BY --Bug 4562058
9069: SYSDATE , --LAST_UPDATE_DATE
9070: fnd_global.user_id , --LAST_UPDATED_BY
9071: fnd_global.conc_login_id --LAST_UPDATE_LOGIN
9072: FROM
9073: (
9074: SELECT
9075: CASE WHEN LENGTHB(codes.tax_code) > 30
9146: codes.tax_type,
9147: 'AR',
9148: codes.start_date,
9149: codes.end_date,
9150: fnd_global.user_id , -- CREATED_BY
9151: SYSDATE , -- CREATION_DATE
9152: fnd_global.user_id , -- LAST_UPDATED_BY
9153: SYSDATE , -- LAST_UPDATE_DATE
9154: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
9148: codes.start_date,
9149: codes.end_date,
9150: fnd_global.user_id , -- CREATED_BY
9151: SYSDATE , -- CREATION_DATE
9152: fnd_global.user_id , -- LAST_UPDATED_BY
9153: SYSDATE , -- LAST_UPDATE_DATE
9154: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
9155: fnd_global.conc_request_id , -- REQUEST_ID
9156: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
9150: fnd_global.user_id , -- CREATED_BY
9151: SYSDATE , -- CREATION_DATE
9152: fnd_global.user_id , -- LAST_UPDATED_BY
9153: SYSDATE , -- LAST_UPDATE_DATE
9154: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
9155: fnd_global.conc_request_id , -- REQUEST_ID
9156: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
9157: fnd_global.conc_program_id , -- PROGRAM_ID
9158: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
9151: SYSDATE , -- CREATION_DATE
9152: fnd_global.user_id , -- LAST_UPDATED_BY
9153: SYSDATE , -- LAST_UPDATE_DATE
9154: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
9155: fnd_global.conc_request_id , -- REQUEST_ID
9156: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
9157: fnd_global.conc_program_id , -- PROGRAM_ID
9158: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
9159: codes.set_of_books_id , -- SET_OF_BOOKS_ID
9152: fnd_global.user_id , -- LAST_UPDATED_BY
9153: SYSDATE , -- LAST_UPDATE_DATE
9154: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
9155: fnd_global.conc_request_id , -- REQUEST_ID
9156: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
9157: fnd_global.conc_program_id , -- PROGRAM_ID
9158: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
9159: codes.set_of_books_id , -- SET_OF_BOOKS_ID
9160: codes.enabled_flag
9153: SYSDATE , -- LAST_UPDATE_DATE
9154: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
9155: fnd_global.conc_request_id , -- REQUEST_ID
9156: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
9157: fnd_global.conc_program_id , -- PROGRAM_ID
9158: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
9159: codes.set_of_books_id , -- SET_OF_BOOKS_ID
9160: codes.enabled_flag
9161: FROM
9154: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
9155: fnd_global.conc_request_id , -- REQUEST_ID
9156: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
9157: fnd_global.conc_program_id , -- PROGRAM_ID
9158: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
9159: codes.set_of_books_id , -- SET_OF_BOOKS_ID
9160: codes.enabled_flag
9161: FROM
9162: ar_vat_tax_all_b codes
9302: ELSE
9303: TAX_REGIME_CODE
9304: END,
9305: SYSDATE,
9306: fnd_global.user_id,
9307: SYSDATE,
9308: fnd_global.user_id,
9309: fnd_global.conc_login_id,
9310: L.LANGUAGE_CODE,
9304: END,
9305: SYSDATE,
9306: fnd_global.user_id,
9307: SYSDATE,
9308: fnd_global.user_id,
9309: fnd_global.conc_login_id,
9310: L.LANGUAGE_CODE,
9311: userenv('LANG')
9312: FROM
9305: SYSDATE,
9306: fnd_global.user_id,
9307: SYSDATE,
9308: fnd_global.user_id,
9309: fnd_global.conc_login_id,
9310: L.LANGUAGE_CODE,
9311: userenv('LANG')
9312: FROM
9313: FND_LANGUAGES L,
9352: ELSE
9353: flv.meaning
9354: END,
9355: SYSDATE ,
9356: fnd_global.user_id ,
9357: SYSDATE ,
9358: fnd_global.user_id ,
9359: fnd_global.conc_login_id ,
9360: taxes.tax_id
9354: END,
9355: SYSDATE ,
9356: fnd_global.user_id ,
9357: SYSDATE ,
9358: fnd_global.user_id ,
9359: fnd_global.conc_login_id ,
9360: taxes.tax_id
9361: FROM
9362: zx_taxes_b taxes,
9355: SYSDATE ,
9356: fnd_global.user_id ,
9357: SYSDATE ,
9358: fnd_global.user_id ,
9359: fnd_global.conc_login_id ,
9360: taxes.tax_id
9361: FROM
9362: zx_taxes_b taxes,
9363: zx_rates_b rates,
9400: ELSE
9401: flv.meaning
9402: END,
9403: SYSDATE ,
9404: fnd_global.user_id ,
9405: SYSDATE ,
9406: fnd_global.user_id ,
9407: fnd_global.conc_login_id ,
9408: taxes.tax_id
9402: END,
9403: SYSDATE ,
9404: fnd_global.user_id ,
9405: SYSDATE ,
9406: fnd_global.user_id ,
9407: fnd_global.conc_login_id ,
9408: taxes.tax_id
9409: FROM
9410: zx_taxes_b taxes,
9403: SYSDATE ,
9404: fnd_global.user_id ,
9405: SYSDATE ,
9406: fnd_global.user_id ,
9407: fnd_global.conc_login_id ,
9408: taxes.tax_id
9409: FROM
9410: zx_taxes_b taxes,
9411: zx_rates_b rates,
9447: ELSE
9448: flv.meaning
9449: END,
9450: SYSDATE ,
9451: fnd_global.user_id ,
9452: SYSDATE ,
9453: fnd_global.user_id ,
9454: fnd_global.conc_login_id ,
9455: taxes.tax_id
9449: END,
9450: SYSDATE ,
9451: fnd_global.user_id ,
9452: SYSDATE ,
9453: fnd_global.user_id ,
9454: fnd_global.conc_login_id ,
9455: taxes.tax_id
9456: FROM
9457: zx_taxes_b taxes,
9450: SYSDATE ,
9451: fnd_global.user_id ,
9452: SYSDATE ,
9453: fnd_global.user_id ,
9454: fnd_global.conc_login_id ,
9455: taxes.tax_id
9456: FROM
9457: zx_taxes_b taxes,
9458: zx_rates_b rates,
9497: ELSE
9498: NVL(categs.description, rates.tax)
9499: END,
9500: SYSDATE ,
9501: fnd_global.user_id ,
9502: SYSDATE ,
9503: fnd_global.user_id ,
9504: fnd_global.conc_login_id ,
9505: B.TAX_ID
9499: END,
9500: SYSDATE ,
9501: fnd_global.user_id ,
9502: SYSDATE ,
9503: fnd_global.user_id ,
9504: fnd_global.conc_login_id ,
9505: B.TAX_ID
9506: FROM
9507: FND_LANGUAGES L,
9500: SYSDATE ,
9501: fnd_global.user_id ,
9502: SYSDATE ,
9503: fnd_global.user_id ,
9504: fnd_global.conc_login_id ,
9505: B.TAX_ID
9506: FROM
9507: FND_LANGUAGES L,
9508: ZX_TAXES_B B,
9546: ELSE
9547: NVL(categs.description, rates.tax)
9548: END ,
9549: SYSDATE ,
9550: fnd_global.user_id ,
9551: SYSDATE ,
9552: fnd_global.user_id ,
9553: fnd_global.conc_login_id ,
9554: B.TAX_ID
9548: END ,
9549: SYSDATE ,
9550: fnd_global.user_id ,
9551: SYSDATE ,
9552: fnd_global.user_id ,
9553: fnd_global.conc_login_id ,
9554: B.TAX_ID
9555: FROM
9556: FND_LANGUAGES L,
9549: SYSDATE ,
9550: fnd_global.user_id ,
9551: SYSDATE ,
9552: fnd_global.user_id ,
9553: fnd_global.conc_login_id ,
9554: B.TAX_ID
9555: FROM
9556: FND_LANGUAGES L,
9557: ZX_TAXES_B B,
9595: ELSE
9596: NVL(categs.description, rates.tax)
9597: END ,
9598: SYSDATE ,
9599: fnd_global.user_id ,
9600: SYSDATE ,
9601: fnd_global.user_id ,
9602: fnd_global.conc_login_id ,
9603: B.TAX_ID
9597: END ,
9598: SYSDATE ,
9599: fnd_global.user_id ,
9600: SYSDATE ,
9601: fnd_global.user_id ,
9602: fnd_global.conc_login_id ,
9603: B.TAX_ID
9604: FROM
9605: FND_LANGUAGES L,
9598: SYSDATE ,
9599: fnd_global.user_id ,
9600: SYSDATE ,
9601: fnd_global.user_id ,
9602: fnd_global.conc_login_id ,
9603: B.TAX_ID
9604: FROM
9605: FND_LANGUAGES L,
9606: ZX_TAXES_B B,
9643: ELSE
9644: TAX
9645: END,
9646: SYSDATE,
9647: fnd_global.user_id,
9648: SYSDATE,
9649: fnd_global.user_id,
9650: fnd_global.conc_login_id,
9651: L.LANGUAGE_CODE,
9645: END,
9646: SYSDATE,
9647: fnd_global.user_id,
9648: SYSDATE,
9649: fnd_global.user_id,
9650: fnd_global.conc_login_id,
9651: L.LANGUAGE_CODE,
9652: userenv('LANG')
9653: FROM
9646: SYSDATE,
9647: fnd_global.user_id,
9648: SYSDATE,
9649: fnd_global.user_id,
9650: fnd_global.conc_login_id,
9651: L.LANGUAGE_CODE,
9652: userenv('LANG')
9653: FROM
9654: FND_LANGUAGES L,
9704: 'JL.BR.ARXSUVAT.AR_VAT_TAX', c.description,
9705: 'JL.CO.ARXSUVAT.AR_VAT_TAX', c.description,
9706: B.TAX) ,
9707: SYSDATE ,
9708: fnd_global.user_id ,
9709: SYSDATE ,
9710: fnd_global.user_id ,
9711: fnd_global.conc_login_id ,
9712: B.TAX_ID
9706: B.TAX) ,
9707: SYSDATE ,
9708: fnd_global.user_id ,
9709: SYSDATE ,
9710: fnd_global.user_id ,
9711: fnd_global.conc_login_id ,
9712: B.TAX_ID
9713: FROM
9714: FND_LANGUAGES L,
9707: SYSDATE ,
9708: fnd_global.user_id ,
9709: SYSDATE ,
9710: fnd_global.user_id ,
9711: fnd_global.conc_login_id ,
9712: B.TAX_ID
9713: FROM
9714: FND_LANGUAGES L,
9715: ZX_TAXES_B B,
9766: ELSE
9767: flv.meaning
9768: END,
9769: sysdate,
9770: fnd_global.user_id,
9771: sysdate,
9772: fnd_global.user_id,
9773: fnd_global.conc_login_id,
9774: flv.language,
9768: END,
9769: sysdate,
9770: fnd_global.user_id,
9771: sysdate,
9772: fnd_global.user_id,
9773: fnd_global.conc_login_id,
9774: flv.language,
9775: userenv('LANG')
9776: from zx_rates_b rates,
9769: sysdate,
9770: fnd_global.user_id,
9771: sysdate,
9772: fnd_global.user_id,
9773: fnd_global.conc_login_id,
9774: flv.language,
9775: userenv('LANG')
9776: from zx_rates_b rates,
9777: zx_status_b status,
9815: ELSE
9816: TAX_STATUS_CODE
9817: END,
9818: SYSDATE,
9819: fnd_global.user_id,
9820: SYSDATE,
9821: fnd_global.user_id,
9822: fnd_global.conc_login_id,
9823: L.LANGUAGE_CODE,
9817: END,
9818: SYSDATE,
9819: fnd_global.user_id,
9820: SYSDATE,
9821: fnd_global.user_id,
9822: fnd_global.conc_login_id,
9823: L.LANGUAGE_CODE,
9824: userenv('LANG')
9825: FROM
9818: SYSDATE,
9819: fnd_global.user_id,
9820: SYSDATE,
9821: fnd_global.user_id,
9822: fnd_global.conc_login_id,
9823: L.LANGUAGE_CODE,
9824: userenv('LANG')
9825: FROM
9826: FND_LANGUAGES L,
9854: CASE WHEN avtt.PRINTED_TAX_NAME = UPPER(avtt.PRINTED_TAX_NAME)
9855: THEN Initcap(avtt.PRINTED_TAX_NAME)
9856: ELSE avtt.PRINTED_TAX_NAME
9857: END,-- Bug 4705196
9858: fnd_global.user_id ,
9859: SYSDATE ,
9860: fnd_global.user_id ,
9861: SYSDATE ,
9862: fnd_global.conc_login_id ,
9856: ELSE avtt.PRINTED_TAX_NAME
9857: END,-- Bug 4705196
9858: fnd_global.user_id ,
9859: SYSDATE ,
9860: fnd_global.user_id ,
9861: SYSDATE ,
9862: fnd_global.conc_login_id ,
9863: avtt.language ,
9864: avtt.source_lang ,
9858: fnd_global.user_id ,
9859: SYSDATE ,
9860: fnd_global.user_id ,
9861: SYSDATE ,
9862: fnd_global.conc_login_id ,
9863: avtt.language ,
9864: avtt.source_lang ,
9865: avtb.description
9866: FROM ar_vat_tax_all_tl avtt,
10030: 'STANDARD_TB' , --taxable_basis_formula_code
10031: 'N' , --inclusive_tax_flag
10032: 'N' , --tax_inclusive_override_flag
10033: 'MIGRATED' , --record_type_code
10034: fnd_global.user_id , --created_by
10035: SYSDATE , --creation_date
10036: fnd_global.user_id , --last_updated_by
10037: SYSDATE , --last_update_date
10038: fnd_global.user_id , --last_update_login
10032: 'N' , --tax_inclusive_override_flag
10033: 'MIGRATED' , --record_type_code
10034: fnd_global.user_id , --created_by
10035: SYSDATE , --creation_date
10036: fnd_global.user_id , --last_updated_by
10037: SYSDATE , --last_update_date
10038: fnd_global.user_id , --last_update_login
10039: fnd_global.conc_request_id , --request_id
10040: fnd_global.prog_appl_id , --program_application_id
10034: fnd_global.user_id , --created_by
10035: SYSDATE , --creation_date
10036: fnd_global.user_id , --last_updated_by
10037: SYSDATE , --last_update_date
10038: fnd_global.user_id , --last_update_login
10039: fnd_global.conc_request_id , --request_id
10040: fnd_global.prog_appl_id , --program_application_id
10041: fnd_global.conc_program_id , --program_id
10042: fnd_global.conc_login_id , --program_login_id
10035: SYSDATE , --creation_date
10036: fnd_global.user_id , --last_updated_by
10037: SYSDATE , --last_update_date
10038: fnd_global.user_id , --last_update_login
10039: fnd_global.conc_request_id , --request_id
10040: fnd_global.prog_appl_id , --program_application_id
10041: fnd_global.conc_program_id , --program_id
10042: fnd_global.conc_login_id , --program_login_id
10043: NULL , --ATTRIBUTE1
10036: fnd_global.user_id , --last_updated_by
10037: SYSDATE , --last_update_date
10038: fnd_global.user_id , --last_update_login
10039: fnd_global.conc_request_id , --request_id
10040: fnd_global.prog_appl_id , --program_application_id
10041: fnd_global.conc_program_id , --program_id
10042: fnd_global.conc_login_id , --program_login_id
10043: NULL , --ATTRIBUTE1
10044: NULL , --ATTRIBUTE2
10037: SYSDATE , --last_update_date
10038: fnd_global.user_id , --last_update_login
10039: fnd_global.conc_request_id , --request_id
10040: fnd_global.prog_appl_id , --program_application_id
10041: fnd_global.conc_program_id , --program_id
10042: fnd_global.conc_login_id , --program_login_id
10043: NULL , --ATTRIBUTE1
10044: NULL , --ATTRIBUTE2
10045: NULL , --ATTRIBUTE3
10038: fnd_global.user_id , --last_update_login
10039: fnd_global.conc_request_id , --request_id
10040: fnd_global.prog_appl_id , --program_application_id
10041: fnd_global.conc_program_id , --program_id
10042: fnd_global.conc_login_id , --program_login_id
10043: NULL , --ATTRIBUTE1
10044: NULL , --ATTRIBUTE2
10045: NULL , --ATTRIBUTE3
10046: NULL , --ATTRIBUTE4
10124: NULL ,--EDISC_NON_REC_TAX_CCID
10125: NULL ,--UNEDISC_NON_REC_TAX_CCID
10126: NULL ,--FINCHRG_NON_REC_TAX_CCID
10127: 'MIGRATED' ,--RECORD_TYPE_CODE
10128: fnd_global.user_id ,--CREATED_BY
10129: sysdate ,--CREATION_DATE
10130: fnd_global.user_id ,--LAST_UPDATED_BY
10131: sysdate ,--LAST_UPDATE_DATE
10132: fnd_global.user_id ,--LAST_UPDATE_LOGIN
10126: NULL ,--FINCHRG_NON_REC_TAX_CCID
10127: 'MIGRATED' ,--RECORD_TYPE_CODE
10128: fnd_global.user_id ,--CREATED_BY
10129: sysdate ,--CREATION_DATE
10130: fnd_global.user_id ,--LAST_UPDATED_BY
10131: sysdate ,--LAST_UPDATE_DATE
10132: fnd_global.user_id ,--LAST_UPDATE_LOGIN
10133: fnd_global.conc_request_id ,--REQUEST_ID
10134: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
10128: fnd_global.user_id ,--CREATED_BY
10129: sysdate ,--CREATION_DATE
10130: fnd_global.user_id ,--LAST_UPDATED_BY
10131: sysdate ,--LAST_UPDATE_DATE
10132: fnd_global.user_id ,--LAST_UPDATE_LOGIN
10133: fnd_global.conc_request_id ,--REQUEST_ID
10134: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
10135: fnd_global.conc_program_id ,--PROGRAM_ID
10136: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
10129: sysdate ,--CREATION_DATE
10130: fnd_global.user_id ,--LAST_UPDATED_BY
10131: sysdate ,--LAST_UPDATE_DATE
10132: fnd_global.user_id ,--LAST_UPDATE_LOGIN
10133: fnd_global.conc_request_id ,--REQUEST_ID
10134: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
10135: fnd_global.conc_program_id ,--PROGRAM_ID
10136: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
10137: NULL ,--ATTRIBUTE1
10130: fnd_global.user_id ,--LAST_UPDATED_BY
10131: sysdate ,--LAST_UPDATE_DATE
10132: fnd_global.user_id ,--LAST_UPDATE_LOGIN
10133: fnd_global.conc_request_id ,--REQUEST_ID
10134: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
10135: fnd_global.conc_program_id ,--PROGRAM_ID
10136: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
10137: NULL ,--ATTRIBUTE1
10138: NULL ,--ATTRIBUTE2
10131: sysdate ,--LAST_UPDATE_DATE
10132: fnd_global.user_id ,--LAST_UPDATE_LOGIN
10133: fnd_global.conc_request_id ,--REQUEST_ID
10134: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
10135: fnd_global.conc_program_id ,--PROGRAM_ID
10136: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
10137: NULL ,--ATTRIBUTE1
10138: NULL ,--ATTRIBUTE2
10139: NULL ,--ATTRIBUTE3
10132: fnd_global.user_id ,--LAST_UPDATE_LOGIN
10133: fnd_global.conc_request_id ,--REQUEST_ID
10134: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
10135: fnd_global.conc_program_id ,--PROGRAM_ID
10136: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
10137: NULL ,--ATTRIBUTE1
10138: NULL ,--ATTRIBUTE2
10139: NULL ,--ATTRIBUTE3
10140: NULL ,--ATTRIBUTE4
10170: )
10171: SELECT
10172: b.tax_rate_id,
10173: b.tax_rate_code,
10174: fnd_global.user_id,
10175: sysdate,
10176: fnd_global.user_id,
10177: sysdate,
10178: fnd_global.login_id,
10172: b.tax_rate_id,
10173: b.tax_rate_code,
10174: fnd_global.user_id,
10175: sysdate,
10176: fnd_global.user_id,
10177: sysdate,
10178: fnd_global.login_id,
10179: l.language_code,
10180: userenv('LANG'),
10174: fnd_global.user_id,
10175: sysdate,
10176: fnd_global.user_id,
10177: sysdate,
10178: fnd_global.login_id,
10179: l.language_code,
10180: userenv('LANG'),
10181: avtb.description
10182: FROM