[Home] [Help]
965: codes.classification_id
966: FROM
967: ZX_FC_CODES_b Codes,
968: FND_LOOKUP_VALUES FL,
969: FND_LANGUAGES L
970: WHERE Codes.classification_type_code = 'PRODUCT_CATEGORY'
971: AND Codes.parent_classification_id=l_fc_id
972: AND Codes.classification_code = FL.lookup_code
973: AND Codes.RECORD_TYPE_CODE = 'MIGRATED'
1281: l.language_code lang_code,
1282: codes.classification_id
1283: FROM ZX_FC_CODES_B Codes,
1284: JL_BR_AP_OPERATIONS JLBR,
1285: FND_LANGUAGES L
1286: WHERE Codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
1287: and Codes.parent_classification_id is null
1288: AND Codes.classification_code=JLBR.cfo_code
1289: AND Codes.RECORD_TYPE_CODE = 'MIGRATED'
1504: FROM
1505: ZX_FC_CODES_DENORM_B fc,
1506: ZX_FC_CODES_B Codes,
1507: JL_BR_AP_OPERATIONS ap_op,
1508: FND_LANGUAGES L,
1509: ZX_EVENT_CLASSES_VL event
1510: WHERE
1511: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
1512: and fc.classification_code='OPERATION FISCAL CODE'
1743: classification_id
1744: FROM
1745: ZX_FC_CODES_B Codes,
1746: FND_LOOKUP_VALUES LV,
1747: FND_LANGUAGES L
1748: WHERE Codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
1749: AND Codes.parent_classification_id = l_fc_id
1750: AND Codes.classification_code = LV.lookup_code
1751: AND Codes.RECORD_TYPE_CODE IN ('MIGRATED','SEEDED')
2230: 'SEEDED')
2231: select
2232: language_code lang_code, fc_codes.classification_id
2233: from
2234: fnd_languages l,
2235: zx_fc_codes_b fc_codes
2236: where
2237: l.installed_flag in ('I', 'B')
2238: and fc_codes.classification_type_code = p_classification_type_code
2473: Codes.classification_id
2474: FROM
2475: zx_fc_codes_b Codes,
2476: fnd_lookup_values fl,
2477: fnd_languages l
2478: WHERE
2479:
2480: codes.classification_type_code = p_classification_type_code
2481: and (codes.parent_classification_id = p_parent_fc_id or
2627: ZX_FC_CODES_DENORM_B fc,
2628: ZX_EVENT_CLASSES_VL event,
2629: FND_LOOKUP_VALUES FL,
2630: zx_fc_codes_b inserted_fc,
2631: FND_LANGUAGES L
2632: WHERE
2633: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2634: and fc.classification_code=p_classification_code
2635: and fc.language = userenv('LANG')
2756: ZX_FC_CODES_DENORM_B fc,
2757: ZX_FC_CODES_b Codes,
2758: ZX_EVENT_CLASSES_VL event,
2759: FND_LOOKUP_VALUES FL,
2760: FND_LANGUAGES L
2761: WHERE fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2762: and fc.classification_code = p_classification_code
2763: and fc.language = userenv('LANG')
2764: and fc.ancestor_code = p_tax_event_class_code
2902: FROM
2903: ZX_FC_CODES_B fcparent,
2904: ZX_FC_CODES_B fc,
2905: ZX_EVENT_CLASSES_B event,
2906: FND_LANGUAGES L
2907: WHERE
2908: fcparent.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2909: and fcparent.parent_classification_id is null
2910: and fcparent.classification_code=event.tax_event_class_code
3021: FROM
3022: ZX_FC_CODES_B fc,
3023: ZX_FC_CODES_B zx,
3024: ZX_EVENT_CLASSES_TL event,
3025: FND_LANGUAGES L
3026: WHERE
3027: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
3028: and fc.parent_classification_id is null
3029: and fc.classification_code=event.tax_event_class_code
3184: FND_GLOBAL.CONC_LOGIN_ID,
3185: language_code,
3186: userenv('LANG')
3187:
3188: FROM FND_LANGUAGES L,
3189: ZX_FC_TYPES_B Types
3190: where
3191: Types.classification_type_code = p_classification_type_code
3192: and Types.classification_type_categ_code = 'PRODUCT_FISCAL_CLASS'
3278: detFactors.DETERMINING_FACTOR_ID,
3279: L.LANGUAGE_CODE,
3280: userenv('LANG')
3281:
3282: FROM FND_LANGUAGES L,
3283: ZX_DETERMINING_FACTORS_B detFactors
3284: WHERE
3285: detFactors.DETERMINING_FACTOR_CODE = p_classification_type_code
3286: and detFactors.DETERMINING_FACTOR_CLASS_CODE = 'PRODUCT_FISCAL_CLASS'
3376: FND_GLOBAL.CONC_LOGIN_ID,
3377: language_code,
3378: userenv('LANG')
3379:
3380: FROM FND_LANGUAGES L,
3381: ZX_FC_TYPES_B Types
3382: where
3383: Types.classification_type_code = p_classification_type_code
3384: and Types.classification_type_categ_code = 'PARTY_FISCAL_CLASS'
3469: FND_GLOBAL.CONC_LOGIN_ID,
3470: detFactors.DETERMINING_FACTOR_ID,
3471: L.LANGUAGE_CODE,
3472: userenv('LANG')
3473: FROM FND_LANGUAGES L,
3474: ZX_DETERMINING_FACTORS_B detFactors
3475: WHERE detFactors.DETERMINING_FACTOR_CODE = p_classification_type_code
3476: and detFactors.DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS'
3477: --and detFactors.RECORD_TYPE_CODE = 'MIGRATED'
3589: FND_GLOBAL.CONC_REQUEST_ID,
3590: FND_GLOBAL.CONC_PROGRAM_ID,
3591: FND_GLOBAL.PROG_APPL_ID,
3592: SYSDATE
3593: FROM fnd_languages LV
3594: WHERE LV.INSTALLED_FLAG in ('I', 'B')
3595: AND NOT EXISTS (SELECT 1 FROM HZ_CLASS_CODE_DENORM
3596: WHERE CLASS_CATEGORY = 'VENDOR TYPE'
3597: AND CONCAT_CLASS_CODE = 'EMPLOYEE');
3985: FROM
3986: ZX_FC_CODES_B Codes,
3987: FND_FLEX_VALUES V,
3988: fnd_flex_value_sets vs,
3989: FND_LANGUAGES L
3990:
3991: WHERE
3992: codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
3993: AND codes.parent_classification_id = l_fc_id
4211: classification_id
4212: FROM
4213: ZX_FC_CODES_B codes,
4214: FND_LOOKUP_VALUES LV,
4215: FND_LANGUAGES L
4216: WHERE
4217: codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
4218: AND codes.parent_classification_id = nvl(l_fc_id,parent_classification_id)
4219: AND Codes.classification_code = LV.lookup_code
4559: ORDER BY nvl(start_date_active, to_date('01/01/1951','DD/MM/YYYY'))) AS count_num
4560: FROM
4561: ZX_FC_CODES_b Codes,
4562: FND_LOOKUP_VALUES FL,
4563: FND_LANGUAGES L
4564: WHERE
4565: Codes.classification_type_code = 'TRX_BUSINESS_CATEGORY'
4566: AND Codes.classification_code = FL.lookup_code
4567: AND Codes.RECORD_TYPE_CODE = 'MIGRATED'
5189: classification_id
5190: FROM
5191: ZX_FC_CODES_B Codes,
5192: FND_LOOKUP_VALUES LV,
5193: FND_LANGUAGES L
5194: WHERE
5195: Codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
5196: AND Codes.parent_classification_id is null
5197: AND Codes.classification_code = lv.lookup_code