DBA Data[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on FND_LANGUAGES

Line 957: FND_LANGUAGES L

953: codes.classification_id
954: FROM
955: ZX_FC_CODES_b Codes,
956: FND_LOOKUP_VALUES FL,
957: FND_LANGUAGES L
958: WHERE
959: Codes.classification_type_code = 'PRODUCT_CATEGORY'
960: AND Codes.parent_classification_id=l_fc_id
961: AND Codes.classification_code = FL.lookup_code

Line 1281: FND_LANGUAGES L

1277: l.language_code lang_code,
1278: codes.classification_id
1279: FROM ZX_FC_CODES_B Codes,
1280: JL_BR_AP_OPERATIONS JLBR,
1281: FND_LANGUAGES L
1282: WHERE
1283: Codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
1284: and Codes.parent_classification_id is null
1285: AND Codes.classification_code=JLBR.cfo_code

Line 1505: FND_LANGUAGES L,

1501: FROM
1502: ZX_FC_CODES_DENORM_B fc,
1503: ZX_FC_CODES_B Codes,
1504: JL_BR_AP_OPERATIONS ap_op,
1505: FND_LANGUAGES L,
1506: ZX_EVENT_CLASSES_VL event
1507: WHERE
1508: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
1509: and fc.classification_code='OPERATION FISCAL CODE'

Line 1747: FND_LANGUAGES L

1743: classification_id
1744: FROM
1745: ZX_FC_CODES_B Codes,
1746: FND_LOOKUP_VALUES LV,
1747: FND_LANGUAGES L
1748: WHERE
1749: Codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
1750: AND Codes.parent_classification_id = l_fc_id
1751: AND Codes.classification_code = LV.lookup_code

Line 2241: fnd_languages l,

2237: 'SEEDED')
2238: select
2239: language_code lang_code, fc_codes.classification_id
2240: from
2241: fnd_languages l,
2242: zx_fc_codes_b fc_codes
2243: where
2244: l.installed_flag in ('I', 'B')
2245: and fc_codes.classification_type_code = p_classification_type_code

Line 2484: fnd_languages l

2480: Codes.classification_id
2481: FROM
2482: zx_fc_codes_b Codes,
2483: fnd_lookup_values fl,
2484: fnd_languages l
2485: WHERE
2486:
2487: codes.classification_type_code = p_classification_type_code
2488: and (codes.parent_classification_id = p_parent_fc_id or

Line 2751: FND_LANGUAGES L

2747: ZX_FC_CODES_DENORM_B fc,
2748: ZX_FC_CODES_b Codes,
2749: ZX_EVENT_CLASSES_VL event,
2750: FND_LOOKUP_VALUES FL,
2751: FND_LANGUAGES L
2752: WHERE fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2753: and fc.classification_code=p_classification_code
2754: and fc.language = userenv('LANG')
2755: and fc.ancestor_code = event.tax_event_class_code

Line 2994: FND_LANGUAGES L

2990: FROM
2991: ZX_FC_CODES_B fc,
2992: ZX_FC_CODES_B zx,
2993: ZX_EVENT_CLASSES_TL event,
2994: FND_LANGUAGES L
2995: WHERE
2996: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2997: and fc.parent_classification_id is null
2998: and fc.classification_code=event.tax_event_class_code

Line 3158: FROM FND_LANGUAGES L,

3154: FND_GLOBAL.CONC_LOGIN_ID,
3155: language_code,
3156: userenv('LANG')
3157:
3158: FROM FND_LANGUAGES L,
3159: ZX_FC_TYPES_B Types
3160: where
3161: Types.classification_type_code = p_classification_type_code
3162: and Types.classification_type_categ_code = 'PRODUCT_FISCAL_CLASS'

Line 3253: FROM FND_LANGUAGES L,

3249: detFactors.DETERMINING_FACTOR_ID,
3250: L.LANGUAGE_CODE,
3251: userenv('LANG')
3252:
3253: FROM FND_LANGUAGES L,
3254: ZX_DETERMINING_FACTORS_B detFactors
3255: WHERE
3256: detFactors.DETERMINING_FACTOR_CODE = p_classification_type_code
3257: and detFactors.DETERMINING_FACTOR_CLASS_CODE = 'PRODUCT_FISCAL_CLASS'

Line 3352: FROM FND_LANGUAGES L,

3348: FND_GLOBAL.CONC_LOGIN_ID,
3349: language_code,
3350: userenv('LANG')
3351:
3352: FROM FND_LANGUAGES L,
3353: ZX_FC_TYPES_B Types
3354: where
3355: Types.classification_type_code = p_classification_type_code
3356: and Types.classification_type_categ_code = 'PARTY_FISCAL_CLASS'

Line 3446: FROM FND_LANGUAGES L,

3442: FND_GLOBAL.CONC_LOGIN_ID,
3443: detFactors.DETERMINING_FACTOR_ID,
3444: L.LANGUAGE_CODE,
3445: userenv('LANG')
3446: FROM FND_LANGUAGES L,
3447: ZX_DETERMINING_FACTORS_B detFactors
3448: WHERE detFactors.DETERMINING_FACTOR_CODE = p_classification_type_code
3449: and detFactors.DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS'
3450: --and detFactors.RECORD_TYPE_CODE = 'MIGRATED'

Line 3790: FND_LANGUAGES L

3786: FROM
3787: ZX_FC_CODES_B Codes,
3788: FND_FLEX_VALUES V,
3789: fnd_flex_value_sets vs,
3790: FND_LANGUAGES L
3791:
3792: WHERE
3793: codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
3794: AND codes.parent_classification_id = l_fc_id

Line 4014: FND_LANGUAGES L

4010: classification_id
4011: FROM
4012: ZX_FC_CODES_B codes,
4013: FND_LOOKUP_VALUES LV,
4014: FND_LANGUAGES L
4015: WHERE
4016: codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
4017: AND codes.parent_classification_id = nvl(l_fc_id,parent_classification_id)
4018: AND Codes.classification_code = LV.lookup_code

Line 4350: FND_LANGUAGES L

4346: fl.enabled_flag
4347: FROM
4348: ZX_FC_CODES_b Codes,
4349: FND_LOOKUP_VALUES FL,
4350: FND_LANGUAGES L
4351: WHERE
4352: Codes.classification_type_code = 'TRX_BUSINESS_CATEGORY'
4353: AND Codes.classification_code = FL.lookup_code
4354: AND Codes.RECORD_TYPE_CODE = 'MIGRATED'

Line 4969: FND_LANGUAGES L

4965: classification_id
4966: FROM
4967: ZX_FC_CODES_B Codes,
4968: FND_LOOKUP_VALUES LV,
4969: FND_LANGUAGES L
4970: WHERE
4971: Codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
4972: AND Codes.parent_classification_id is null
4973: AND Codes.classification_code = lv.lookup_code