APPS.MSD_SCE_PUBLISH_FORECAST_PKG dependencies on FND_LOOKUP_VALUES_VL

Line 188: from fnd_lookup_values_vl

184: p_horizon_end := nvl(l_horizon_start, sysdate)+nvl(p_horizon_days, 365);
185:
186: select meaning
187: into l_order_type
188: from fnd_lookup_values_vl
189: where lookup_type = 'MSC_X_ORDER_TYPE'
190: and lookup_code = p_order_type;
191:
192: if p_org_code is not null then

Line 507: from fnd_lookup_values_vl

503: for j in numFirst..numLast loop
504:
505: select meaning
506: into l_bkt_desc
507: from fnd_lookup_values_vl
508: where lookup_type = 'MSC_X_BUCKET_TYPE' and
509: lookup_code = decode(t_bkt_type(j), 9, 1, 1, 2, 3);
510:
511: t_bkt_type_desc(j) := l_bkt_desc;