DBA Data[Home] [Help]

APPS.MSC_PLAN_RELEASE dependencies on DUAL

Line 82: FROM dual;

78: fnd_message.set_name('MSC', 'MSC_COLL_RUN_WARN');
79: p_return_msg := fnd_message.get;
80: SELECT msc_form_query_s.nextval
81: INTO l_query_id
82: FROM dual;
83:
84: /*
85: INSERT INTO msc_form_query(
86: query_id,

Line 243: select 1 from dual

239: -- md.last_updated_by)
240: -- and md.status = 0
241: -- and md.applied =2;
242:
243: select 1 from dual
244: where exists ( SELECT /*+ first_rows */ 1
245: FROM msc_demands md
246: where md.plan_id = p_plan_id
247: and md.release_errors is null

Line 435: FROM dual;

431: -- window and go there.
432: -- ----------------------------------------
433: SELECT msc_form_query_s.nextval
434: INTO l_query_id
435: FROM dual;
436:
437:
438: if v_other_count > 0 then
439: FOR i in 1..loaded_jobs.COUNT LOOP

Line 694: FROM dual;

690:
691: --- get the unique number identifying the current session
692: SELECT MRP.mrp_atp_schedule_temp_s.nextval
693: INTO l_session_id
694: FROM dual;
695:
696: -- Call ATP method to get the intransit lead time value in
697: -- the out parameter x_intransit_lead_time
698: MSC_ATP_PROC.ATP_Intransit_LT(