[Home] [Help]
630: fnd_global.user_id ,
631: SYSDATE ,
632: fnd_global.conc_login_id
633: FROM FND_LOOKUP_TYPES types,
634: FND_LANGUAGES L
635: WHERE L.INSTALLED_FLAG in ('I', 'B')
636: AND types.lookup_type in ('ZX_OUTPUT_CLASSIFICATIONS',
637: 'ZX_INPUT_CLASSIFICATIONS',
638: 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
749: AND codes.name = cursor_rec.name
750: AND ROWNUM = 1
751:
752: )CODES,
753: FND_LANGUAGES LANG
754:
755:
756: WHERE
757: LANG.INSTALLED_FLAG IN ('I','B')
873: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
874: AND codes.name = cursor_rec.name
875: AND ROWNUM = 1
876: )CODES,
877: FND_LANGUAGES LANG
878: WHERE
879: LANG.INSTALLED_FLAG IN ('I','B')
880: AND
881: NOT EXISTS
2732: fnd_global.conc_login_id ,
2733: L.LANGUAGE_CODE,
2734: userenv('LANG'),
2735: avtb.description
2736: FROM FND_LANGUAGES L,
2737: ZX_RATES_B RATES,
2738: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
2739: WHERE
2740: L.INSTALLED_FLAG in ('I', 'B')
4094: fnd_global.conc_login_id ,
4095: L.LANGUAGE_CODE,
4096: userenv('LANG'),
4097: avtb.description
4098: FROM FND_LANGUAGES L,
4099: ZX_RATES_B RATES,
4100: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
4101: WHERE
4102: L.INSTALLED_FLAG in ('I', 'B')
5443: fnd_global.conc_login_id ,
5444: L.LANGUAGE_CODE,
5445: userenv('LANG'),
5446: avtb.description
5447: FROM FND_LANGUAGES L,
5448: ZX_RATES_B RATES,
5449: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
5450: WHERE
5451: L.INSTALLED_FLAG in ('I', 'B')
5747: fnd_global.conc_login_id ,
5748: L.LANGUAGE_CODE,
5749: userenv('LANG'),
5750: avtb.description
5751: FROM FND_LANGUAGES L,
5752: ZX_RATES_B RATES,
5753: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
5754: WHERE
5755: L.INSTALLED_FLAG in ('I', 'B')
6168: SYSDATE ,
6169: fnd_global.conc_login_id ,
6170: L.LANGUAGE_CODE,
6171: userenv('LANG')
6172: FROM FND_LANGUAGES L,
6173: ZX_RATES_B RATES
6174: WHERE
6175: L.INSTALLED_FLAG in ('I', 'B')
6176: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
6662: fnd_global.conc_login_id,
6663: L.LANGUAGE_CODE,
6664: userenv('LANG')
6665: FROM
6666: FND_LANGUAGES L,
6667: ZX_STATUS_B Status,
6668: JA_LOOKUPS lookups,
6669: ap_tax_codes_all codes,
6670: ZX_RATES_B rates
6725: fnd_global.conc_login_id,
6726: L.LANGUAGE_CODE,
6727: userenv('LANG')
6728: FROM
6729: FND_LANGUAGES L,
6730: ZX_STATUS_B B
6731: WHERE
6732: L.INSTALLED_FLAG in ('I', 'B')
6733: AND RECORD_TYPE_CODE = 'MIGRATED'
8689: fnd_global.user_id ,
8690: fnd_global.conc_login_id ,
8691: B.TAX_ID
8692: FROM
8693: FND_LANGUAGES L,
8694: ZX_TAXES_B B
8695: WHERE
8696: L.INSTALLED_FLAG in ('I', 'B')
8697: AND RECORD_TYPE_CODE = 'MIGRATED'
8854: SYSDATE ,
8855: fnd_global.user_id ,
8856: fnd_global.conc_login_id
8857: FROM
8858: FND_LANGUAGES L,
8859: ZX_DET_FACTOR_TEMPL_B B
8860: WHERE
8861: L.INSTALLED_FLAG in ('I', 'B')
8862: AND RECORD_TYPE_CODE = 'MIGRATED'
9687: SYSDATE ,
9688: fnd_global.user_id ,
9689: fnd_global.conc_login_id
9690: FROM
9691: FND_LANGUAGES L,
9692: ZX_CONDITION_GROUPS_B B
9693: WHERE
9694: L.INSTALLED_FLAG in ('I', 'B')
9695: AND RECORD_TYPE_CODE = 'MIGRATED'
10009: FROM ap_tax_codes_all codes,
10010: ap_tax_recvry_rules_all Rules,
10011: zx_rates_b rates,
10012: zx_rules_b b,
10013: fnd_languages L
10014: WHERE l.installed_flag in ('I', 'B')
10015: AND codes.TAX_RECOVERY_RULE_ID = RULES.RULE_ID
10016: AND codes.tax_id = rates.source_id
10017: AND b.tax = rates.tax
14240: fnd_global.conc_login_id ,
14241: L.LANGUAGE_CODE,
14242: userenv('LANG'),
14243: avtb.description
14244: FROM FND_LANGUAGES L,
14245: ZX_RATES_B RATES,
14246: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
14247: WHERE
14248: L.INSTALLED_FLAG in ('I', 'B')