APPS.MTH_UTIL_PKG dependencies on FND_LOOKUP_VALUES

Line 817: SELECT lookup_code INTO v_lookup_code FROM FND_LOOKUP_VALUES WHERE

813: Function mth_ua_get_val RETURN NUMBER IS
814: v_lookup_code varchar2(30);
815: BEGIN
816: --NULL
817: SELECT lookup_code INTO v_lookup_code FROM FND_LOOKUP_VALUES WHERE
818: lookup_type='MTH_UNASSIGNED_L' AND language=userenv('LANG');
819:
820: RETURN(to_number(v_lookup_code));
821:

Line 849: SELECT meaning INTO v_lookup_meaning FROM FND_LOOKUP_VALUES WHERE

845: Function mth_ua_get_meaning RETURN VARCHAR2 IS
846: v_lookup_meaning varchar2(80);
847: BEGIN
848: --NULL
849: SELECT meaning INTO v_lookup_meaning FROM FND_LOOKUP_VALUES WHERE
850: lookup_type='MTH_UNASSIGNED_L' AND language=userenv('LANG');
851:
852: RETURN(v_lookup_meaning);
853:

Line 4247: ( SELECT meaning FROM fnd_lookup_values fl WHERE fl.LOOKUP_TYPE ='MTH_SHIFT_TYPE'

4243: SET stg.err_code = stg.err_code || 'SFT '
4244: WHERE stg.SHIFT_TYPE IS NOT NULL
4245: AND EXISTS (SELECT * FROM (SELECT stg.SHIFT_TYPE SHIFT_TYPE ,fl.meaning
4246: FROM mth_workday_shifts_stg stg,
4247: ( SELECT meaning FROM fnd_lookup_values fl WHERE fl.LOOKUP_TYPE ='MTH_SHIFT_TYPE'
4248:
4249: AND fl.LANGUAGE = USERENV('LANG')
4250: AND fl.ENABLED_FLAG ='Y' ) fl
4251: WHERE stg.SHIFT_TYPE = fl.meaning(+)

Line 4265: ( SELECT meaning FROM fnd_lookup_values fl WHERE fl.LOOKUP_TYPE ='MTH_GRAVEYARD_SHIFT_TYPE'

4261: SET stg.err_code = stg.err_code || 'GRA '
4262: WHERE stg.graveyard_shift IS NOT NULL
4263: AND EXISTS (SELECT * FROM (SELECT fl.meaning, stg.graveyard_shift
4264: FROM mth_workday_shifts_stg stg,
4265: ( SELECT meaning FROM fnd_lookup_values fl WHERE fl.LOOKUP_TYPE ='MTH_GRAVEYARD_SHIFT_TYPE'
4266:
4267: AND fl.LANGUAGE = USERENV('LANG')
4268: AND fl.ENABLED_FLAG ='Y' )fl
4269: WHERE stg.graveyard_shift = fl.meaning (+)

Line 4507: MTH_WORKDAY_SHIFTS_STG STG ,MTH_SYSTEMS_SETUP SP,MTH_PLANTS_D PD,MTH_ORGANIZATIONS_L MOL,FND_LOOKUP_VALUES FL1,FND_LOOKUP_VALUES FL2

4503: STG.SOURCE_ORG_CODE,
4504: Decode(STG.SHIFT_TYPE,NULL,'PROD-SHIFT',FL2.LOOKUP_CODE),
4505: DECODE(STG.GRAVEYARD_SHIFT,NULL,NULL,FL1.LOOKUP_CODE)
4506: FROM
4507: MTH_WORKDAY_SHIFTS_STG STG ,MTH_SYSTEMS_SETUP SP,MTH_PLANTS_D PD,MTH_ORGANIZATIONS_L MOL,FND_LOOKUP_VALUES FL1,FND_LOOKUP_VALUES FL2
4508: WHERE NVL ( STG.SYSTEM_FK , MTH_UTIL_PKG.MTH_UA_GET_VAL ) = SP.SYSTEM_PK
4509: AND NVL(PD.TO_DATE,SYSDATE) >= TRUNC(SYSDATE)
4510: AND PD.PLANT_PK_KEY = MOL.PLANT_FK_KEY
4511: AND MOL.SYSTEM_FK_KEY = SP.SYSTEM_PK_KEY

Line 4692: FROM FND_LOOKUP_Values

4688: IS
4689:
4690: CURSOR c_tabs (p_lookup_type IN varchar2) IS
4691: SELECT LOOKUP_CODE
4692: FROM FND_LOOKUP_Values
4693: WHERE LOOKUP_TYPE=p_lookup_type
4694: AND DESCRIPTION = 'TABLE'
4695: AND LANGUAGE = userenv('LANG');
4696:

Line 4699: FROM FND_LOOKUP_Values

4695: AND LANGUAGE = userenv('LANG');
4696:
4697: CURSOR c_seqs (p_lookup_type IN varchar2) IS
4698: SELECT LOOKUP_CODE
4699: FROM FND_LOOKUP_Values
4700: WHERE LOOKUP_TYPE=p_lookup_type
4701: AND DESCRIPTION = 'SEQUENCE'
4702: AND LANGUAGE = userenv('LANG');
4703:

Line 4706: FROM FND_LOOKUP_Values

4702: AND LANGUAGE = userenv('LANG');
4703:
4704: CURSOR c_mvs (p_lookup_type IN varchar2) IS
4705: SELECT LOOKUP_CODE
4706: FROM FND_LOOKUP_Values
4707: WHERE LOOKUP_TYPE=p_lookup_type
4708: AND DESCRIPTION = 'MVIEW'
4709: AND LANGUAGE = userenv('LANG');
4710:

Line 4756: FROM FND_LOOKUP_VALUES lv

4752:
4753: DELETE FROM MTH_RUN_LOG rl
4754: WHERE exists (
4755: SELECT 1
4756: FROM FND_LOOKUP_VALUES lv
4757: WHERE lv.LOOKUP_TYPE=v_lookup_type
4758: AND lv.DESCRIPTION = 'TABLE'
4759: AND lv.LANGUAGE = userenv('LANG')
4760: AND lv.LOOKUP_CODE like rl.FACT_TABLE || '%');