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 572: FROM fnd_lookup_values fnd

568: SYSDATE,
569: fnd_global.user_id,
570: SYSDATE,
571: FND_GLOBAL.CONC_LOGIN_ID
572: FROM fnd_lookup_values fnd
573: WHERE lookup_type = l_lookup_type
574: AND language=userenv('lang') -- Bug 6441455
575: AND enabled_flag = 'Y'
576: AND NOT EXISTS

Line 600: FROM fnd_lookup_values fnd, mtl_categories_b mtl

596: fnd_global.user_id,
597: SYSDATE,
598: fnd_global.user_id,
599: FND_GLOBAL.CONC_LOGIN_ID
600: FROM fnd_lookup_values fnd, mtl_categories_b mtl
601: WHERE lookup_type = l_lookup_type
602: AND FND.lookup_code = mtl.segment1
603: AND NOT EXISTS
604: (select 'Y' FROM mtl_categories_tl m

Line 649: l_classification_name fnd_lookup_values.meaning%type;

645: l_Item_id Number;
646: l_Item_organization_id Number;
647: l_record_type zx_Fc_types_b.record_type_code%type;
648:
649: l_classification_name fnd_lookup_values.meaning%type;
650:
651: l_lookup_code fnd_lookup_values.lookup_code%type;
652: l_meaning fnd_lookup_values.meaning%type;
653: l_language fnd_lookup_values.language%type;

Line 651: l_lookup_code fnd_lookup_values.lookup_code%type;

647: l_record_type zx_Fc_types_b.record_type_code%type;
648:
649: l_classification_name fnd_lookup_values.meaning%type;
650:
651: l_lookup_code fnd_lookup_values.lookup_code%type;
652: l_meaning fnd_lookup_values.meaning%type;
653: l_language fnd_lookup_values.language%type;
654: l_start_date_active fnd_lookup_values.start_date_active%type;
655: l_end_date_active fnd_lookup_values.end_date_active%type;

Line 652: l_meaning fnd_lookup_values.meaning%type;

648:
649: l_classification_name fnd_lookup_values.meaning%type;
650:
651: l_lookup_code fnd_lookup_values.lookup_code%type;
652: l_meaning fnd_lookup_values.meaning%type;
653: l_language fnd_lookup_values.language%type;
654: l_start_date_active fnd_lookup_values.start_date_active%type;
655: l_end_date_active fnd_lookup_values.end_date_active%type;
656: l_source_lang fnd_lookup_values.source_lang%type;

Line 653: l_language fnd_lookup_values.language%type;

649: l_classification_name fnd_lookup_values.meaning%type;
650:
651: l_lookup_code fnd_lookup_values.lookup_code%type;
652: l_meaning fnd_lookup_values.meaning%type;
653: l_language fnd_lookup_values.language%type;
654: l_start_date_active fnd_lookup_values.start_date_active%type;
655: l_end_date_active fnd_lookup_values.end_date_active%type;
656: l_source_lang fnd_lookup_values.source_lang%type;
657: i integer:=0;

Line 654: l_start_date_active fnd_lookup_values.start_date_active%type;

650:
651: l_lookup_code fnd_lookup_values.lookup_code%type;
652: l_meaning fnd_lookup_values.meaning%type;
653: l_language fnd_lookup_values.language%type;
654: l_start_date_active fnd_lookup_values.start_date_active%type;
655: l_end_date_active fnd_lookup_values.end_date_active%type;
656: l_source_lang fnd_lookup_values.source_lang%type;
657: i integer:=0;
658: l_fc_id zx_fc_codes_b.classification_id%type;

Line 655: l_end_date_active fnd_lookup_values.end_date_active%type;

651: l_lookup_code fnd_lookup_values.lookup_code%type;
652: l_meaning fnd_lookup_values.meaning%type;
653: l_language fnd_lookup_values.language%type;
654: l_start_date_active fnd_lookup_values.start_date_active%type;
655: l_end_date_active fnd_lookup_values.end_date_active%type;
656: l_source_lang fnd_lookup_values.source_lang%type;
657: i integer:=0;
658: l_fc_id zx_fc_codes_b.classification_id%type;
659: l_return_status varchar2(200);

Line 656: l_source_lang fnd_lookup_values.source_lang%type;

652: l_meaning fnd_lookup_values.meaning%type;
653: l_language fnd_lookup_values.language%type;
654: l_start_date_active fnd_lookup_values.start_date_active%type;
655: l_end_date_active fnd_lookup_values.end_date_active%type;
656: l_source_lang fnd_lookup_values.source_lang%type;
657: i integer:=0;
658: l_fc_id zx_fc_codes_b.classification_id%type;
659: l_return_status varchar2(200);
660: l_errorcode number;

Line 956: FND_LOOKUP_VALUES FL,

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

Line 1599: FROM FND_LOOKUP_VALUES lookups

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

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
1749: Codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
1750: AND Codes.parent_classification_id = l_fc_id

Line 2276: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,

2272: /*THIS IS THE COMMON PROCEDURE USED TO INSERT VALUES BASED UPON THE LOOKUP TYPE */
2273:
2274: PROCEDURE FC_CODE_FROM_FND_LOOKUP(
2275: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
2276: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
2277: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2278: p_parent_fc_id IN ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
2279: p_ancestor_code IN ZX_FC_CODES_DENORM_B.ANCESTOR_CODE%TYPE,
2280: p_ancestor_name IN ZX_FC_CODES_DENORM_B.ANCESTOR_NAME%TYPE,

Line 2334: FROM FND_LOOKUP_VALUES lookups

2330: fnd_global.user_id,
2331: SYSDATE,
2332: FND_GLOBAL.CONC_LOGIN_ID,
2333: 1
2334: FROM FND_LOOKUP_VALUES lookups
2335: WHERE
2336: lookups.lookup_type=p_lookup_type
2337: AND LANGUAGE = userenv('LANG')
2338: AND lookups.enabled_flag = 'Y'

Line 2483: fnd_lookup_values fl,

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

Line 2517: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,

2513: PROCEDURE FC_CODE_GDF_INSERT(
2514: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2515: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2516: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2517: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
2518: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE,
2519: p_record_type_code IN ZX_FC_CODES_B.RECORD_TYPE_CODE%TYPE
2520: )
2521:

Line 2589: FND_LOOKUP_VALUES FL

2585: 1
2586: FROM
2587: ZX_FC_CODES_DENORM_B fc,
2588: ZX_EVENT_CLASSES_VL event,
2589: FND_LOOKUP_VALUES FL
2590: WHERE
2591: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2592: and fc.classification_code=p_classification_code
2593: and fc.language = userenv('LANG')

Line 2750: FND_LOOKUP_VALUES FL,

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

Line 4013: FND_LOOKUP_VALUES LV,

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

Line 4349: FND_LOOKUP_VALUES FL,

4345: Codes.parent_classification_id,
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

Line 4608: l_classification_name fnd_lookup_values.meaning%type;

4604: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;
4605: l_Item_id Number;
4606: l_Item_organization_id Number;
4607: l_record_type zx_Fc_types_b.record_type_code%type;
4608: l_classification_name fnd_lookup_values.meaning%type;
4609: l_lookup_code fnd_lookup_values.lookup_code%type;
4610: l_meaning fnd_lookup_values.meaning%type;
4611: l_language fnd_lookup_values.language%type;
4612: l_start_date_active fnd_lookup_values.start_date_active%type;

Line 4609: l_lookup_code fnd_lookup_values.lookup_code%type;

4605: l_Item_id Number;
4606: l_Item_organization_id Number;
4607: l_record_type zx_Fc_types_b.record_type_code%type;
4608: l_classification_name fnd_lookup_values.meaning%type;
4609: l_lookup_code fnd_lookup_values.lookup_code%type;
4610: l_meaning fnd_lookup_values.meaning%type;
4611: l_language fnd_lookup_values.language%type;
4612: l_start_date_active fnd_lookup_values.start_date_active%type;
4613: l_end_date_active fnd_lookup_values.end_date_active%type;

Line 4610: l_meaning fnd_lookup_values.meaning%type;

4606: l_Item_organization_id Number;
4607: l_record_type zx_Fc_types_b.record_type_code%type;
4608: l_classification_name fnd_lookup_values.meaning%type;
4609: l_lookup_code fnd_lookup_values.lookup_code%type;
4610: l_meaning fnd_lookup_values.meaning%type;
4611: l_language fnd_lookup_values.language%type;
4612: l_start_date_active fnd_lookup_values.start_date_active%type;
4613: l_end_date_active fnd_lookup_values.end_date_active%type;
4614: l_source_lang fnd_lookup_values.source_lang%type;

Line 4611: l_language fnd_lookup_values.language%type;

4607: l_record_type zx_Fc_types_b.record_type_code%type;
4608: l_classification_name fnd_lookup_values.meaning%type;
4609: l_lookup_code fnd_lookup_values.lookup_code%type;
4610: l_meaning fnd_lookup_values.meaning%type;
4611: l_language fnd_lookup_values.language%type;
4612: l_start_date_active fnd_lookup_values.start_date_active%type;
4613: l_end_date_active fnd_lookup_values.end_date_active%type;
4614: l_source_lang fnd_lookup_values.source_lang%type;
4615: l_fc_id zx_fc_codes_b.classification_id%type;

Line 4612: l_start_date_active fnd_lookup_values.start_date_active%type;

4608: l_classification_name fnd_lookup_values.meaning%type;
4609: l_lookup_code fnd_lookup_values.lookup_code%type;
4610: l_meaning fnd_lookup_values.meaning%type;
4611: l_language fnd_lookup_values.language%type;
4612: l_start_date_active fnd_lookup_values.start_date_active%type;
4613: l_end_date_active fnd_lookup_values.end_date_active%type;
4614: l_source_lang fnd_lookup_values.source_lang%type;
4615: l_fc_id zx_fc_codes_b.classification_id%type;
4616: l_return_status varchar2(200);

Line 4613: l_end_date_active fnd_lookup_values.end_date_active%type;

4609: l_lookup_code fnd_lookup_values.lookup_code%type;
4610: l_meaning fnd_lookup_values.meaning%type;
4611: l_language fnd_lookup_values.language%type;
4612: l_start_date_active fnd_lookup_values.start_date_active%type;
4613: l_end_date_active fnd_lookup_values.end_date_active%type;
4614: l_source_lang fnd_lookup_values.source_lang%type;
4615: l_fc_id zx_fc_codes_b.classification_id%type;
4616: l_return_status varchar2(200);
4617: -- l_errorcode number;

Line 4614: l_source_lang fnd_lookup_values.source_lang%type;

4610: l_meaning fnd_lookup_values.meaning%type;
4611: l_language fnd_lookup_values.language%type;
4612: l_start_date_active fnd_lookup_values.start_date_active%type;
4613: l_end_date_active fnd_lookup_values.end_date_active%type;
4614: l_source_lang fnd_lookup_values.source_lang%type;
4615: l_fc_id zx_fc_codes_b.classification_id%type;
4616: l_return_status varchar2(200);
4617: -- l_errorcode number;
4618: -- l_msg_count number;

Line 4824: FROM FND_LOOKUP_VALUES lookups

4820: fnd_global.user_id,
4821: SYSDATE,
4822: FND_GLOBAL.CONC_LOGIN_ID,
4823: 1
4824: FROM FND_LOOKUP_VALUES lookups
4825: WHERE lookups.lookup_type='AR_TAX_TRX_BUSINESS_CATEGORY'
4826: AND LANGUAGE = userenv('LANG')
4827: AND NOT EXISTS
4828: -- this condition makes sure we dont duplicate data

Line 4968: FND_LOOKUP_VALUES LV,

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