DBA Data[Home] [Help]

APPS.MSC_X_VMI_UTIL_NEW dependencies on DUAL

Line 2214: SELECT msc_x_hz_ui_query_id_s.nextval INTO l_query_id FROM Dual;

2210: l_debug_flag BOOLEAN := FALSE;
2211: BEGIN
2212: IF l_debug_flag = FALSE THEN
2213: -- get the query id first
2214: SELECT msc_x_hz_ui_query_id_s.nextval INTO l_query_id FROM Dual;
2215: FOR l_current_record IN p_graph.FIRST..p_graph.LAST LOOP
2216: INSERT INTO MSC_VMI_GRAPH
2217: (query_id, graph_date, onhand, order_forecast, req, po, asn, receipt,
2218: projected_onhand, supply_within_lead_time,

Line 2307: from dual;

2303: BEGIN
2304:
2305: select mrp_atp_schedule_temp_s.nextval
2306: into l_session_id
2307: from dual;
2308:
2309: msc_atp_proc.atp_intransit_lt(
2310: 2, --- Destination
2311: l_session_id, -- session_id

Line 3084: from dual;

3080:
3081: BEGIN
3082: select mrp_atp_schedule_temp_s.nextval
3083: into l_session_id
3084: from dual;
3085:
3086: MSC_ATP_PROC.ATP_Intransit_LT(
3087: 2, --- Destination
3088: l_session_id, -- session_id