eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_FC_MIGRATE_PKG dependencies on FND_LOOKUP_VALUES

Line 591: FROM fnd_lookup_values fnd

587: SYSDATE,
588: fnd_global.user_id,
589: SYSDATE,
590: FND_GLOBAL.CONC_LOGIN_ID
591: FROM fnd_lookup_values fnd
592: WHERE lookup_type = l_lookup_type
593: AND language=userenv('lang') -- Bug 6441455
594: AND enabled_flag = 'Y'
595: AND NOT EXISTS

Line 621: FROM fnd_lookup_values fnd, mtl_categories_b mtl

617: fnd_global.user_id,
618: SYSDATE,
619: fnd_global.user_id,
620: FND_GLOBAL.CONC_LOGIN_ID
621: FROM fnd_lookup_values fnd, mtl_categories_b mtl
622: WHERE lookup_type = l_lookup_type
623: AND FND.lookup_code = mtl.segment1
624: AND NOT EXISTS
625: (select 'Y' FROM mtl_categories_tl m

Line 664: l_classification_name fnd_lookup_values.meaning%type;

660: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;
661: l_Item_id Number;
662: l_Item_organization_id Number;
663: l_record_type zx_Fc_types_b.record_type_code%type;
664: l_classification_name fnd_lookup_values.meaning%type;
665: l_lookup_code fnd_lookup_values.lookup_code%type;
666: l_meaning fnd_lookup_values.meaning%type;
667: l_language fnd_lookup_values.language%type;
668: l_start_date_active fnd_lookup_values.start_date_active%type;

Line 665: l_lookup_code fnd_lookup_values.lookup_code%type;

661: l_Item_id Number;
662: l_Item_organization_id Number;
663: l_record_type zx_Fc_types_b.record_type_code%type;
664: l_classification_name fnd_lookup_values.meaning%type;
665: l_lookup_code fnd_lookup_values.lookup_code%type;
666: l_meaning fnd_lookup_values.meaning%type;
667: l_language fnd_lookup_values.language%type;
668: l_start_date_active fnd_lookup_values.start_date_active%type;
669: l_end_date_active fnd_lookup_values.end_date_active%type;

Line 666: l_meaning fnd_lookup_values.meaning%type;

662: l_Item_organization_id Number;
663: l_record_type zx_Fc_types_b.record_type_code%type;
664: l_classification_name fnd_lookup_values.meaning%type;
665: l_lookup_code fnd_lookup_values.lookup_code%type;
666: l_meaning fnd_lookup_values.meaning%type;
667: l_language fnd_lookup_values.language%type;
668: l_start_date_active fnd_lookup_values.start_date_active%type;
669: l_end_date_active fnd_lookup_values.end_date_active%type;
670: l_source_lang fnd_lookup_values.source_lang%type;

Line 667: l_language fnd_lookup_values.language%type;

663: l_record_type zx_Fc_types_b.record_type_code%type;
664: l_classification_name fnd_lookup_values.meaning%type;
665: l_lookup_code fnd_lookup_values.lookup_code%type;
666: l_meaning fnd_lookup_values.meaning%type;
667: l_language fnd_lookup_values.language%type;
668: l_start_date_active fnd_lookup_values.start_date_active%type;
669: l_end_date_active fnd_lookup_values.end_date_active%type;
670: l_source_lang fnd_lookup_values.source_lang%type;
671: i integer := 0;

Line 668: l_start_date_active fnd_lookup_values.start_date_active%type;

664: l_classification_name fnd_lookup_values.meaning%type;
665: l_lookup_code fnd_lookup_values.lookup_code%type;
666: l_meaning fnd_lookup_values.meaning%type;
667: l_language fnd_lookup_values.language%type;
668: l_start_date_active fnd_lookup_values.start_date_active%type;
669: l_end_date_active fnd_lookup_values.end_date_active%type;
670: l_source_lang fnd_lookup_values.source_lang%type;
671: i integer := 0;
672: l_fc_id zx_fc_codes_b.classification_id%type;

Line 669: l_end_date_active fnd_lookup_values.end_date_active%type;

665: l_lookup_code fnd_lookup_values.lookup_code%type;
666: l_meaning fnd_lookup_values.meaning%type;
667: l_language fnd_lookup_values.language%type;
668: l_start_date_active fnd_lookup_values.start_date_active%type;
669: l_end_date_active fnd_lookup_values.end_date_active%type;
670: l_source_lang fnd_lookup_values.source_lang%type;
671: i integer := 0;
672: l_fc_id zx_fc_codes_b.classification_id%type;
673: l_return_status varchar2(200);

Line 670: l_source_lang fnd_lookup_values.source_lang%type;

666: l_meaning fnd_lookup_values.meaning%type;
667: l_language fnd_lookup_values.language%type;
668: l_start_date_active fnd_lookup_values.start_date_active%type;
669: l_end_date_active fnd_lookup_values.end_date_active%type;
670: l_source_lang fnd_lookup_values.source_lang%type;
671: i integer := 0;
672: l_fc_id zx_fc_codes_b.classification_id%type;
673: l_return_status varchar2(200);
674: l_errorcode number;

Line 968: FND_LOOKUP_VALUES FL,

964: FL.SOURCE_LANG SOURCE_LANGUAGE,
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

Line 1600: FROM FND_LOOKUP_VALUES lookups

1596: SYSDATE,
1597: FND_GLOBAL.CONC_LOGIN_ID,
1598: 1
1599:
1600: FROM FND_LOOKUP_VALUES lookups
1601: WHERE lookups.lookup_type='JATW_GUI_TYPE'
1602: AND LANGUAGE = userenv('LANG')
1603: AND NOT EXISTS -- this condition makes sure we dont duplicate data
1604: (select NULL from ZX_FC_CODES_B Codes where

Line 1746: FND_LOOKUP_VALUES LV,

1742: lv.enabled_flag,
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

Line 2269: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,

2265: /*THIS IS THE COMMON PROCEDURE USED TO INSERT VALUES BASED UPON THE LOOKUP TYPE */
2266:
2267: PROCEDURE FC_CODE_FROM_FND_LOOKUP(
2268: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
2269: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
2270: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2271: p_parent_fc_id IN ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
2272: p_ancestor_code IN ZX_FC_CODES_DENORM_B.ANCESTOR_CODE%TYPE,
2273: p_ancestor_name IN ZX_FC_CODES_DENORM_B.ANCESTOR_NAME%TYPE,

Line 2327: FROM FND_LOOKUP_VALUES lookups

2323: fnd_global.user_id,
2324: SYSDATE,
2325: FND_GLOBAL.CONC_LOGIN_ID,
2326: 1
2327: FROM FND_LOOKUP_VALUES lookups
2328: WHERE
2329: lookups.lookup_type=p_lookup_type
2330: AND LANGUAGE = userenv('LANG')
2331: AND lookups.enabled_flag = 'Y'

Line 2476: fnd_lookup_values fl,

2472: fl.enabled_flag,
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

Line 2510: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,

2506: PROCEDURE FC_CODE_GDF_INSERT(
2507: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2508: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2509: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2510: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
2511: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE,
2512: p_record_type_code IN ZX_FC_CODES_B.RECORD_TYPE_CODE%TYPE
2513: )
2514:

Line 2582: FND_LOOKUP_VALUES FL

2578: 1
2579: FROM
2580: ZX_FC_CODES_DENORM_B fc,
2581: ZX_EVENT_CLASSES_VL event,
2582: FND_LOOKUP_VALUES FL
2583: WHERE
2584: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2585: and fc.classification_code=p_classification_code
2586: and fc.language = userenv('LANG')

Line 2629: FND_LOOKUP_VALUES FL,

2625: SOURCE_LANG
2626: FROM
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'

Line 2759: FND_LOOKUP_VALUES FL,

2755: FROM
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')

Line 4214: FND_LOOKUP_VALUES LV,

4210: lv.enabled_flag,
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)

Line 4562: FND_LOOKUP_VALUES FL,

4558: OVER (PARTITION BY lookup_code, language
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

Line 4832: l_classification_name fnd_lookup_values.meaning%type;

4828: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;
4829: l_Item_id Number;
4830: l_Item_organization_id Number;
4831: l_record_type zx_Fc_types_b.record_type_code%type;
4832: l_classification_name fnd_lookup_values.meaning%type;
4833: l_lookup_code fnd_lookup_values.lookup_code%type;
4834: l_meaning fnd_lookup_values.meaning%type;
4835: l_language fnd_lookup_values.language%type;
4836: l_start_date_active fnd_lookup_values.start_date_active%type;

Line 4833: l_lookup_code fnd_lookup_values.lookup_code%type;

4829: l_Item_id Number;
4830: l_Item_organization_id Number;
4831: l_record_type zx_Fc_types_b.record_type_code%type;
4832: l_classification_name fnd_lookup_values.meaning%type;
4833: l_lookup_code fnd_lookup_values.lookup_code%type;
4834: l_meaning fnd_lookup_values.meaning%type;
4835: l_language fnd_lookup_values.language%type;
4836: l_start_date_active fnd_lookup_values.start_date_active%type;
4837: l_end_date_active fnd_lookup_values.end_date_active%type;

Line 4834: l_meaning fnd_lookup_values.meaning%type;

4830: l_Item_organization_id Number;
4831: l_record_type zx_Fc_types_b.record_type_code%type;
4832: l_classification_name fnd_lookup_values.meaning%type;
4833: l_lookup_code fnd_lookup_values.lookup_code%type;
4834: l_meaning fnd_lookup_values.meaning%type;
4835: l_language fnd_lookup_values.language%type;
4836: l_start_date_active fnd_lookup_values.start_date_active%type;
4837: l_end_date_active fnd_lookup_values.end_date_active%type;
4838: l_source_lang fnd_lookup_values.source_lang%type;

Line 4835: l_language fnd_lookup_values.language%type;

4831: l_record_type zx_Fc_types_b.record_type_code%type;
4832: l_classification_name fnd_lookup_values.meaning%type;
4833: l_lookup_code fnd_lookup_values.lookup_code%type;
4834: l_meaning fnd_lookup_values.meaning%type;
4835: l_language fnd_lookup_values.language%type;
4836: l_start_date_active fnd_lookup_values.start_date_active%type;
4837: l_end_date_active fnd_lookup_values.end_date_active%type;
4838: l_source_lang fnd_lookup_values.source_lang%type;
4839: l_fc_id zx_fc_codes_b.classification_id%type;

Line 4836: l_start_date_active fnd_lookup_values.start_date_active%type;

4832: l_classification_name fnd_lookup_values.meaning%type;
4833: l_lookup_code fnd_lookup_values.lookup_code%type;
4834: l_meaning fnd_lookup_values.meaning%type;
4835: l_language fnd_lookup_values.language%type;
4836: l_start_date_active fnd_lookup_values.start_date_active%type;
4837: l_end_date_active fnd_lookup_values.end_date_active%type;
4838: l_source_lang fnd_lookup_values.source_lang%type;
4839: l_fc_id zx_fc_codes_b.classification_id%type;
4840: l_return_status varchar2(200);

Line 4837: l_end_date_active fnd_lookup_values.end_date_active%type;

4833: l_lookup_code fnd_lookup_values.lookup_code%type;
4834: l_meaning fnd_lookup_values.meaning%type;
4835: l_language fnd_lookup_values.language%type;
4836: l_start_date_active fnd_lookup_values.start_date_active%type;
4837: l_end_date_active fnd_lookup_values.end_date_active%type;
4838: l_source_lang fnd_lookup_values.source_lang%type;
4839: l_fc_id zx_fc_codes_b.classification_id%type;
4840: l_return_status varchar2(200);
4841: -- l_errorcode number;

Line 4838: l_source_lang fnd_lookup_values.source_lang%type;

4834: l_meaning fnd_lookup_values.meaning%type;
4835: l_language fnd_lookup_values.language%type;
4836: l_start_date_active fnd_lookup_values.start_date_active%type;
4837: l_end_date_active fnd_lookup_values.end_date_active%type;
4838: l_source_lang fnd_lookup_values.source_lang%type;
4839: l_fc_id zx_fc_codes_b.classification_id%type;
4840: l_return_status varchar2(200);
4841: -- l_errorcode number;
4842: -- l_msg_count number;

Line 5048: FROM FND_LOOKUP_VALUES lookups

5044: fnd_global.user_id,
5045: SYSDATE,
5046: FND_GLOBAL.CONC_LOGIN_ID,
5047: 1
5048: FROM FND_LOOKUP_VALUES lookups
5049: WHERE lookups.lookup_type='AR_TAX_TRX_BUSINESS_CATEGORY'
5050: AND LANGUAGE = userenv('LANG')
5051: AND NOT EXISTS
5052: -- this condition makes sure we dont duplicate data

Line 5192: FND_LOOKUP_VALUES LV,

5188: lv.enabled_flag,
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