[Home] [Help]
606: fnd_global.user_id ,
607: SYSDATE ,
608: fnd_global.conc_login_id
609: FROM FND_LOOKUP_TYPES types,
610: FND_LANGUAGES L
611: WHERE L.INSTALLED_FLAG in ('I', 'B')
612: AND types.lookup_type in ('ZX_OUTPUT_CLASSIFICATIONS',
613: 'ZX_INPUT_CLASSIFICATIONS',
614: 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
725: AND codes.name = cursor_rec.name
726: AND ROWNUM = 1
727:
728: )CODES,
729: FND_LANGUAGES LANG
730:
731:
732: WHERE
733: LANG.INSTALLED_FLAG IN ('I','B')
852: AND codes.name = cursor_rec.name
853: AND ROWNUM = 1
854:
855: )CODES,
856: FND_LANGUAGES LANG
857:
858:
859: WHERE
860: LANG.INSTALLED_FLAG IN ('I','B')
2718: fnd_global.conc_login_id ,
2719: L.LANGUAGE_CODE,
2720: userenv('LANG'),
2721: avtb.description
2722: FROM FND_LANGUAGES L,
2723: ZX_RATES_B RATES,
2724: ar_vat_tax_all_b avtb
2725: WHERE
2726: L.INSTALLED_FLAG in ('I', 'B')
4072: fnd_global.conc_login_id ,
4073: L.LANGUAGE_CODE,
4074: userenv('LANG'),
4075: avtb.description
4076: FROM FND_LANGUAGES L,
4077: ZX_RATES_B RATES,
4078: ar_vat_tax_all_b avtb
4079: WHERE
4080: L.INSTALLED_FLAG in ('I', 'B')
5413: fnd_global.conc_login_id ,
5414: L.LANGUAGE_CODE,
5415: userenv('LANG'),
5416: avtb.description
5417: FROM FND_LANGUAGES L,
5418: ZX_RATES_B RATES,
5419: ar_vat_tax_all_b avtb
5420: WHERE
5421: L.INSTALLED_FLAG in ('I', 'B')
5716: fnd_global.conc_login_id ,
5717: L.LANGUAGE_CODE,
5718: userenv('LANG'),
5719: avtb.description
5720: FROM FND_LANGUAGES L,
5721: ZX_RATES_B RATES,
5722: ar_vat_tax_all_b avtb
5723: WHERE
5724: L.INSTALLED_FLAG in ('I', 'B')
6137: SYSDATE ,
6138: fnd_global.conc_login_id ,
6139: L.LANGUAGE_CODE,
6140: userenv('LANG')
6141: FROM FND_LANGUAGES L,
6142: ZX_RATES_B RATES
6143: WHERE
6144: L.INSTALLED_FLAG in ('I', 'B')
6145: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'
6631: fnd_global.conc_login_id,
6632: L.LANGUAGE_CODE,
6633: userenv('LANG')
6634: FROM
6635: FND_LANGUAGES L,
6636: ZX_STATUS_B Status,
6637: JA_LOOKUPS lookups,
6638: ap_tax_codes_all codes,
6639: ZX_RATES_B rates
6694: fnd_global.conc_login_id,
6695: L.LANGUAGE_CODE,
6696: userenv('LANG')
6697: FROM
6698: FND_LANGUAGES L,
6699: ZX_STATUS_B B
6700: WHERE
6701: L.INSTALLED_FLAG in ('I', 'B')
6702: AND RECORD_TYPE_CODE = 'MIGRATED'
8667: fnd_global.user_id ,
8668: fnd_global.conc_login_id ,
8669: B.TAX_ID
8670: FROM
8671: FND_LANGUAGES L,
8672: ZX_TAXES_B B
8673: WHERE
8674: L.INSTALLED_FLAG in ('I', 'B')
8675: AND RECORD_TYPE_CODE = 'MIGRATED'
8832: SYSDATE ,
8833: fnd_global.user_id ,
8834: fnd_global.conc_login_id
8835: FROM
8836: FND_LANGUAGES L,
8837: ZX_DET_FACTOR_TEMPL_B B
8838: WHERE
8839: L.INSTALLED_FLAG in ('I', 'B')
8840: AND RECORD_TYPE_CODE = 'MIGRATED'
9389: SYSDATE ,
9390: fnd_global.user_id ,
9391: fnd_global.conc_login_id
9392: FROM
9393: FND_LANGUAGES L,
9394: ZX_CONDITION_GROUPS_B B
9395: WHERE
9396: L.INSTALLED_FLAG in ('I', 'B')
9397: AND RECORD_TYPE_CODE = 'MIGRATED'
9714: SYSDATE ,
9715: fnd_global.user_id ,
9716: fnd_global.conc_login_id
9717: FROM
9718: FND_LANGUAGES L,
9719: ZX_RULES_B B
9720: WHERE
9721: L.INSTALLED_FLAG in ('I', 'B')
9722: AND RECORD_TYPE_CODE = 'MIGRATED'
13915: fnd_global.conc_login_id ,
13916: L.LANGUAGE_CODE,
13917: userenv('LANG'),
13918: avtb.description
13919: FROM FND_LANGUAGES L,
13920: ZX_RATES_B RATES,
13921: ar_vat_tax_all_b avtb
13922: WHERE
13923: L.INSTALLED_FLAG in ('I', 'B')