1330: NULL ,--THRSHLD_CHK_TMPLT_CODE
1331: NULL ,--PERIOD_SET_NAME
1332: NULL ,--REP_TAX_AUTHORITY_ID
1333: NULL ,--COLL_TAX_AUTHORITY_ID
1334: fnd_global.user_id ,
1335: SYSDATE ,
1336: fnd_global.user_id ,
1337: SYSDATE ,
1338: fnd_global.conc_login_id ,
1332: NULL ,--REP_TAX_AUTHORITY_ID
1333: NULL ,--COLL_TAX_AUTHORITY_ID
1334: fnd_global.user_id ,
1335: SYSDATE ,
1336: fnd_global.user_id ,
1337: SYSDATE ,
1338: fnd_global.conc_login_id ,
1339: fnd_global.conc_request_id ,--Request Id
1340: fnd_global.prog_appl_id ,--Program Application ID
1334: fnd_global.user_id ,
1335: SYSDATE ,
1336: fnd_global.user_id ,
1337: SYSDATE ,
1338: fnd_global.conc_login_id ,
1339: fnd_global.conc_request_id ,--Request Id
1340: fnd_global.prog_appl_id ,--Program Application ID
1341: fnd_global.conc_program_id ,--Program Id
1342: fnd_global.conc_login_id , --Program Login ID
1335: SYSDATE ,
1336: fnd_global.user_id ,
1337: SYSDATE ,
1338: fnd_global.conc_login_id ,
1339: fnd_global.conc_request_id ,--Request Id
1340: fnd_global.prog_appl_id ,--Program Application ID
1341: fnd_global.conc_program_id ,--Program Id
1342: fnd_global.conc_login_id , --Program Login ID
1343: 1
1336: fnd_global.user_id ,
1337: SYSDATE ,
1338: fnd_global.conc_login_id ,
1339: fnd_global.conc_request_id ,--Request Id
1340: fnd_global.prog_appl_id ,--Program Application ID
1341: fnd_global.conc_program_id ,--Program Id
1342: fnd_global.conc_login_id , --Program Login ID
1343: 1
1344: )
1337: SYSDATE ,
1338: fnd_global.conc_login_id ,
1339: fnd_global.conc_request_id ,--Request Id
1340: fnd_global.prog_appl_id ,--Program Application ID
1341: fnd_global.conc_program_id ,--Program Id
1342: fnd_global.conc_login_id , --Program Login ID
1343: 1
1344: )
1345:
1338: fnd_global.conc_login_id ,
1339: fnd_global.conc_request_id ,--Request Id
1340: fnd_global.prog_appl_id ,--Program Application ID
1341: fnd_global.conc_program_id ,--Program Id
1342: fnd_global.conc_login_id , --Program Login ID
1343: 1
1344: )
1345:
1346: WHEN (NOT EXISTS (SELECT 1
1365: userenv('LANG'),
1366: userenv('LANG'),
1367: l_tax_regime_name,
1368: SYSDATE,
1369: fnd_global.user_id ,
1370: SYSDATE ,
1371: fnd_global.user_id ,
1372: fnd_global.conc_login_id ,
1373: ZX_REGIMES_B_S.NEXTVAL
1367: l_tax_regime_name,
1368: SYSDATE,
1369: fnd_global.user_id ,
1370: SYSDATE ,
1371: fnd_global.user_id ,
1372: fnd_global.conc_login_id ,
1373: ZX_REGIMES_B_S.NEXTVAL
1374: )
1375: SELECT 1 FROM DUAL;
1368: SYSDATE,
1369: fnd_global.user_id ,
1370: SYSDATE ,
1371: fnd_global.user_id ,
1372: fnd_global.conc_login_id ,
1373: ZX_REGIMES_B_S.NEXTVAL
1374: )
1375: SELECT 1 FROM DUAL;
1376:
2163: NULL L_COLL_TAX_AUTHORITY_ID,
2164: NULL L_THRSHLD_CHK_TMPLT_CODE,
2165: NULL L_DEF_PRIMARY_REC_RATE_CODE,
2166: NULL L_DEF_SECONDARY_REC_RATE_CODE,
2167: fnd_global.user_id L_CREATED_BY,
2168: SYSDATE L_CREATION_DATE,
2169: fnd_global.user_id L_LAST_UPDATED_BY,
2170: SYSDATE L_LAST_UPDATE_DATE,
2171: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2165: NULL L_DEF_PRIMARY_REC_RATE_CODE,
2166: NULL L_DEF_SECONDARY_REC_RATE_CODE,
2167: fnd_global.user_id L_CREATED_BY,
2168: SYSDATE L_CREATION_DATE,
2169: fnd_global.user_id L_LAST_UPDATED_BY,
2170: SYSDATE L_LAST_UPDATE_DATE,
2171: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2172: fnd_global.conc_request_id L_REQUEST_ID,
2173: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2167: fnd_global.user_id L_CREATED_BY,
2168: SYSDATE L_CREATION_DATE,
2169: fnd_global.user_id L_LAST_UPDATED_BY,
2170: SYSDATE L_LAST_UPDATE_DATE,
2171: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2172: fnd_global.conc_request_id L_REQUEST_ID,
2173: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2174: fnd_global.conc_program_id L_PROGRAM_ID,
2175: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2168: SYSDATE L_CREATION_DATE,
2169: fnd_global.user_id L_LAST_UPDATED_BY,
2170: SYSDATE L_LAST_UPDATE_DATE,
2171: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2172: fnd_global.conc_request_id L_REQUEST_ID,
2173: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2174: fnd_global.conc_program_id L_PROGRAM_ID,
2175: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2176: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2169: fnd_global.user_id L_LAST_UPDATED_BY,
2170: SYSDATE L_LAST_UPDATE_DATE,
2171: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2172: fnd_global.conc_request_id L_REQUEST_ID,
2173: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2174: fnd_global.conc_program_id L_PROGRAM_ID,
2175: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2176: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2177: NULL L_TAX_ACCOUNT_SOURCE_TAX , --Bug 4204464
2170: SYSDATE L_LAST_UPDATE_DATE,
2171: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2172: fnd_global.conc_request_id L_REQUEST_ID,
2173: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2174: fnd_global.conc_program_id L_PROGRAM_ID,
2175: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2176: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2177: NULL L_TAX_ACCOUNT_SOURCE_TAX , --Bug 4204464
2178: 'CREATE_EXEMPTIONS' L_TAX_EXMPT_CR_MTHD_CD , --Bug 4204464
2171: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2172: fnd_global.conc_request_id L_REQUEST_ID,
2173: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2174: fnd_global.conc_program_id L_PROGRAM_ID,
2175: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2176: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2177: NULL L_TAX_ACCOUNT_SOURCE_TAX , --Bug 4204464
2178: 'CREATE_EXEMPTIONS' L_TAX_EXMPT_CR_MTHD_CD , --Bug 4204464
2179: NULL L_TAX_EXMPT_SOURCE_TAX,
2578: NULL L_COLL_TAX_AUTHORITY_ID,
2579: NULL L_THRSHLD_CHK_TMPLT_CODE,
2580: NULL L_DEF_PRIMARY_REC_RATE_CODE,
2581: NULL L_DEF_SECONDARY_REC_RATE_CODE,
2582: fnd_global.user_id L_CREATED_BY,
2583: SYSDATE L_CREATION_DATE,
2584: fnd_global.user_id L_LAST_UPDATED_BY,
2585: SYSDATE L_LAST_UPDATE_DATE,
2586: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2580: NULL L_DEF_PRIMARY_REC_RATE_CODE,
2581: NULL L_DEF_SECONDARY_REC_RATE_CODE,
2582: fnd_global.user_id L_CREATED_BY,
2583: SYSDATE L_CREATION_DATE,
2584: fnd_global.user_id L_LAST_UPDATED_BY,
2585: SYSDATE L_LAST_UPDATE_DATE,
2586: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2587: fnd_global.conc_request_id L_REQUEST_ID,
2588: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2582: fnd_global.user_id L_CREATED_BY,
2583: SYSDATE L_CREATION_DATE,
2584: fnd_global.user_id L_LAST_UPDATED_BY,
2585: SYSDATE L_LAST_UPDATE_DATE,
2586: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2587: fnd_global.conc_request_id L_REQUEST_ID,
2588: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2589: fnd_global.conc_program_id L_PROGRAM_ID,
2590: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2583: SYSDATE L_CREATION_DATE,
2584: fnd_global.user_id L_LAST_UPDATED_BY,
2585: SYSDATE L_LAST_UPDATE_DATE,
2586: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2587: fnd_global.conc_request_id L_REQUEST_ID,
2588: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2589: fnd_global.conc_program_id L_PROGRAM_ID,
2590: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2591: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2584: fnd_global.user_id L_LAST_UPDATED_BY,
2585: SYSDATE L_LAST_UPDATE_DATE,
2586: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2587: fnd_global.conc_request_id L_REQUEST_ID,
2588: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2589: fnd_global.conc_program_id L_PROGRAM_ID,
2590: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2591: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2592: NULL L_TAX_ACCOUNT_SOURCE_TAX , --Bug 4204464
2585: SYSDATE L_LAST_UPDATE_DATE,
2586: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2587: fnd_global.conc_request_id L_REQUEST_ID,
2588: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2589: fnd_global.conc_program_id L_PROGRAM_ID,
2590: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2591: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2592: NULL L_TAX_ACCOUNT_SOURCE_TAX , --Bug 4204464
2593: 'CREATE_EXEMPTIONS' L_TAX_EXMPT_CR_MTHD_CD , --Bug 4204464
2586: fnd_global.conc_login_id L_LAST_UPDATE_LOGIN,
2587: fnd_global.conc_request_id L_REQUEST_ID,
2588: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
2589: fnd_global.conc_program_id L_PROGRAM_ID,
2590: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
2591: 'CREATE_ACCOUNTS' L_TAX_ACCOUNT_CR_METHOD_CODE, --Bug 4204464
2592: NULL L_TAX_ACCOUNT_SOURCE_TAX , --Bug 4204464
2593: 'CREATE_EXEMPTIONS' L_TAX_EXMPT_CR_MTHD_CD , --Bug 4204464
2594: NULL L_TAX_EXMPT_SOURCE_TAX,
2770: NULL l_attribute14,
2771: NULL l_attribute15,
2772: NULL l_attribute_category,
2773: SYSDATE l_creation_date,
2774: fnd_global.user_id l_created_by,
2775: SYSDATE l_last_update_date,
2776: fnd_global.user_id l_last_updated_by,
2777: fnd_global.conc_login_id l_last_update_login,
2778: fnd_global.conc_request_id l_request_id
2772: NULL l_attribute_category,
2773: SYSDATE l_creation_date,
2774: fnd_global.user_id l_created_by,
2775: SYSDATE l_last_update_date,
2776: fnd_global.user_id l_last_updated_by,
2777: fnd_global.conc_login_id l_last_update_login,
2778: fnd_global.conc_request_id l_request_id
2779: FROM zx_taxes_b tax
2780: WHERE tax.tax_regime_code like '%-SALES-TAX-%'
2773: SYSDATE l_creation_date,
2774: fnd_global.user_id l_created_by,
2775: SYSDATE l_last_update_date,
2776: fnd_global.user_id l_last_updated_by,
2777: fnd_global.conc_login_id l_last_update_login,
2778: fnd_global.conc_request_id l_request_id
2779: FROM zx_taxes_b tax
2780: WHERE tax.tax_regime_code like '%-SALES-TAX-%'
2781: AND NOT EXISTS (SELECT 1
2774: fnd_global.user_id l_created_by,
2775: SYSDATE l_last_update_date,
2776: fnd_global.user_id l_last_updated_by,
2777: fnd_global.conc_login_id l_last_update_login,
2778: fnd_global.conc_request_id l_request_id
2779: FROM zx_taxes_b tax
2780: WHERE tax.tax_regime_code like '%-SALES-TAX-%'
2781: AND NOT EXISTS (SELECT 1
2782: FROM zx_status_b status
2896: 'STANDARD_TB' , --taxable_basis_formula_code
2897: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
2898: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
2899: 'MIGRATED' , --record_type_code
2900: fnd_global.user_id , --created_by
2901: SYSDATE , --creation_date
2902: fnd_global.user_id , --last_updated_by
2903: SYSDATE , --last_update_date
2904: fnd_global.user_id , --last_update_login
2898: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
2899: 'MIGRATED' , --record_type_code
2900: fnd_global.user_id , --created_by
2901: SYSDATE , --creation_date
2902: fnd_global.user_id , --last_updated_by
2903: SYSDATE , --last_update_date
2904: fnd_global.user_id , --last_update_login
2905: fnd_global.conc_request_id , --request_id
2906: fnd_global.prog_appl_id , --program_application_id
2900: fnd_global.user_id , --created_by
2901: SYSDATE , --creation_date
2902: fnd_global.user_id , --last_updated_by
2903: SYSDATE , --last_update_date
2904: fnd_global.user_id , --last_update_login
2905: fnd_global.conc_request_id , --request_id
2906: fnd_global.prog_appl_id , --program_application_id
2907: fnd_global.conc_program_id , --program_id
2908: fnd_global.conc_login_id , --program_login_id
2901: SYSDATE , --creation_date
2902: fnd_global.user_id , --last_updated_by
2903: SYSDATE , --last_update_date
2904: fnd_global.user_id , --last_update_login
2905: fnd_global.conc_request_id , --request_id
2906: fnd_global.prog_appl_id , --program_application_id
2907: fnd_global.conc_program_id , --program_id
2908: fnd_global.conc_login_id , --program_login_id
2909: L_ATTRIBUTE1 ,
2902: fnd_global.user_id , --last_updated_by
2903: SYSDATE , --last_update_date
2904: fnd_global.user_id , --last_update_login
2905: fnd_global.conc_request_id , --request_id
2906: fnd_global.prog_appl_id , --program_application_id
2907: fnd_global.conc_program_id , --program_id
2908: fnd_global.conc_login_id , --program_login_id
2909: L_ATTRIBUTE1 ,
2910: L_ATTRIBUTE2 ,
2903: SYSDATE , --last_update_date
2904: fnd_global.user_id , --last_update_login
2905: fnd_global.conc_request_id , --request_id
2906: fnd_global.prog_appl_id , --program_application_id
2907: fnd_global.conc_program_id , --program_id
2908: fnd_global.conc_login_id , --program_login_id
2909: L_ATTRIBUTE1 ,
2910: L_ATTRIBUTE2 ,
2911: L_ATTRIBUTE3 ,
2904: fnd_global.user_id , --last_update_login
2905: fnd_global.conc_request_id , --request_id
2906: fnd_global.prog_appl_id , --program_application_id
2907: fnd_global.conc_program_id , --program_id
2908: fnd_global.conc_login_id , --program_login_id
2909: L_ATTRIBUTE1 ,
2910: L_ATTRIBUTE2 ,
2911: L_ATTRIBUTE3 ,
2912: L_ATTRIBUTE4 ,
3083: codes.FINCHRG_NON_REC_TAX_CCID L_FINCHRG_NON_REC_TAX_CCID,
3084: NULL L_NON_REC_ACCOUNT_CCID,
3085: 'TAX_RATE' L_ADJ_FOR_ADHOC_AMT_CODE,
3086: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
3087: fnd_global.user_id L_CREATED_BY,
3088: SYSDATE L_CREATION_DATE,
3089: fnd_global.user_id L_LAST_UPDATED_BY,
3090: SYSDATE L_LAST_UPDATE_DATE,
3091: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3085: 'TAX_RATE' L_ADJ_FOR_ADHOC_AMT_CODE,
3086: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
3087: fnd_global.user_id L_CREATED_BY,
3088: SYSDATE L_CREATION_DATE,
3089: fnd_global.user_id L_LAST_UPDATED_BY,
3090: SYSDATE L_LAST_UPDATE_DATE,
3091: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3092: fnd_global.conc_request_id L_REQUEST_ID,
3093: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3087: fnd_global.user_id L_CREATED_BY,
3088: SYSDATE L_CREATION_DATE,
3089: fnd_global.user_id L_LAST_UPDATED_BY,
3090: SYSDATE L_LAST_UPDATE_DATE,
3091: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3092: fnd_global.conc_request_id L_REQUEST_ID,
3093: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3094: fnd_global.conc_program_id L_PROGRAM_ID,
3095: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3088: SYSDATE L_CREATION_DATE,
3089: fnd_global.user_id L_LAST_UPDATED_BY,
3090: SYSDATE L_LAST_UPDATE_DATE,
3091: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3092: fnd_global.conc_request_id L_REQUEST_ID,
3093: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3094: fnd_global.conc_program_id L_PROGRAM_ID,
3095: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3096: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3089: fnd_global.user_id L_LAST_UPDATED_BY,
3090: SYSDATE L_LAST_UPDATE_DATE,
3091: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3092: fnd_global.conc_request_id L_REQUEST_ID,
3093: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3094: fnd_global.conc_program_id L_PROGRAM_ID,
3095: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3096: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3097: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3090: SYSDATE L_LAST_UPDATE_DATE,
3091: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3092: fnd_global.conc_request_id L_REQUEST_ID,
3093: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3094: fnd_global.conc_program_id L_PROGRAM_ID,
3095: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3096: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3097: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3098: FROM
3091: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3092: fnd_global.conc_request_id L_REQUEST_ID,
3093: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3094: fnd_global.conc_program_id L_PROGRAM_ID,
3095: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3096: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3097: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3098: FROM
3099: zx_status_b status,
3231: 'STANDARD_TB' , --taxable_basis_formula_code
3232: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
3233: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
3234: 'MIGRATED' , --record_type_code
3235: fnd_global.user_id , --created_by
3236: SYSDATE , --creation_date
3237: fnd_global.user_id , --last_updated_by
3238: SYSDATE , --last_update_date
3239: fnd_global.user_id , --last_update_login
3233: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
3234: 'MIGRATED' , --record_type_code
3235: fnd_global.user_id , --created_by
3236: SYSDATE , --creation_date
3237: fnd_global.user_id , --last_updated_by
3238: SYSDATE , --last_update_date
3239: fnd_global.user_id , --last_update_login
3240: fnd_global.conc_request_id , --request_id
3241: fnd_global.prog_appl_id , --program_application_id
3235: fnd_global.user_id , --created_by
3236: SYSDATE , --creation_date
3237: fnd_global.user_id , --last_updated_by
3238: SYSDATE , --last_update_date
3239: fnd_global.user_id , --last_update_login
3240: fnd_global.conc_request_id , --request_id
3241: fnd_global.prog_appl_id , --program_application_id
3242: fnd_global.conc_program_id , --program_id
3243: fnd_global.conc_login_id , --program_login_id
3236: SYSDATE , --creation_date
3237: fnd_global.user_id , --last_updated_by
3238: SYSDATE , --last_update_date
3239: fnd_global.user_id , --last_update_login
3240: fnd_global.conc_request_id , --request_id
3241: fnd_global.prog_appl_id , --program_application_id
3242: fnd_global.conc_program_id , --program_id
3243: fnd_global.conc_login_id , --program_login_id
3244: L_ATTRIBUTE1 ,
3237: fnd_global.user_id , --last_updated_by
3238: SYSDATE , --last_update_date
3239: fnd_global.user_id , --last_update_login
3240: fnd_global.conc_request_id , --request_id
3241: fnd_global.prog_appl_id , --program_application_id
3242: fnd_global.conc_program_id , --program_id
3243: fnd_global.conc_login_id , --program_login_id
3244: L_ATTRIBUTE1 ,
3245: L_ATTRIBUTE2 ,
3238: SYSDATE , --last_update_date
3239: fnd_global.user_id , --last_update_login
3240: fnd_global.conc_request_id , --request_id
3241: fnd_global.prog_appl_id , --program_application_id
3242: fnd_global.conc_program_id , --program_id
3243: fnd_global.conc_login_id , --program_login_id
3244: L_ATTRIBUTE1 ,
3245: L_ATTRIBUTE2 ,
3246: L_ATTRIBUTE3 ,
3239: fnd_global.user_id , --last_update_login
3240: fnd_global.conc_request_id , --request_id
3241: fnd_global.prog_appl_id , --program_application_id
3242: fnd_global.conc_program_id , --program_id
3243: fnd_global.conc_login_id , --program_login_id
3244: L_ATTRIBUTE1 ,
3245: L_ATTRIBUTE2 ,
3246: L_ATTRIBUTE3 ,
3247: L_ATTRIBUTE4 ,
3418: codes.FINCHRG_NON_REC_TAX_CCID L_FINCHRG_NON_REC_TAX_CCID,
3419: NULL L_NON_REC_ACCOUNT_CCID,
3420: 'TAX_RATE' L_ADJ_FOR_ADHOC_AMT_CODE,
3421: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
3422: fnd_global.user_id L_CREATED_BY,
3423: SYSDATE L_CREATION_DATE,
3424: fnd_global.user_id L_LAST_UPDATED_BY,
3425: SYSDATE L_LAST_UPDATE_DATE,
3426: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3420: 'TAX_RATE' L_ADJ_FOR_ADHOC_AMT_CODE,
3421: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
3422: fnd_global.user_id L_CREATED_BY,
3423: SYSDATE L_CREATION_DATE,
3424: fnd_global.user_id L_LAST_UPDATED_BY,
3425: SYSDATE L_LAST_UPDATE_DATE,
3426: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3427: fnd_global.conc_request_id L_REQUEST_ID,
3428: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3422: fnd_global.user_id L_CREATED_BY,
3423: SYSDATE L_CREATION_DATE,
3424: fnd_global.user_id L_LAST_UPDATED_BY,
3425: SYSDATE L_LAST_UPDATE_DATE,
3426: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3427: fnd_global.conc_request_id L_REQUEST_ID,
3428: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3429: fnd_global.conc_program_id L_PROGRAM_ID,
3430: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3423: SYSDATE L_CREATION_DATE,
3424: fnd_global.user_id L_LAST_UPDATED_BY,
3425: SYSDATE L_LAST_UPDATE_DATE,
3426: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3427: fnd_global.conc_request_id L_REQUEST_ID,
3428: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3429: fnd_global.conc_program_id L_PROGRAM_ID,
3430: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3431: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3424: fnd_global.user_id L_LAST_UPDATED_BY,
3425: SYSDATE L_LAST_UPDATE_DATE,
3426: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3427: fnd_global.conc_request_id L_REQUEST_ID,
3428: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3429: fnd_global.conc_program_id L_PROGRAM_ID,
3430: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3431: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3432: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3425: SYSDATE L_LAST_UPDATE_DATE,
3426: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3427: fnd_global.conc_request_id L_REQUEST_ID,
3428: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3429: fnd_global.conc_program_id L_PROGRAM_ID,
3430: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3431: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3432: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3433: FROM
3426: fnd_global.user_id L_LAST_UPDATE_LOGIN,
3427: fnd_global.conc_request_id L_REQUEST_ID,
3428: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
3429: fnd_global.conc_program_id L_PROGRAM_ID,
3430: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
3431: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
3432: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3433: FROM
3434: zx_status_b status,
4063: NULL l_attribute14,
4064: NULL l_attribute15,
4065: NULL l_attribute_category,
4066: SYSDATE l_creation_date,
4067: fnd_global.user_id l_created_by,
4068: SYSDATE l_last_update_date,
4069: fnd_global.user_id l_last_updated_by,
4070: fnd_global.conc_login_id l_last_update_login,
4071: fnd_global.conc_request_id l_request_id
4065: NULL l_attribute_category,
4066: SYSDATE l_creation_date,
4067: fnd_global.user_id l_created_by,
4068: SYSDATE l_last_update_date,
4069: fnd_global.user_id l_last_updated_by,
4070: fnd_global.conc_login_id l_last_update_login,
4071: fnd_global.conc_request_id l_request_id
4072: FROM zx_taxes_b ztb
4073: WHERE ztb.tax_regime_code LIKE 'US-SALES-TAX-%'
4066: SYSDATE l_creation_date,
4067: fnd_global.user_id l_created_by,
4068: SYSDATE l_last_update_date,
4069: fnd_global.user_id l_last_updated_by,
4070: fnd_global.conc_login_id l_last_update_login,
4071: fnd_global.conc_request_id l_request_id
4072: FROM zx_taxes_b ztb
4073: WHERE ztb.tax_regime_code LIKE 'US-SALES-TAX-%'
4074: AND NOT EXISTS (SELECT 1
4067: fnd_global.user_id l_created_by,
4068: SYSDATE l_last_update_date,
4069: fnd_global.user_id l_last_updated_by,
4070: fnd_global.conc_login_id l_last_update_login,
4071: fnd_global.conc_request_id l_request_id
4072: FROM zx_taxes_b ztb
4073: WHERE ztb.tax_regime_code LIKE 'US-SALES-TAX-%'
4074: AND NOT EXISTS (SELECT 1
4075: FROM zx_status_b zsb
4195: 'STANDARD_TB' , --taxable_basis_formula_code
4196: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
4197: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
4198: 'MIGRATED' , --record_type_code
4199: fnd_global.user_id , --created_by
4200: SYSDATE , --creation_date
4201: fnd_global.user_id , --last_updated_by
4202: SYSDATE , --last_update_date
4203: fnd_global.user_id , --last_update_login
4197: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
4198: 'MIGRATED' , --record_type_code
4199: fnd_global.user_id , --created_by
4200: SYSDATE , --creation_date
4201: fnd_global.user_id , --last_updated_by
4202: SYSDATE , --last_update_date
4203: fnd_global.user_id , --last_update_login
4204: fnd_global.conc_request_id , --request_id
4205: fnd_global.prog_appl_id , --program_application_id
4199: fnd_global.user_id , --created_by
4200: SYSDATE , --creation_date
4201: fnd_global.user_id , --last_updated_by
4202: SYSDATE , --last_update_date
4203: fnd_global.user_id , --last_update_login
4204: fnd_global.conc_request_id , --request_id
4205: fnd_global.prog_appl_id , --program_application_id
4206: fnd_global.conc_program_id , --program_id
4207: fnd_global.conc_login_id , --program_login_id
4200: SYSDATE , --creation_date
4201: fnd_global.user_id , --last_updated_by
4202: SYSDATE , --last_update_date
4203: fnd_global.user_id , --last_update_login
4204: fnd_global.conc_request_id , --request_id
4205: fnd_global.prog_appl_id , --program_application_id
4206: fnd_global.conc_program_id , --program_id
4207: fnd_global.conc_login_id , --program_login_id
4208: L_ATTRIBUTE1 ,
4201: fnd_global.user_id , --last_updated_by
4202: SYSDATE , --last_update_date
4203: fnd_global.user_id , --last_update_login
4204: fnd_global.conc_request_id , --request_id
4205: fnd_global.prog_appl_id , --program_application_id
4206: fnd_global.conc_program_id , --program_id
4207: fnd_global.conc_login_id , --program_login_id
4208: L_ATTRIBUTE1 ,
4209: L_ATTRIBUTE2 ,
4202: SYSDATE , --last_update_date
4203: fnd_global.user_id , --last_update_login
4204: fnd_global.conc_request_id , --request_id
4205: fnd_global.prog_appl_id , --program_application_id
4206: fnd_global.conc_program_id , --program_id
4207: fnd_global.conc_login_id , --program_login_id
4208: L_ATTRIBUTE1 ,
4209: L_ATTRIBUTE2 ,
4210: L_ATTRIBUTE3 ,
4203: fnd_global.user_id , --last_update_login
4204: fnd_global.conc_request_id , --request_id
4205: fnd_global.prog_appl_id , --program_application_id
4206: fnd_global.conc_program_id , --program_id
4207: fnd_global.conc_login_id , --program_login_id
4208: L_ATTRIBUTE1 ,
4209: L_ATTRIBUTE2 ,
4210: L_ATTRIBUTE3 ,
4211: L_ATTRIBUTE4 ,
4382: avt.FINCHRG_NON_REC_TAX_CCID L_FINCHRG_NON_REC_TAX_CCID,
4383: NULL L_NON_REC_ACCOUNT_CCID,
4384: 'TAX_RATE' L_ADJ_FOR_ADHOC_AMT_CODE,
4385: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
4386: fnd_global.user_id L_CREATED_BY,
4387: SYSDATE L_CREATION_DATE,
4388: fnd_global.user_id L_LAST_UPDATED_BY,
4389: SYSDATE L_LAST_UPDATE_DATE,
4390: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4384: 'TAX_RATE' L_ADJ_FOR_ADHOC_AMT_CODE,
4385: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
4386: fnd_global.user_id L_CREATED_BY,
4387: SYSDATE L_CREATION_DATE,
4388: fnd_global.user_id L_LAST_UPDATED_BY,
4389: SYSDATE L_LAST_UPDATE_DATE,
4390: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4391: fnd_global.conc_request_id L_REQUEST_ID,
4392: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4386: fnd_global.user_id L_CREATED_BY,
4387: SYSDATE L_CREATION_DATE,
4388: fnd_global.user_id L_LAST_UPDATED_BY,
4389: SYSDATE L_LAST_UPDATE_DATE,
4390: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4391: fnd_global.conc_request_id L_REQUEST_ID,
4392: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4393: fnd_global.conc_program_id L_PROGRAM_ID,
4394: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4387: SYSDATE L_CREATION_DATE,
4388: fnd_global.user_id L_LAST_UPDATED_BY,
4389: SYSDATE L_LAST_UPDATE_DATE,
4390: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4391: fnd_global.conc_request_id L_REQUEST_ID,
4392: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4393: fnd_global.conc_program_id L_PROGRAM_ID,
4394: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4395: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4388: fnd_global.user_id L_LAST_UPDATED_BY,
4389: SYSDATE L_LAST_UPDATE_DATE,
4390: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4391: fnd_global.conc_request_id L_REQUEST_ID,
4392: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4393: fnd_global.conc_program_id L_PROGRAM_ID,
4394: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4395: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4396: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4389: SYSDATE L_LAST_UPDATE_DATE,
4390: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4391: fnd_global.conc_request_id L_REQUEST_ID,
4392: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4393: fnd_global.conc_program_id L_PROGRAM_ID,
4394: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4395: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4396: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4397: FROM
4390: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4391: fnd_global.conc_request_id L_REQUEST_ID,
4392: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4393: fnd_global.conc_program_id L_PROGRAM_ID,
4394: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4395: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4396: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4397: FROM
4398: ar_vat_tax_all_b avt,
4527: 'STANDARD_TB' , --taxable_basis_formula_code
4528: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
4529: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
4530: 'MIGRATED' , --record_type_code
4531: fnd_global.user_id , --created_by
4532: SYSDATE , --creation_date
4533: fnd_global.user_id , --last_updated_by
4534: SYSDATE , --last_update_date
4535: fnd_global.user_id , --last_update_login
4529: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
4530: 'MIGRATED' , --record_type_code
4531: fnd_global.user_id , --created_by
4532: SYSDATE , --creation_date
4533: fnd_global.user_id , --last_updated_by
4534: SYSDATE , --last_update_date
4535: fnd_global.user_id , --last_update_login
4536: fnd_global.conc_request_id , --request_id
4537: fnd_global.prog_appl_id , --program_application_id
4531: fnd_global.user_id , --created_by
4532: SYSDATE , --creation_date
4533: fnd_global.user_id , --last_updated_by
4534: SYSDATE , --last_update_date
4535: fnd_global.user_id , --last_update_login
4536: fnd_global.conc_request_id , --request_id
4537: fnd_global.prog_appl_id , --program_application_id
4538: fnd_global.conc_program_id , --program_id
4539: fnd_global.conc_login_id , --program_login_id
4532: SYSDATE , --creation_date
4533: fnd_global.user_id , --last_updated_by
4534: SYSDATE , --last_update_date
4535: fnd_global.user_id , --last_update_login
4536: fnd_global.conc_request_id , --request_id
4537: fnd_global.prog_appl_id , --program_application_id
4538: fnd_global.conc_program_id , --program_id
4539: fnd_global.conc_login_id , --program_login_id
4540: L_ATTRIBUTE1 ,
4533: fnd_global.user_id , --last_updated_by
4534: SYSDATE , --last_update_date
4535: fnd_global.user_id , --last_update_login
4536: fnd_global.conc_request_id , --request_id
4537: fnd_global.prog_appl_id , --program_application_id
4538: fnd_global.conc_program_id , --program_id
4539: fnd_global.conc_login_id , --program_login_id
4540: L_ATTRIBUTE1 ,
4541: L_ATTRIBUTE2 ,
4534: SYSDATE , --last_update_date
4535: fnd_global.user_id , --last_update_login
4536: fnd_global.conc_request_id , --request_id
4537: fnd_global.prog_appl_id , --program_application_id
4538: fnd_global.conc_program_id , --program_id
4539: fnd_global.conc_login_id , --program_login_id
4540: L_ATTRIBUTE1 ,
4541: L_ATTRIBUTE2 ,
4542: L_ATTRIBUTE3 ,
4535: fnd_global.user_id , --last_update_login
4536: fnd_global.conc_request_id , --request_id
4537: fnd_global.prog_appl_id , --program_application_id
4538: fnd_global.conc_program_id , --program_id
4539: fnd_global.conc_login_id , --program_login_id
4540: L_ATTRIBUTE1 ,
4541: L_ATTRIBUTE2 ,
4542: L_ATTRIBUTE3 ,
4543: L_ATTRIBUTE4 ,
4714: avt.FINCHRG_NON_REC_TAX_CCID L_FINCHRG_NON_REC_TAX_CCID,
4715: NULL L_NON_REC_ACCOUNT_CCID,
4716: 'TAX_RATE' L_ADJ_FOR_ADHOC_AMT_CODE,
4717: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
4718: fnd_global.user_id L_CREATED_BY,
4719: SYSDATE L_CREATION_DATE,
4720: fnd_global.user_id L_LAST_UPDATED_BY,
4721: SYSDATE L_LAST_UPDATE_DATE,
4722: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4716: 'TAX_RATE' L_ADJ_FOR_ADHOC_AMT_CODE,
4717: 'Y' L_ALLOW_ADHOC_TAX_RATE_FLAG,
4718: fnd_global.user_id L_CREATED_BY,
4719: SYSDATE L_CREATION_DATE,
4720: fnd_global.user_id L_LAST_UPDATED_BY,
4721: SYSDATE L_LAST_UPDATE_DATE,
4722: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4723: fnd_global.conc_request_id L_REQUEST_ID,
4724: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4718: fnd_global.user_id L_CREATED_BY,
4719: SYSDATE L_CREATION_DATE,
4720: fnd_global.user_id L_LAST_UPDATED_BY,
4721: SYSDATE L_LAST_UPDATE_DATE,
4722: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4723: fnd_global.conc_request_id L_REQUEST_ID,
4724: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4725: fnd_global.conc_program_id L_PROGRAM_ID,
4726: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4719: SYSDATE L_CREATION_DATE,
4720: fnd_global.user_id L_LAST_UPDATED_BY,
4721: SYSDATE L_LAST_UPDATE_DATE,
4722: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4723: fnd_global.conc_request_id L_REQUEST_ID,
4724: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4725: fnd_global.conc_program_id L_PROGRAM_ID,
4726: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4727: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4720: fnd_global.user_id L_LAST_UPDATED_BY,
4721: SYSDATE L_LAST_UPDATE_DATE,
4722: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4723: fnd_global.conc_request_id L_REQUEST_ID,
4724: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4725: fnd_global.conc_program_id L_PROGRAM_ID,
4726: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4727: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4728: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4721: SYSDATE L_LAST_UPDATE_DATE,
4722: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4723: fnd_global.conc_request_id L_REQUEST_ID,
4724: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4725: fnd_global.conc_program_id L_PROGRAM_ID,
4726: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4727: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4728: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4729: FROM
4722: fnd_global.user_id L_LAST_UPDATE_LOGIN,
4723: fnd_global.conc_request_id L_REQUEST_ID,
4724: fnd_global.prog_appl_id L_PROGRAM_APPLICATION_ID,
4725: fnd_global.conc_program_id L_PROGRAM_ID,
4726: fnd_global.conc_login_id L_PROGRAM_LOGIN_ID,
4727: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4728: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4729: FROM
4730: ar_vat_tax_all_b avt,
5027: L_TAXABLE_BASIS_FORMULA , --taxable_basis_formula_code
5028: INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
5029: TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
5030: 'MIGRATED' , --record_type_code
5031: fnd_global.user_id , --created_by
5032: SYSDATE , --creation_date
5033: fnd_global.user_id , --last_updated_by
5034: SYSDATE , --last_update_date
5035: fnd_global.user_id , --last_update_login
5029: TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
5030: 'MIGRATED' , --record_type_code
5031: fnd_global.user_id , --created_by
5032: SYSDATE , --creation_date
5033: fnd_global.user_id , --last_updated_by
5034: SYSDATE , --last_update_date
5035: fnd_global.user_id , --last_update_login
5036: fnd_global.conc_request_id , --request_id
5037: fnd_global.prog_appl_id , --program_application_id
5031: fnd_global.user_id , --created_by
5032: SYSDATE , --creation_date
5033: fnd_global.user_id , --last_updated_by
5034: SYSDATE , --last_update_date
5035: fnd_global.user_id , --last_update_login
5036: fnd_global.conc_request_id , --request_id
5037: fnd_global.prog_appl_id , --program_application_id
5038: fnd_global.conc_program_id , --program_id
5039: fnd_global.conc_login_id , --program_login_id
5032: SYSDATE , --creation_date
5033: fnd_global.user_id , --last_updated_by
5034: SYSDATE , --last_update_date
5035: fnd_global.user_id , --last_update_login
5036: fnd_global.conc_request_id , --request_id
5037: fnd_global.prog_appl_id , --program_application_id
5038: fnd_global.conc_program_id , --program_id
5039: fnd_global.conc_login_id , --program_login_id
5040: ATTRIBUTE1 ,
5033: fnd_global.user_id , --last_updated_by
5034: SYSDATE , --last_update_date
5035: fnd_global.user_id , --last_update_login
5036: fnd_global.conc_request_id , --request_id
5037: fnd_global.prog_appl_id , --program_application_id
5038: fnd_global.conc_program_id , --program_id
5039: fnd_global.conc_login_id , --program_login_id
5040: ATTRIBUTE1 ,
5041: ATTRIBUTE2 ,
5034: SYSDATE , --last_update_date
5035: fnd_global.user_id , --last_update_login
5036: fnd_global.conc_request_id , --request_id
5037: fnd_global.prog_appl_id , --program_application_id
5038: fnd_global.conc_program_id , --program_id
5039: fnd_global.conc_login_id , --program_login_id
5040: ATTRIBUTE1 ,
5041: ATTRIBUTE2 ,
5042: ATTRIBUTE3 ,
5035: fnd_global.user_id , --last_update_login
5036: fnd_global.conc_request_id , --request_id
5037: fnd_global.prog_appl_id , --program_application_id
5038: fnd_global.conc_program_id , --program_id
5039: fnd_global.conc_login_id , --program_login_id
5040: ATTRIBUTE1 ,
5041: ATTRIBUTE2 ,
5042: ATTRIBUTE3 ,
5043: ATTRIBUTE4 ,
5139: NULL ,
5140: NULL ,
5141: NULL ,
5142: NULL ,
5143: fnd_global.user_id ,
5144: SYSDATE ,
5145: fnd_global.user_id ,
5146: SYSDATE ,
5147: fnd_global.conc_login_id ,
5141: NULL ,
5142: NULL ,
5143: fnd_global.user_id ,
5144: SYSDATE ,
5145: fnd_global.user_id ,
5146: SYSDATE ,
5147: fnd_global.conc_login_id ,
5148: fnd_global.conc_request_id , -- Request Id
5149: fnd_global.prog_appl_id , -- Program Application ID
5143: fnd_global.user_id ,
5144: SYSDATE ,
5145: fnd_global.user_id ,
5146: SYSDATE ,
5147: fnd_global.conc_login_id ,
5148: fnd_global.conc_request_id , -- Request Id
5149: fnd_global.prog_appl_id , -- Program Application ID
5150: fnd_global.conc_program_id , -- Program Id
5151: fnd_global.conc_login_id , -- Program Login ID
5144: SYSDATE ,
5145: fnd_global.user_id ,
5146: SYSDATE ,
5147: fnd_global.conc_login_id ,
5148: fnd_global.conc_request_id , -- Request Id
5149: fnd_global.prog_appl_id , -- Program Application ID
5150: fnd_global.conc_program_id , -- Program Id
5151: fnd_global.conc_login_id , -- Program Login ID
5152: 1
5145: fnd_global.user_id ,
5146: SYSDATE ,
5147: fnd_global.conc_login_id ,
5148: fnd_global.conc_request_id , -- Request Id
5149: fnd_global.prog_appl_id , -- Program Application ID
5150: fnd_global.conc_program_id , -- Program Id
5151: fnd_global.conc_login_id , -- Program Login ID
5152: 1
5153: )
5146: SYSDATE ,
5147: fnd_global.conc_login_id ,
5148: fnd_global.conc_request_id , -- Request Id
5149: fnd_global.prog_appl_id , -- Program Application ID
5150: fnd_global.conc_program_id , -- Program Id
5151: fnd_global.conc_login_id , -- Program Login ID
5152: 1
5153: )
5154: SELECT
5147: fnd_global.conc_login_id ,
5148: fnd_global.conc_request_id , -- Request Id
5149: fnd_global.prog_appl_id , -- Program Application ID
5150: fnd_global.conc_program_id , -- Program Id
5151: fnd_global.conc_login_id , -- Program Login ID
5152: 1
5153: )
5154: SELECT
5155: results.tax_code_id TAX_RATE_ID,
5382: L_TAXABLE_BASIS_FORMULA , --taxable_basis_formula_code
5383: INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
5384: TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
5385: 'MIGRATED' , --record_type_code
5386: fnd_global.user_id , --created_by
5387: SYSDATE , --creation_date
5388: fnd_global.user_id , --last_updated_by
5389: SYSDATE , --last_update_date
5390: fnd_global.user_id , --last_update_login
5384: TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
5385: 'MIGRATED' , --record_type_code
5386: fnd_global.user_id , --created_by
5387: SYSDATE , --creation_date
5388: fnd_global.user_id , --last_updated_by
5389: SYSDATE , --last_update_date
5390: fnd_global.user_id , --last_update_login
5391: fnd_global.conc_request_id , --request_id
5392: fnd_global.prog_appl_id , --program_application_id
5386: fnd_global.user_id , --created_by
5387: SYSDATE , --creation_date
5388: fnd_global.user_id , --last_updated_by
5389: SYSDATE , --last_update_date
5390: fnd_global.user_id , --last_update_login
5391: fnd_global.conc_request_id , --request_id
5392: fnd_global.prog_appl_id , --program_application_id
5393: fnd_global.conc_program_id , --program_id
5394: fnd_global.conc_login_id , --program_login_id
5387: SYSDATE , --creation_date
5388: fnd_global.user_id , --last_updated_by
5389: SYSDATE , --last_update_date
5390: fnd_global.user_id , --last_update_login
5391: fnd_global.conc_request_id , --request_id
5392: fnd_global.prog_appl_id , --program_application_id
5393: fnd_global.conc_program_id , --program_id
5394: fnd_global.conc_login_id , --program_login_id
5395: ATTRIBUTE1 ,
5388: fnd_global.user_id , --last_updated_by
5389: SYSDATE , --last_update_date
5390: fnd_global.user_id , --last_update_login
5391: fnd_global.conc_request_id , --request_id
5392: fnd_global.prog_appl_id , --program_application_id
5393: fnd_global.conc_program_id , --program_id
5394: fnd_global.conc_login_id , --program_login_id
5395: ATTRIBUTE1 ,
5396: ATTRIBUTE2 ,
5389: SYSDATE , --last_update_date
5390: fnd_global.user_id , --last_update_login
5391: fnd_global.conc_request_id , --request_id
5392: fnd_global.prog_appl_id , --program_application_id
5393: fnd_global.conc_program_id , --program_id
5394: fnd_global.conc_login_id , --program_login_id
5395: ATTRIBUTE1 ,
5396: ATTRIBUTE2 ,
5397: ATTRIBUTE3 ,
5390: fnd_global.user_id , --last_update_login
5391: fnd_global.conc_request_id , --request_id
5392: fnd_global.prog_appl_id , --program_application_id
5393: fnd_global.conc_program_id , --program_id
5394: fnd_global.conc_login_id , --program_login_id
5395: ATTRIBUTE1 ,
5396: ATTRIBUTE2 ,
5397: ATTRIBUTE3 ,
5398: ATTRIBUTE4 ,
5494: NULL ,
5495: NULL ,
5496: NULL ,
5497: NULL ,
5498: fnd_global.user_id ,
5499: SYSDATE ,
5500: fnd_global.user_id ,
5501: SYSDATE ,
5502: fnd_global.conc_login_id ,
5496: NULL ,
5497: NULL ,
5498: fnd_global.user_id ,
5499: SYSDATE ,
5500: fnd_global.user_id ,
5501: SYSDATE ,
5502: fnd_global.conc_login_id ,
5503: fnd_global.conc_request_id , -- Request Id
5504: fnd_global.prog_appl_id , -- Program Application ID
5498: fnd_global.user_id ,
5499: SYSDATE ,
5500: fnd_global.user_id ,
5501: SYSDATE ,
5502: fnd_global.conc_login_id ,
5503: fnd_global.conc_request_id , -- Request Id
5504: fnd_global.prog_appl_id , -- Program Application ID
5505: fnd_global.conc_program_id , -- Program Id
5506: fnd_global.conc_login_id , -- Program Login ID
5499: SYSDATE ,
5500: fnd_global.user_id ,
5501: SYSDATE ,
5502: fnd_global.conc_login_id ,
5503: fnd_global.conc_request_id , -- Request Id
5504: fnd_global.prog_appl_id , -- Program Application ID
5505: fnd_global.conc_program_id , -- Program Id
5506: fnd_global.conc_login_id , -- Program Login ID
5507: 1
5500: fnd_global.user_id ,
5501: SYSDATE ,
5502: fnd_global.conc_login_id ,
5503: fnd_global.conc_request_id , -- Request Id
5504: fnd_global.prog_appl_id , -- Program Application ID
5505: fnd_global.conc_program_id , -- Program Id
5506: fnd_global.conc_login_id , -- Program Login ID
5507: 1
5508: )
5501: SYSDATE ,
5502: fnd_global.conc_login_id ,
5503: fnd_global.conc_request_id , -- Request Id
5504: fnd_global.prog_appl_id , -- Program Application ID
5505: fnd_global.conc_program_id , -- Program Id
5506: fnd_global.conc_login_id , -- Program Login ID
5507: 1
5508: )
5509: SELECT
5502: fnd_global.conc_login_id ,
5503: fnd_global.conc_request_id , -- Request Id
5504: fnd_global.prog_appl_id , -- Program Application ID
5505: fnd_global.conc_program_id , -- Program Id
5506: fnd_global.conc_login_id , -- Program Login ID
5507: 1
5508: )
5509: SELECT
5510: results.tax_code_id TAX_RATE_ID,
5743: L_TAXABLE_BASIS_FORMULA , --taxable_basis_formula_code
5744: INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
5745: TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
5746: 'MIGRATED' , --record_type_code
5747: fnd_global.user_id , --created_by
5748: SYSDATE , --creation_date
5749: fnd_global.user_id , --last_updated_by
5750: SYSDATE , --last_update_date
5751: fnd_global.user_id , --last_update_login
5745: TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
5746: 'MIGRATED' , --record_type_code
5747: fnd_global.user_id , --created_by
5748: SYSDATE , --creation_date
5749: fnd_global.user_id , --last_updated_by
5750: SYSDATE , --last_update_date
5751: fnd_global.user_id , --last_update_login
5752: fnd_global.conc_request_id , --request_id
5753: fnd_global.prog_appl_id , --program_application_id
5747: fnd_global.user_id , --created_by
5748: SYSDATE , --creation_date
5749: fnd_global.user_id , --last_updated_by
5750: SYSDATE , --last_update_date
5751: fnd_global.user_id , --last_update_login
5752: fnd_global.conc_request_id , --request_id
5753: fnd_global.prog_appl_id , --program_application_id
5754: fnd_global.conc_program_id , --program_id
5755: fnd_global.conc_login_id , --program_login_id
5748: SYSDATE , --creation_date
5749: fnd_global.user_id , --last_updated_by
5750: SYSDATE , --last_update_date
5751: fnd_global.user_id , --last_update_login
5752: fnd_global.conc_request_id , --request_id
5753: fnd_global.prog_appl_id , --program_application_id
5754: fnd_global.conc_program_id , --program_id
5755: fnd_global.conc_login_id , --program_login_id
5756: ATTRIBUTE1 ,
5749: fnd_global.user_id , --last_updated_by
5750: SYSDATE , --last_update_date
5751: fnd_global.user_id , --last_update_login
5752: fnd_global.conc_request_id , --request_id
5753: fnd_global.prog_appl_id , --program_application_id
5754: fnd_global.conc_program_id , --program_id
5755: fnd_global.conc_login_id , --program_login_id
5756: ATTRIBUTE1 ,
5757: ATTRIBUTE2 ,
5750: SYSDATE , --last_update_date
5751: fnd_global.user_id , --last_update_login
5752: fnd_global.conc_request_id , --request_id
5753: fnd_global.prog_appl_id , --program_application_id
5754: fnd_global.conc_program_id , --program_id
5755: fnd_global.conc_login_id , --program_login_id
5756: ATTRIBUTE1 ,
5757: ATTRIBUTE2 ,
5758: ATTRIBUTE3 ,
5751: fnd_global.user_id , --last_update_login
5752: fnd_global.conc_request_id , --request_id
5753: fnd_global.prog_appl_id , --program_application_id
5754: fnd_global.conc_program_id , --program_id
5755: fnd_global.conc_login_id , --program_login_id
5756: ATTRIBUTE1 ,
5757: ATTRIBUTE2 ,
5758: ATTRIBUTE3 ,
5759: ATTRIBUTE4 ,
5854: NULL ,
5855: NULL ,
5856: NULL ,
5857: NULL ,
5858: fnd_global.user_id ,
5859: SYSDATE ,
5860: fnd_global.user_id ,
5861: SYSDATE ,
5862: fnd_global.conc_login_id ,
5856: NULL ,
5857: NULL ,
5858: fnd_global.user_id ,
5859: SYSDATE ,
5860: fnd_global.user_id ,
5861: SYSDATE ,
5862: fnd_global.conc_login_id ,
5863: fnd_global.conc_request_id , -- Request Id
5864: fnd_global.prog_appl_id , -- Program Application ID
5858: fnd_global.user_id ,
5859: SYSDATE ,
5860: fnd_global.user_id ,
5861: SYSDATE ,
5862: fnd_global.conc_login_id ,
5863: fnd_global.conc_request_id , -- Request Id
5864: fnd_global.prog_appl_id , -- Program Application ID
5865: fnd_global.conc_program_id , -- Program Id
5866: fnd_global.conc_login_id , -- Program Login ID
5859: SYSDATE ,
5860: fnd_global.user_id ,
5861: SYSDATE ,
5862: fnd_global.conc_login_id ,
5863: fnd_global.conc_request_id , -- Request Id
5864: fnd_global.prog_appl_id , -- Program Application ID
5865: fnd_global.conc_program_id , -- Program Id
5866: fnd_global.conc_login_id , -- Program Login ID
5867: 1
5860: fnd_global.user_id ,
5861: SYSDATE ,
5862: fnd_global.conc_login_id ,
5863: fnd_global.conc_request_id , -- Request Id
5864: fnd_global.prog_appl_id , -- Program Application ID
5865: fnd_global.conc_program_id , -- Program Id
5866: fnd_global.conc_login_id , -- Program Login ID
5867: 1
5868: )
5861: SYSDATE ,
5862: fnd_global.conc_login_id ,
5863: fnd_global.conc_request_id , -- Request Id
5864: fnd_global.prog_appl_id , -- Program Application ID
5865: fnd_global.conc_program_id , -- Program Id
5866: fnd_global.conc_login_id , -- Program Login ID
5867: 1
5868: )
5869: SELECT
5862: fnd_global.conc_login_id ,
5863: fnd_global.conc_request_id , -- Request Id
5864: fnd_global.prog_appl_id , -- Program Application ID
5865: fnd_global.conc_program_id , -- Program Id
5866: fnd_global.conc_login_id , -- Program Login ID
5867: 1
5868: )
5869: SELECT
5870: distinct
5995: SOURCE_LANG
5996: )
5997: SELECT avtt.vat_tax_id,
5998: avtt.printed_tax_name,
5999: fnd_global.user_id ,
6000: SYSDATE ,
6001: fnd_global.user_id ,
6002: SYSDATE ,
6003: fnd_global.conc_login_id ,
5997: SELECT avtt.vat_tax_id,
5998: avtt.printed_tax_name,
5999: fnd_global.user_id ,
6000: SYSDATE ,
6001: fnd_global.user_id ,
6002: SYSDATE ,
6003: fnd_global.conc_login_id ,
6004: avtt.language ,
6005: avtt.source_lang
5999: fnd_global.user_id ,
6000: SYSDATE ,
6001: fnd_global.user_id ,
6002: SYSDATE ,
6003: fnd_global.conc_login_id ,
6004: avtt.language ,
6005: avtt.source_lang
6006:
6007: FROM ar_vat_tax_all_tl avtt,
6496: NULL , -- COLL_TAX_AUTHORITY_ID
6497: NULL , -- THRSHLD_CHK_TMPLT_CODE
6498: NULL , -- DEF_PRIMARY_REC_RATE_CODE
6499: NULL , -- DEF_SECONDARY_REC_RATE_CODE
6500: fnd_global.user_id , -- CREATED_BY
6501: SYSDATE , -- CREATION_DATE
6502: fnd_global.user_id , -- LAST_UPDATED_BY
6503: SYSDATE , -- LAST_UPDATE_DATE
6504: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
6498: NULL , -- DEF_PRIMARY_REC_RATE_CODE
6499: NULL , -- DEF_SECONDARY_REC_RATE_CODE
6500: fnd_global.user_id , -- CREATED_BY
6501: SYSDATE , -- CREATION_DATE
6502: fnd_global.user_id , -- LAST_UPDATED_BY
6503: SYSDATE , -- LAST_UPDATE_DATE
6504: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
6505: fnd_global.conc_request_id , -- REQUEST_ID
6506: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
6500: fnd_global.user_id , -- CREATED_BY
6501: SYSDATE , -- CREATION_DATE
6502: fnd_global.user_id , -- LAST_UPDATED_BY
6503: SYSDATE , -- LAST_UPDATE_DATE
6504: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
6505: fnd_global.conc_request_id , -- REQUEST_ID
6506: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
6507: fnd_global.conc_program_id , -- PROGRAM_ID
6508: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
6501: SYSDATE , -- CREATION_DATE
6502: fnd_global.user_id , -- LAST_UPDATED_BY
6503: SYSDATE , -- LAST_UPDATE_DATE
6504: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
6505: fnd_global.conc_request_id , -- REQUEST_ID
6506: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
6507: fnd_global.conc_program_id , -- PROGRAM_ID
6508: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
6509: CASE WHEN p_country_code = 'US' AND p_seg_att_type IN ('STATE', 'COUNTY')
6502: fnd_global.user_id , -- LAST_UPDATED_BY
6503: SYSDATE , -- LAST_UPDATE_DATE
6504: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
6505: fnd_global.conc_request_id , -- REQUEST_ID
6506: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
6507: fnd_global.conc_program_id , -- PROGRAM_ID
6508: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
6509: CASE WHEN p_country_code = 'US' AND p_seg_att_type IN ('STATE', 'COUNTY')
6510: THEN
6503: SYSDATE , -- LAST_UPDATE_DATE
6504: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
6505: fnd_global.conc_request_id , -- REQUEST_ID
6506: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
6507: fnd_global.conc_program_id , -- PROGRAM_ID
6508: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
6509: CASE WHEN p_country_code = 'US' AND p_seg_att_type IN ('STATE', 'COUNTY')
6510: THEN
6511: substrb('US' || '_'|| 'OVERRIDE_ZONE_TYPE_' ||
6504: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
6505: fnd_global.conc_request_id , -- REQUEST_ID
6506: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
6507: fnd_global.conc_program_id , -- PROGRAM_ID
6508: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
6509: CASE WHEN p_country_code = 'US' AND p_seg_att_type IN ('STATE', 'COUNTY')
6510: THEN
6511: substrb('US' || '_'|| 'OVERRIDE_ZONE_TYPE_' ||
6512: substrb(to_char(p_loc_str_id), 1, 6),1,30)
6546: userenv('LANG'),
6547: userenv('LANG'),
6548: p_seg_att_type,
6549: SYSDATE,
6550: fnd_global.user_id,
6551: SYSDATE,
6552: fnd_global.user_id,
6553: fnd_global.conc_login_id,
6554: ZX_TAXES_B_S.NEXTVAL
6548: p_seg_att_type,
6549: SYSDATE,
6550: fnd_global.user_id,
6551: SYSDATE,
6552: fnd_global.user_id,
6553: fnd_global.conc_login_id,
6554: ZX_TAXES_B_S.NEXTVAL
6555: )*/
6556: SELECT 1 FROM DUAL;
6549: SYSDATE,
6550: fnd_global.user_id,
6551: SYSDATE,
6552: fnd_global.user_id,
6553: fnd_global.conc_login_id,
6554: ZX_TAXES_B_S.NEXTVAL
6555: )*/
6556: SELECT 1 FROM DUAL;
6557:
6672: NULL,
6673: NULL,
6674: NULL,
6675: SYSDATE,
6676: fnd_global.user_id,
6677: SYSDATE,
6678: fnd_global.user_id,
6679: fnd_global.conc_login_id,
6680: fnd_global.conc_request_id ,-- Request Id
6674: NULL,
6675: SYSDATE,
6676: fnd_global.user_id,
6677: SYSDATE,
6678: fnd_global.user_id,
6679: fnd_global.conc_login_id,
6680: fnd_global.conc_request_id ,-- Request Id
6681: 1
6682: FROM
6675: SYSDATE,
6676: fnd_global.user_id,
6677: SYSDATE,
6678: fnd_global.user_id,
6679: fnd_global.conc_login_id,
6680: fnd_global.conc_request_id ,-- Request Id
6681: 1
6682: FROM
6683: (SELECT RATES.TAX_REGIME_CODE tax_regime_code,
6676: fnd_global.user_id,
6677: SYSDATE,
6678: fnd_global.user_id,
6679: fnd_global.conc_login_id,
6680: fnd_global.conc_request_id ,-- Request Id
6681: 1
6682: FROM
6683: (SELECT RATES.TAX_REGIME_CODE tax_regime_code,
6684: RATES.CONTENT_OWNER_ID content_owner_id,
6798: NULL,
6799: NULL,
6800: NULL,
6801: SYSDATE,
6802: fnd_global.user_id,
6803: SYSDATE,
6804: fnd_global.user_id,
6805: fnd_global.conc_login_id,
6806: fnd_global.conc_request_id ,-- Request Id
6800: NULL,
6801: SYSDATE,
6802: fnd_global.user_id,
6803: SYSDATE,
6804: fnd_global.user_id,
6805: fnd_global.conc_login_id,
6806: fnd_global.conc_request_id ,-- Request Id
6807: 1
6808: FROM
6801: SYSDATE,
6802: fnd_global.user_id,
6803: SYSDATE,
6804: fnd_global.user_id,
6805: fnd_global.conc_login_id,
6806: fnd_global.conc_request_id ,-- Request Id
6807: 1
6808: FROM
6809: (SELECT RATES.TAX_REGIME_CODE tax_regime_code,
6802: fnd_global.user_id,
6803: SYSDATE,
6804: fnd_global.user_id,
6805: fnd_global.conc_login_id,
6806: fnd_global.conc_request_id ,-- Request Id
6807: 1
6808: FROM
6809: (SELECT RATES.TAX_REGIME_CODE tax_regime_code,
6810: RATES.CONTENT_OWNER_ID content_owner_id,
6933: NULL,
6934: NULL,
6935: NULL,
6936: SYSDATE,
6937: fnd_global.user_id,
6938: SYSDATE,
6939: fnd_global.user_id,
6940: fnd_global.conc_login_id,
6941: fnd_global.conc_request_id ,-- Request Id
6935: NULL,
6936: SYSDATE,
6937: fnd_global.user_id,
6938: SYSDATE,
6939: fnd_global.user_id,
6940: fnd_global.conc_login_id,
6941: fnd_global.conc_request_id ,-- Request Id
6942: 1
6943: FROM
6936: SYSDATE,
6937: fnd_global.user_id,
6938: SYSDATE,
6939: fnd_global.user_id,
6940: fnd_global.conc_login_id,
6941: fnd_global.conc_request_id ,-- Request Id
6942: 1
6943: FROM
6944: (SELECT RATES.TAX_REGIME_CODE tax_regime_code,
6937: fnd_global.user_id,
6938: SYSDATE,
6939: fnd_global.user_id,
6940: fnd_global.conc_login_id,
6941: fnd_global.conc_request_id ,-- Request Id
6942: 1
6943: FROM
6944: (SELECT RATES.TAX_REGIME_CODE tax_regime_code,
6945: RATES.CONTENT_OWNER_ID content_owner_id,
7074: NULL,
7075: NULL,
7076: NULL,
7077: SYSDATE,
7078: fnd_global.user_id,
7079: SYSDATE,
7080: fnd_global.user_id,
7081: fnd_global.conc_login_id,
7082: fnd_global.conc_request_id ,-- Request Id
7076: NULL,
7077: SYSDATE,
7078: fnd_global.user_id,
7079: SYSDATE,
7080: fnd_global.user_id,
7081: fnd_global.conc_login_id,
7082: fnd_global.conc_request_id ,-- Request Id
7083: 1
7084: FROM
7077: SYSDATE,
7078: fnd_global.user_id,
7079: SYSDATE,
7080: fnd_global.user_id,
7081: fnd_global.conc_login_id,
7082: fnd_global.conc_request_id ,-- Request Id
7083: 1
7084: FROM
7085: (SELECT rates.tax_regime_code TAX_REGIME_CODE,
7078: fnd_global.user_id,
7079: SYSDATE,
7080: fnd_global.user_id,
7081: fnd_global.conc_login_id,
7082: fnd_global.conc_request_id ,-- Request Id
7083: 1
7084: FROM
7085: (SELECT rates.tax_regime_code TAX_REGIME_CODE,
7086: rates.content_owner_id CONTENT_OWNER_ID,
7224: NULL,
7225: NULL,
7226: NULL,
7227: SYSDATE,
7228: fnd_global.user_id,
7229: SYSDATE,
7230: fnd_global.user_id,
7231: fnd_global.conc_login_id,
7232: fnd_global.conc_request_id ,-- Request Id
7226: NULL,
7227: SYSDATE,
7228: fnd_global.user_id,
7229: SYSDATE,
7230: fnd_global.user_id,
7231: fnd_global.conc_login_id,
7232: fnd_global.conc_request_id ,-- Request Id
7233: 1
7234: FROM
7227: SYSDATE,
7228: fnd_global.user_id,
7229: SYSDATE,
7230: fnd_global.user_id,
7231: fnd_global.conc_login_id,
7232: fnd_global.conc_request_id ,-- Request Id
7233: 1
7234: FROM
7235: (SELECT rates.tax_regime_code TAX_REGIME_CODE,
7228: fnd_global.user_id,
7229: SYSDATE,
7230: fnd_global.user_id,
7231: fnd_global.conc_login_id,
7232: fnd_global.conc_request_id ,-- Request Id
7233: 1
7234: FROM
7235: (SELECT rates.tax_regime_code TAX_REGIME_CODE,
7236: rates.content_owner_id CONTENT_OWNER_ID,
7317: SELECT
7318: TAX_STATUS_ID,
7319: TAX_STATUS_CODE,
7320: SYSDATE,
7321: fnd_global.user_id,
7322: SYSDATE,
7323: fnd_global.user_id,
7324: fnd_global.conc_login_id,
7325: L.LANGUAGE_CODE,
7319: TAX_STATUS_CODE,
7320: SYSDATE,
7321: fnd_global.user_id,
7322: SYSDATE,
7323: fnd_global.user_id,
7324: fnd_global.conc_login_id,
7325: L.LANGUAGE_CODE,
7326: userenv('LANG')
7327: FROM
7320: SYSDATE,
7321: fnd_global.user_id,
7322: SYSDATE,
7323: fnd_global.user_id,
7324: fnd_global.conc_login_id,
7325: L.LANGUAGE_CODE,
7326: userenv('LANG')
7327: FROM
7328: FND_LANGUAGES L,
7637: NULL ,--COLL_TAX_AUTHORITY_ID
7638: NULL ,--THRSHLD_CHK_TMPLT_CODE
7639: NULL ,--DEF_PRIMARY_REC_RATE_CODE
7640: NULL ,--DEF_SECONDARY_REC_RATE_CODE
7641: fnd_global.user_id ,
7642: SYSDATE ,
7643: fnd_global.user_id ,
7644: SYSDATE ,
7645: fnd_global.conc_login_id ,
7639: NULL ,--DEF_PRIMARY_REC_RATE_CODE
7640: NULL ,--DEF_SECONDARY_REC_RATE_CODE
7641: fnd_global.user_id ,
7642: SYSDATE ,
7643: fnd_global.user_id ,
7644: SYSDATE ,
7645: fnd_global.conc_login_id ,
7646: fnd_global.conc_request_id ,--Request Id
7647: fnd_global.prog_appl_id ,--Program Application ID
7641: fnd_global.user_id ,
7642: SYSDATE ,
7643: fnd_global.user_id ,
7644: SYSDATE ,
7645: fnd_global.conc_login_id ,
7646: fnd_global.conc_request_id ,--Request Id
7647: fnd_global.prog_appl_id ,--Program Application ID
7648: fnd_global.conc_program_id ,--Program Id
7649: fnd_global.conc_login_id ,--Program Login ID
7642: SYSDATE ,
7643: fnd_global.user_id ,
7644: SYSDATE ,
7645: fnd_global.conc_login_id ,
7646: fnd_global.conc_request_id ,--Request Id
7647: fnd_global.prog_appl_id ,--Program Application ID
7648: fnd_global.conc_program_id ,--Program Id
7649: fnd_global.conc_login_id ,--Program Login ID
7650: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
7643: fnd_global.user_id ,
7644: SYSDATE ,
7645: fnd_global.conc_login_id ,
7646: fnd_global.conc_request_id ,--Request Id
7647: fnd_global.prog_appl_id ,--Program Application ID
7648: fnd_global.conc_program_id ,--Program Id
7649: fnd_global.conc_login_id ,--Program Login ID
7650: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
7651: 1 ,--OBJECT_VERSION_NUMBER
7644: SYSDATE ,
7645: fnd_global.conc_login_id ,
7646: fnd_global.conc_request_id ,--Request Id
7647: fnd_global.prog_appl_id ,--Program Application ID
7648: fnd_global.conc_program_id ,--Program Id
7649: fnd_global.conc_login_id ,--Program Login ID
7650: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
7651: 1 ,--OBJECT_VERSION_NUMBER
7652: 'CREATE_ACCOUNTS' ,--TAX_ACCOUNT_CREATE_METHOD_CODE
7645: fnd_global.conc_login_id ,
7646: fnd_global.conc_request_id ,--Request Id
7647: fnd_global.prog_appl_id ,--Program Application ID
7648: fnd_global.conc_program_id ,--Program Id
7649: fnd_global.conc_login_id ,--Program Login ID
7650: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
7651: 1 ,--OBJECT_VERSION_NUMBER
7652: 'CREATE_ACCOUNTS' ,--TAX_ACCOUNT_CREATE_METHOD_CODE
7653: NULL ,--TAX_ACCOUNT_SOURCE_TAX
7990: NULL ,--COLL_TAX_AUTHORITY_ID
7991: NULL ,--THRSHLD_CHK_TMPLT_CODE
7992: NULL ,--DEF_PRIMARY_REC_RATE_CODE
7993: NULL ,--DEF_SECONDARY_REC_RATE_CODE
7994: fnd_global.user_id ,
7995: SYSDATE ,
7996: fnd_global.user_id ,
7997: SYSDATE ,
7998: fnd_global.conc_login_id ,
7992: NULL ,--DEF_PRIMARY_REC_RATE_CODE
7993: NULL ,--DEF_SECONDARY_REC_RATE_CODE
7994: fnd_global.user_id ,
7995: SYSDATE ,
7996: fnd_global.user_id ,
7997: SYSDATE ,
7998: fnd_global.conc_login_id ,
7999: fnd_global.conc_request_id ,--Request Id
8000: fnd_global.prog_appl_id ,--Program Application ID
7994: fnd_global.user_id ,
7995: SYSDATE ,
7996: fnd_global.user_id ,
7997: SYSDATE ,
7998: fnd_global.conc_login_id ,
7999: fnd_global.conc_request_id ,--Request Id
8000: fnd_global.prog_appl_id ,--Program Application ID
8001: fnd_global.conc_program_id ,--Program Id
8002: fnd_global.conc_login_id ,--Program Login ID
7995: SYSDATE ,
7996: fnd_global.user_id ,
7997: SYSDATE ,
7998: fnd_global.conc_login_id ,
7999: fnd_global.conc_request_id ,--Request Id
8000: fnd_global.prog_appl_id ,--Program Application ID
8001: fnd_global.conc_program_id ,--Program Id
8002: fnd_global.conc_login_id ,--Program Login ID
8003: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
7996: fnd_global.user_id ,
7997: SYSDATE ,
7998: fnd_global.conc_login_id ,
7999: fnd_global.conc_request_id ,--Request Id
8000: fnd_global.prog_appl_id ,--Program Application ID
8001: fnd_global.conc_program_id ,--Program Id
8002: fnd_global.conc_login_id ,--Program Login ID
8003: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
8004: 1 ,--OBJECT_VERSION_NUMBER
7997: SYSDATE ,
7998: fnd_global.conc_login_id ,
7999: fnd_global.conc_request_id ,--Request Id
8000: fnd_global.prog_appl_id ,--Program Application ID
8001: fnd_global.conc_program_id ,--Program Id
8002: fnd_global.conc_login_id ,--Program Login ID
8003: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
8004: 1 ,--OBJECT_VERSION_NUMBER
8005: 'CREATE_ACCOUNTS' ,--TAX_ACCOUNT_CREATE_METHOD_CODE
7998: fnd_global.conc_login_id ,
7999: fnd_global.conc_request_id ,--Request Id
8000: fnd_global.prog_appl_id ,--Program Application ID
8001: fnd_global.conc_program_id ,--Program Id
8002: fnd_global.conc_login_id ,--Program Login ID
8003: NULL ,--OVERRIDE_GEOGRAPHY_TYPE : 4163204
8004: 1 ,--OBJECT_VERSION_NUMBER
8005: 'CREATE_ACCOUNTS' ,--TAX_ACCOUNT_CREATE_METHOD_CODE
8006: NULL ,--TAX_ACCOUNT_SOURCE_TAX
8109: 'JL.BR.ARXSUVAT.AR_VAT_TAX', c.description,
8110: 'JL.CO.ARXSUVAT.AR_VAT_TAX', c.description,
8111: B.TAX) ,
8112: SYSDATE ,
8113: fnd_global.user_id ,
8114: SYSDATE ,
8115: fnd_global.user_id ,
8116: fnd_global.conc_login_id ,
8117: B.TAX_ID
8111: B.TAX) ,
8112: SYSDATE ,
8113: fnd_global.user_id ,
8114: SYSDATE ,
8115: fnd_global.user_id ,
8116: fnd_global.conc_login_id ,
8117: B.TAX_ID
8118: FROM
8119: FND_LANGUAGES L,
8112: SYSDATE ,
8113: fnd_global.user_id ,
8114: SYSDATE ,
8115: fnd_global.user_id ,
8116: fnd_global.conc_login_id ,
8117: B.TAX_ID
8118: FROM
8119: FND_LANGUAGES L,
8120: ZX_TAXES_B B,
8367: NULL ,--THRSHLD_CHK_TMPLT_CODE
8368: NULL ,--PERIOD_SET_NAME
8369: NULL ,--REP_TAX_AUTHORITY_ID
8370: NULL ,--COLL_TAX_AUTHORITY_ID
8371: fnd_global.user_id ,
8372: SYSDATE ,
8373: fnd_global.user_id ,
8374: SYSDATE ,
8375: fnd_global.conc_login_id ,
8369: NULL ,--REP_TAX_AUTHORITY_ID
8370: NULL ,--COLL_TAX_AUTHORITY_ID
8371: fnd_global.user_id ,
8372: SYSDATE ,
8373: fnd_global.user_id ,
8374: SYSDATE ,
8375: fnd_global.conc_login_id ,
8376: fnd_global.conc_request_id ,--Request Id
8377: fnd_global.prog_appl_id ,--Program Application ID
8371: fnd_global.user_id ,
8372: SYSDATE ,
8373: fnd_global.user_id ,
8374: SYSDATE ,
8375: fnd_global.conc_login_id ,
8376: fnd_global.conc_request_id ,--Request Id
8377: fnd_global.prog_appl_id ,--Program Application ID
8378: fnd_global.conc_program_id ,--Program Id
8379: fnd_global.conc_login_id --Program Login ID
8372: SYSDATE ,
8373: fnd_global.user_id ,
8374: SYSDATE ,
8375: fnd_global.conc_login_id ,
8376: fnd_global.conc_request_id ,--Request Id
8377: fnd_global.prog_appl_id ,--Program Application ID
8378: fnd_global.conc_program_id ,--Program Id
8379: fnd_global.conc_login_id --Program Login ID
8380:
8373: fnd_global.user_id ,
8374: SYSDATE ,
8375: fnd_global.conc_login_id ,
8376: fnd_global.conc_request_id ,--Request Id
8377: fnd_global.prog_appl_id ,--Program Application ID
8378: fnd_global.conc_program_id ,--Program Id
8379: fnd_global.conc_login_id --Program Login ID
8380:
8381: FROM
8374: SYSDATE ,
8375: fnd_global.conc_login_id ,
8376: fnd_global.conc_request_id ,--Request Id
8377: fnd_global.prog_appl_id ,--Program Application ID
8378: fnd_global.conc_program_id ,--Program Id
8379: fnd_global.conc_login_id --Program Login ID
8380:
8381: FROM
8382: (
8375: fnd_global.conc_login_id ,
8376: fnd_global.conc_request_id ,--Request Id
8377: fnd_global.prog_appl_id ,--Program Application ID
8378: fnd_global.conc_program_id ,--Program Id
8379: fnd_global.conc_login_id --Program Login ID
8380:
8381: FROM
8382: (
8383: SELECT RATES.TAX_REGIME_CODE TAX_REGIME_CODE,
8423: 'JL.BR.ARXSYSPA.SYS_PARAMETERS', d.meaning,
8424: 'JL.CO.ARXSYSPA.SYS_PARAMETERS', d.meaning,
8425: B.TAX_REGIME_CODE),
8426: SYSDATE ,
8427: fnd_global.user_id ,
8428: SYSDATE ,
8429: fnd_global.user_id ,
8430: fnd_global.conc_login_id ,
8431: B.TAX_REGIME_ID
8425: B.TAX_REGIME_CODE),
8426: SYSDATE ,
8427: fnd_global.user_id ,
8428: SYSDATE ,
8429: fnd_global.user_id ,
8430: fnd_global.conc_login_id ,
8431: B.TAX_REGIME_ID
8432: FROM
8433: FND_LANGUAGES L,
8426: SYSDATE ,
8427: fnd_global.user_id ,
8428: SYSDATE ,
8429: fnd_global.user_id ,
8430: fnd_global.conc_login_id ,
8431: B.TAX_REGIME_ID
8432: FROM
8433: FND_LANGUAGES L,
8434: ZX_REGIMES_B B,
8565: ATTRIBUTE14 ,
8566: ATTRIBUTE15 ,
8567: TAG ,
8568: SYSDATE ,
8569: fnd_global.user_id ,
8570: SYSDATE ,
8571: fnd_global.user_id ,
8572: fnd_global.conc_login_id
8573: FROM FND_LOOKUP_VALUES ap_lookups
8567: TAG ,
8568: SYSDATE ,
8569: fnd_global.user_id ,
8570: SYSDATE ,
8571: fnd_global.user_id ,
8572: fnd_global.conc_login_id
8573: FROM FND_LOOKUP_VALUES ap_lookups
8574: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
8575: AND NOT EXISTS
8568: SYSDATE ,
8569: fnd_global.user_id ,
8570: SYSDATE ,
8571: fnd_global.user_id ,
8572: fnd_global.conc_login_id
8573: FROM FND_LOOKUP_VALUES ap_lookups
8574: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
8575: AND NOT EXISTS
8576: (select 1 from FND_LOOKUP_VALUES
8614: ATTRIBUTE14 ,
8615: ATTRIBUTE15 ,
8616: TAG ,
8617: SYSDATE ,
8618: fnd_global.user_id ,
8619: SYSDATE ,
8620: fnd_global.user_id ,
8621: fnd_global.conc_login_id
8622: FROM FND_LOOKUP_VALUES ar_lookups
8616: TAG ,
8617: SYSDATE ,
8618: fnd_global.user_id ,
8619: SYSDATE ,
8620: fnd_global.user_id ,
8621: fnd_global.conc_login_id
8622: FROM FND_LOOKUP_VALUES ar_lookups
8623: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8624: /* AND NOT EXISTS
8617: SYSDATE ,
8618: fnd_global.user_id ,
8619: SYSDATE ,
8620: fnd_global.user_id ,
8621: fnd_global.conc_login_id
8622: FROM FND_LOOKUP_VALUES ar_lookups
8623: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8624: /* AND NOT EXISTS
8625: (select 1 from FND_LOOKUP_VALUES
8709: ATTRIBUTE14 ,
8710: ATTRIBUTE15 ,
8711: TAG ,
8712: SYSDATE ,
8713: fnd_global.user_id ,
8714: SYSDATE ,
8715: fnd_global.user_id ,
8716: fnd_global.conc_login_id
8717: FROM FND_LOOKUP_VALUES ar_lookups
8711: TAG ,
8712: SYSDATE ,
8713: fnd_global.user_id ,
8714: SYSDATE ,
8715: fnd_global.user_id ,
8716: fnd_global.conc_login_id
8717: FROM FND_LOOKUP_VALUES ar_lookups
8718: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8719: -- Changed the re-runnability check
8712: SYSDATE ,
8713: fnd_global.user_id ,
8714: SYSDATE ,
8715: fnd_global.user_id ,
8716: fnd_global.conc_login_id
8717: FROM FND_LOOKUP_VALUES ar_lookups
8718: WHERE ar_lookups.LOOKUP_TYPE = 'TAX_TYPE'
8719: -- Changed the re-runnability check
8720: AND NOT EXISTS
9078: codes.tag , --TAG --Bug 4562058
9079: SYSDATE , --CREATION_DATE
9080: -1087 , --CREATED_BY --Bug 4562058
9081: SYSDATE , --LAST_UPDATE_DATE
9082: fnd_global.user_id , --LAST_UPDATED_BY
9083: fnd_global.conc_login_id --LAST_UPDATE_LOGIN
9084: FROM
9085: (
9086: SELECT
9079: SYSDATE , --CREATION_DATE
9080: -1087 , --CREATED_BY --Bug 4562058
9081: SYSDATE , --LAST_UPDATE_DATE
9082: fnd_global.user_id , --LAST_UPDATED_BY
9083: fnd_global.conc_login_id --LAST_UPDATE_LOGIN
9084: FROM
9085: (
9086: SELECT
9087: CASE WHEN LENGTHB(codes.tax_code) > 30
9158: codes.tax_type,
9159: 'AR',
9160: codes.start_date,
9161: codes.end_date,
9162: fnd_global.user_id , -- CREATED_BY
9163: SYSDATE , -- CREATION_DATE
9164: fnd_global.user_id , -- LAST_UPDATED_BY
9165: SYSDATE , -- LAST_UPDATE_DATE
9166: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
9160: codes.start_date,
9161: codes.end_date,
9162: fnd_global.user_id , -- CREATED_BY
9163: SYSDATE , -- CREATION_DATE
9164: fnd_global.user_id , -- LAST_UPDATED_BY
9165: SYSDATE , -- LAST_UPDATE_DATE
9166: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
9167: fnd_global.conc_request_id , -- REQUEST_ID
9168: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
9162: fnd_global.user_id , -- CREATED_BY
9163: SYSDATE , -- CREATION_DATE
9164: fnd_global.user_id , -- LAST_UPDATED_BY
9165: SYSDATE , -- LAST_UPDATE_DATE
9166: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
9167: fnd_global.conc_request_id , -- REQUEST_ID
9168: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
9169: fnd_global.conc_program_id , -- PROGRAM_ID
9170: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
9163: SYSDATE , -- CREATION_DATE
9164: fnd_global.user_id , -- LAST_UPDATED_BY
9165: SYSDATE , -- LAST_UPDATE_DATE
9166: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
9167: fnd_global.conc_request_id , -- REQUEST_ID
9168: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
9169: fnd_global.conc_program_id , -- PROGRAM_ID
9170: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
9171: codes.set_of_books_id , -- SET_OF_BOOKS_ID
9164: fnd_global.user_id , -- LAST_UPDATED_BY
9165: SYSDATE , -- LAST_UPDATE_DATE
9166: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
9167: fnd_global.conc_request_id , -- REQUEST_ID
9168: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
9169: fnd_global.conc_program_id , -- PROGRAM_ID
9170: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
9171: codes.set_of_books_id , -- SET_OF_BOOKS_ID
9172: codes.enabled_flag
9165: SYSDATE , -- LAST_UPDATE_DATE
9166: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
9167: fnd_global.conc_request_id , -- REQUEST_ID
9168: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
9169: fnd_global.conc_program_id , -- PROGRAM_ID
9170: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
9171: codes.set_of_books_id , -- SET_OF_BOOKS_ID
9172: codes.enabled_flag
9173: FROM
9166: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
9167: fnd_global.conc_request_id , -- REQUEST_ID
9168: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
9169: fnd_global.conc_program_id , -- PROGRAM_ID
9170: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
9171: codes.set_of_books_id , -- SET_OF_BOOKS_ID
9172: codes.enabled_flag
9173: FROM
9174: ar_vat_tax_all_b codes
9314: ELSE
9315: TAX_REGIME_CODE
9316: END,
9317: SYSDATE,
9318: fnd_global.user_id,
9319: SYSDATE,
9320: fnd_global.user_id,
9321: fnd_global.conc_login_id,
9322: L.LANGUAGE_CODE,
9316: END,
9317: SYSDATE,
9318: fnd_global.user_id,
9319: SYSDATE,
9320: fnd_global.user_id,
9321: fnd_global.conc_login_id,
9322: L.LANGUAGE_CODE,
9323: userenv('LANG')
9324: FROM
9317: SYSDATE,
9318: fnd_global.user_id,
9319: SYSDATE,
9320: fnd_global.user_id,
9321: fnd_global.conc_login_id,
9322: L.LANGUAGE_CODE,
9323: userenv('LANG')
9324: FROM
9325: FND_LANGUAGES L,
9364: ELSE
9365: flv.meaning
9366: END,
9367: SYSDATE ,
9368: fnd_global.user_id ,
9369: SYSDATE ,
9370: fnd_global.user_id ,
9371: fnd_global.conc_login_id ,
9372: taxes.tax_id
9366: END,
9367: SYSDATE ,
9368: fnd_global.user_id ,
9369: SYSDATE ,
9370: fnd_global.user_id ,
9371: fnd_global.conc_login_id ,
9372: taxes.tax_id
9373: FROM
9374: zx_taxes_b taxes,
9367: SYSDATE ,
9368: fnd_global.user_id ,
9369: SYSDATE ,
9370: fnd_global.user_id ,
9371: fnd_global.conc_login_id ,
9372: taxes.tax_id
9373: FROM
9374: zx_taxes_b taxes,
9375: zx_rates_b rates,
9412: ELSE
9413: flv.meaning
9414: END,
9415: SYSDATE ,
9416: fnd_global.user_id ,
9417: SYSDATE ,
9418: fnd_global.user_id ,
9419: fnd_global.conc_login_id ,
9420: taxes.tax_id
9414: END,
9415: SYSDATE ,
9416: fnd_global.user_id ,
9417: SYSDATE ,
9418: fnd_global.user_id ,
9419: fnd_global.conc_login_id ,
9420: taxes.tax_id
9421: FROM
9422: zx_taxes_b taxes,
9415: SYSDATE ,
9416: fnd_global.user_id ,
9417: SYSDATE ,
9418: fnd_global.user_id ,
9419: fnd_global.conc_login_id ,
9420: taxes.tax_id
9421: FROM
9422: zx_taxes_b taxes,
9423: zx_rates_b rates,
9459: ELSE
9460: flv.meaning
9461: END,
9462: SYSDATE ,
9463: fnd_global.user_id ,
9464: SYSDATE ,
9465: fnd_global.user_id ,
9466: fnd_global.conc_login_id ,
9467: taxes.tax_id
9461: END,
9462: SYSDATE ,
9463: fnd_global.user_id ,
9464: SYSDATE ,
9465: fnd_global.user_id ,
9466: fnd_global.conc_login_id ,
9467: taxes.tax_id
9468: FROM
9469: zx_taxes_b taxes,
9462: SYSDATE ,
9463: fnd_global.user_id ,
9464: SYSDATE ,
9465: fnd_global.user_id ,
9466: fnd_global.conc_login_id ,
9467: taxes.tax_id
9468: FROM
9469: zx_taxes_b taxes,
9470: zx_rates_b rates,
9509: ELSE
9510: NVL(categs.description, rates.tax)
9511: END,
9512: SYSDATE ,
9513: fnd_global.user_id ,
9514: SYSDATE ,
9515: fnd_global.user_id ,
9516: fnd_global.conc_login_id ,
9517: B.TAX_ID
9511: END,
9512: SYSDATE ,
9513: fnd_global.user_id ,
9514: SYSDATE ,
9515: fnd_global.user_id ,
9516: fnd_global.conc_login_id ,
9517: B.TAX_ID
9518: FROM
9519: FND_LANGUAGES L,
9512: SYSDATE ,
9513: fnd_global.user_id ,
9514: SYSDATE ,
9515: fnd_global.user_id ,
9516: fnd_global.conc_login_id ,
9517: B.TAX_ID
9518: FROM
9519: FND_LANGUAGES L,
9520: ZX_TAXES_B B,
9558: ELSE
9559: NVL(categs.description, rates.tax)
9560: END ,
9561: SYSDATE ,
9562: fnd_global.user_id ,
9563: SYSDATE ,
9564: fnd_global.user_id ,
9565: fnd_global.conc_login_id ,
9566: B.TAX_ID
9560: END ,
9561: SYSDATE ,
9562: fnd_global.user_id ,
9563: SYSDATE ,
9564: fnd_global.user_id ,
9565: fnd_global.conc_login_id ,
9566: B.TAX_ID
9567: FROM
9568: FND_LANGUAGES L,
9561: SYSDATE ,
9562: fnd_global.user_id ,
9563: SYSDATE ,
9564: fnd_global.user_id ,
9565: fnd_global.conc_login_id ,
9566: B.TAX_ID
9567: FROM
9568: FND_LANGUAGES L,
9569: ZX_TAXES_B B,
9607: ELSE
9608: NVL(categs.description, rates.tax)
9609: END ,
9610: SYSDATE ,
9611: fnd_global.user_id ,
9612: SYSDATE ,
9613: fnd_global.user_id ,
9614: fnd_global.conc_login_id ,
9615: B.TAX_ID
9609: END ,
9610: SYSDATE ,
9611: fnd_global.user_id ,
9612: SYSDATE ,
9613: fnd_global.user_id ,
9614: fnd_global.conc_login_id ,
9615: B.TAX_ID
9616: FROM
9617: FND_LANGUAGES L,
9610: SYSDATE ,
9611: fnd_global.user_id ,
9612: SYSDATE ,
9613: fnd_global.user_id ,
9614: fnd_global.conc_login_id ,
9615: B.TAX_ID
9616: FROM
9617: FND_LANGUAGES L,
9618: ZX_TAXES_B B,
9655: ELSE
9656: TAX
9657: END,
9658: SYSDATE,
9659: fnd_global.user_id,
9660: SYSDATE,
9661: fnd_global.user_id,
9662: fnd_global.conc_login_id,
9663: L.LANGUAGE_CODE,
9657: END,
9658: SYSDATE,
9659: fnd_global.user_id,
9660: SYSDATE,
9661: fnd_global.user_id,
9662: fnd_global.conc_login_id,
9663: L.LANGUAGE_CODE,
9664: userenv('LANG')
9665: FROM
9658: SYSDATE,
9659: fnd_global.user_id,
9660: SYSDATE,
9661: fnd_global.user_id,
9662: fnd_global.conc_login_id,
9663: L.LANGUAGE_CODE,
9664: userenv('LANG')
9665: FROM
9666: FND_LANGUAGES L,
9716: 'JL.BR.ARXSUVAT.AR_VAT_TAX', c.description,
9717: 'JL.CO.ARXSUVAT.AR_VAT_TAX', c.description,
9718: B.TAX) ,
9719: SYSDATE ,
9720: fnd_global.user_id ,
9721: SYSDATE ,
9722: fnd_global.user_id ,
9723: fnd_global.conc_login_id ,
9724: B.TAX_ID
9718: B.TAX) ,
9719: SYSDATE ,
9720: fnd_global.user_id ,
9721: SYSDATE ,
9722: fnd_global.user_id ,
9723: fnd_global.conc_login_id ,
9724: B.TAX_ID
9725: FROM
9726: FND_LANGUAGES L,
9719: SYSDATE ,
9720: fnd_global.user_id ,
9721: SYSDATE ,
9722: fnd_global.user_id ,
9723: fnd_global.conc_login_id ,
9724: B.TAX_ID
9725: FROM
9726: FND_LANGUAGES L,
9727: ZX_TAXES_B B,
9778: ELSE
9779: flv.meaning
9780: END,
9781: sysdate,
9782: fnd_global.user_id,
9783: sysdate,
9784: fnd_global.user_id,
9785: fnd_global.conc_login_id,
9786: flv.language,
9780: END,
9781: sysdate,
9782: fnd_global.user_id,
9783: sysdate,
9784: fnd_global.user_id,
9785: fnd_global.conc_login_id,
9786: flv.language,
9787: userenv('LANG')
9788: from zx_rates_b rates,
9781: sysdate,
9782: fnd_global.user_id,
9783: sysdate,
9784: fnd_global.user_id,
9785: fnd_global.conc_login_id,
9786: flv.language,
9787: userenv('LANG')
9788: from zx_rates_b rates,
9789: zx_status_b status,
9827: ELSE
9828: TAX_STATUS_CODE
9829: END,
9830: SYSDATE,
9831: fnd_global.user_id,
9832: SYSDATE,
9833: fnd_global.user_id,
9834: fnd_global.conc_login_id,
9835: L.LANGUAGE_CODE,
9829: END,
9830: SYSDATE,
9831: fnd_global.user_id,
9832: SYSDATE,
9833: fnd_global.user_id,
9834: fnd_global.conc_login_id,
9835: L.LANGUAGE_CODE,
9836: userenv('LANG')
9837: FROM
9830: SYSDATE,
9831: fnd_global.user_id,
9832: SYSDATE,
9833: fnd_global.user_id,
9834: fnd_global.conc_login_id,
9835: L.LANGUAGE_CODE,
9836: userenv('LANG')
9837: FROM
9838: FND_LANGUAGES L,
9868: WHEN avtt.PRINTED_TAX_NAME IS NULL
9869: THEN NULL
9870: ELSE avtt.PRINTED_TAX_NAME||'-'||b.tax_class
9871: END,
9872: fnd_global.user_id,
9873: sysdate,
9874: fnd_global.user_id,
9875: sysdate,
9876: fnd_global.login_id,
9870: ELSE avtt.PRINTED_TAX_NAME||'-'||b.tax_class
9871: END,
9872: fnd_global.user_id,
9873: sysdate,
9874: fnd_global.user_id,
9875: sysdate,
9876: fnd_global.login_id,
9877: avtt.language ,
9878: avtt.source_lang ,
9872: fnd_global.user_id,
9873: sysdate,
9874: fnd_global.user_id,
9875: sysdate,
9876: fnd_global.login_id,
9877: avtt.language ,
9878: avtt.source_lang ,
9879: avtb.description
9880: FROM zx_rates_b b,
9906: DESCRIPTION
9907: )
9908: SELECT zrb.tax_rate_id,
9909: Initcap(zrb.tax_rate_code)||'-'||zrb.tax_class,
9910: fnd_global.user_id ,
9911: SYSDATE ,
9912: fnd_global.user_id ,
9913: SYSDATE ,
9914: fnd_global.conc_login_id ,
9908: SELECT zrb.tax_rate_id,
9909: Initcap(zrb.tax_rate_code)||'-'||zrb.tax_class,
9910: fnd_global.user_id ,
9911: SYSDATE ,
9912: fnd_global.user_id ,
9913: SYSDATE ,
9914: fnd_global.conc_login_id ,
9915: l.language_code ,
9916: userenv('LANG') ,
9910: fnd_global.user_id ,
9911: SYSDATE ,
9912: fnd_global.user_id ,
9913: SYSDATE ,
9914: fnd_global.conc_login_id ,
9915: l.language_code ,
9916: userenv('LANG') ,
9917: Initcap(zrb.tax_rate_code)
9918: FROM zx_rates_b zrb,
10083: 'STANDARD_TB' , --taxable_basis_formula_code
10084: 'N' , --inclusive_tax_flag
10085: 'N' , --tax_inclusive_override_flag
10086: 'MIGRATED' , --record_type_code
10087: fnd_global.user_id , --created_by
10088: SYSDATE , --creation_date
10089: fnd_global.user_id , --last_updated_by
10090: SYSDATE , --last_update_date
10091: fnd_global.user_id , --last_update_login
10085: 'N' , --tax_inclusive_override_flag
10086: 'MIGRATED' , --record_type_code
10087: fnd_global.user_id , --created_by
10088: SYSDATE , --creation_date
10089: fnd_global.user_id , --last_updated_by
10090: SYSDATE , --last_update_date
10091: fnd_global.user_id , --last_update_login
10092: fnd_global.conc_request_id , --request_id
10093: fnd_global.prog_appl_id , --program_application_id
10087: fnd_global.user_id , --created_by
10088: SYSDATE , --creation_date
10089: fnd_global.user_id , --last_updated_by
10090: SYSDATE , --last_update_date
10091: fnd_global.user_id , --last_update_login
10092: fnd_global.conc_request_id , --request_id
10093: fnd_global.prog_appl_id , --program_application_id
10094: fnd_global.conc_program_id , --program_id
10095: fnd_global.conc_login_id , --program_login_id
10088: SYSDATE , --creation_date
10089: fnd_global.user_id , --last_updated_by
10090: SYSDATE , --last_update_date
10091: fnd_global.user_id , --last_update_login
10092: fnd_global.conc_request_id , --request_id
10093: fnd_global.prog_appl_id , --program_application_id
10094: fnd_global.conc_program_id , --program_id
10095: fnd_global.conc_login_id , --program_login_id
10096: NULL , --ATTRIBUTE1
10089: fnd_global.user_id , --last_updated_by
10090: SYSDATE , --last_update_date
10091: fnd_global.user_id , --last_update_login
10092: fnd_global.conc_request_id , --request_id
10093: fnd_global.prog_appl_id , --program_application_id
10094: fnd_global.conc_program_id , --program_id
10095: fnd_global.conc_login_id , --program_login_id
10096: NULL , --ATTRIBUTE1
10097: NULL , --ATTRIBUTE2
10090: SYSDATE , --last_update_date
10091: fnd_global.user_id , --last_update_login
10092: fnd_global.conc_request_id , --request_id
10093: fnd_global.prog_appl_id , --program_application_id
10094: fnd_global.conc_program_id , --program_id
10095: fnd_global.conc_login_id , --program_login_id
10096: NULL , --ATTRIBUTE1
10097: NULL , --ATTRIBUTE2
10098: NULL , --ATTRIBUTE3
10091: fnd_global.user_id , --last_update_login
10092: fnd_global.conc_request_id , --request_id
10093: fnd_global.prog_appl_id , --program_application_id
10094: fnd_global.conc_program_id , --program_id
10095: fnd_global.conc_login_id , --program_login_id
10096: NULL , --ATTRIBUTE1
10097: NULL , --ATTRIBUTE2
10098: NULL , --ATTRIBUTE3
10099: NULL , --ATTRIBUTE4
10177: NULL ,--EDISC_NON_REC_TAX_CCID
10178: NULL ,--UNEDISC_NON_REC_TAX_CCID
10179: NULL ,--FINCHRG_NON_REC_TAX_CCID
10180: 'MIGRATED' ,--RECORD_TYPE_CODE
10181: fnd_global.user_id ,--CREATED_BY
10182: sysdate ,--CREATION_DATE
10183: fnd_global.user_id ,--LAST_UPDATED_BY
10184: sysdate ,--LAST_UPDATE_DATE
10185: fnd_global.user_id ,--LAST_UPDATE_LOGIN
10179: NULL ,--FINCHRG_NON_REC_TAX_CCID
10180: 'MIGRATED' ,--RECORD_TYPE_CODE
10181: fnd_global.user_id ,--CREATED_BY
10182: sysdate ,--CREATION_DATE
10183: fnd_global.user_id ,--LAST_UPDATED_BY
10184: sysdate ,--LAST_UPDATE_DATE
10185: fnd_global.user_id ,--LAST_UPDATE_LOGIN
10186: fnd_global.conc_request_id ,--REQUEST_ID
10187: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
10181: fnd_global.user_id ,--CREATED_BY
10182: sysdate ,--CREATION_DATE
10183: fnd_global.user_id ,--LAST_UPDATED_BY
10184: sysdate ,--LAST_UPDATE_DATE
10185: fnd_global.user_id ,--LAST_UPDATE_LOGIN
10186: fnd_global.conc_request_id ,--REQUEST_ID
10187: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
10188: fnd_global.conc_program_id ,--PROGRAM_ID
10189: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
10182: sysdate ,--CREATION_DATE
10183: fnd_global.user_id ,--LAST_UPDATED_BY
10184: sysdate ,--LAST_UPDATE_DATE
10185: fnd_global.user_id ,--LAST_UPDATE_LOGIN
10186: fnd_global.conc_request_id ,--REQUEST_ID
10187: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
10188: fnd_global.conc_program_id ,--PROGRAM_ID
10189: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
10190: NULL ,--ATTRIBUTE1
10183: fnd_global.user_id ,--LAST_UPDATED_BY
10184: sysdate ,--LAST_UPDATE_DATE
10185: fnd_global.user_id ,--LAST_UPDATE_LOGIN
10186: fnd_global.conc_request_id ,--REQUEST_ID
10187: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
10188: fnd_global.conc_program_id ,--PROGRAM_ID
10189: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
10190: NULL ,--ATTRIBUTE1
10191: NULL ,--ATTRIBUTE2
10184: sysdate ,--LAST_UPDATE_DATE
10185: fnd_global.user_id ,--LAST_UPDATE_LOGIN
10186: fnd_global.conc_request_id ,--REQUEST_ID
10187: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
10188: fnd_global.conc_program_id ,--PROGRAM_ID
10189: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
10190: NULL ,--ATTRIBUTE1
10191: NULL ,--ATTRIBUTE2
10192: NULL ,--ATTRIBUTE3
10185: fnd_global.user_id ,--LAST_UPDATE_LOGIN
10186: fnd_global.conc_request_id ,--REQUEST_ID
10187: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
10188: fnd_global.conc_program_id ,--PROGRAM_ID
10189: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
10190: NULL ,--ATTRIBUTE1
10191: NULL ,--ATTRIBUTE2
10192: NULL ,--ATTRIBUTE3
10193: NULL ,--ATTRIBUTE4