APPS.EDW_OE_SLCHNL_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='SALES_CHANNEL'
21: AND fnd.language = userenv('LANG')
22: AND fnd.view_application_id = 660
23: AND fnd.security_group_id = 0

Line 63: FROM fnd_lookup_values

59: nvl(avg(nvl(vsize(start_date_active),0)),0),
60: nvl(avg(nvl(vsize(end_date_active),0)),0),
61: nvl(avg(nvl(vsize(creation_date),0)),0),
62: nvl(avg(nvl(vsize(last_update_date),0)),0)
63: FROM fnd_lookup_values
64: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
65:
66: BEGIN
67: