DBA Data[Home] [Help]

APPS.EDW_MRP_DM_CLS_M_SIZE dependencies on FND_LOOKUP_VALUES

Line 19: FROM fnd_lookup_values fnd

15: BEGIN
16:
17: SELECT count(*)
18: INTO p_num_rows
19: FROM fnd_lookup_values fnd
20: WHERE fnd.lookup_type='DEMAND_CLASS'
21: AND fnd.language = userenv('LANG')
22: AND fnd.view_application_id = 3
23: AND fnd.security_group_id = 0

Line 54: FROM fnd_lookup_values

50: CURSOR c_1 IS
51: SELECT nvl(avg(nvl(vsize(lookup_code),0)),0),
52: nvl(avg(nvl(vsize(description),0)),0),
53: nvl(avg(nvl(vsize(meaning),0)),0)
54: FROM fnd_lookup_values
55: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
56:
57: BEGIN
58: