DBA Data[Home] [Help]

APPS.MSC_NETCHANGE_PKG dependencies on MFG_LOOKUPS

Line 154: from mfg_lookups

150: if p_options_flag = 1 then
151:
152: select substr(meaning,1,10)
153: into g_yes
154: from mfg_lookups
155: where lookup_type = 'SYS_YES_NO'
156: and lookup_code = 1;
157:
158: select substr(meaning,1,10)

Line 160: from mfg_lookups

156: and lookup_code = 1;
157:
158: select substr(meaning,1,10)
159: into g_no
160: from mfg_lookups
161: where lookup_type = 'SYS_YES_NO'
162: and lookup_code = 2;
163:
164: select substr(meaning,1,35)

Line 166: from mfg_lookups

162: and lookup_code = 2;
163:
164: select substr(meaning,1,35)
165: bulk collect into g_misc
166: from mfg_lookups
167: where lookup_type = 'MSC_NC_MISC_PROMPTS'
168: order by lookup_code;
169:
170: select msc_form_query_s.nextval

Line 301: mfg_lookups ml,

297: 1,g_misc(2), -- 'Project',
298: 2, g_misc(3), --'Project-Task',
299: 3, g_misc(4)) --'None')
300: from msc_plans mp,
301: mfg_lookups ml,
302: msc_assignment_sets mas
303: where mp.plan_id = p_plan_id
304: and ml.lookup_type = 'MRP_PLAN_TYPE'
305: and ml.lookup_code = mp.curr_plan_type