DBA Data[Home] [Help]

APPS.MSC_X_VMI_UTIL_NEW dependencies on MSC_X_HZ_UI_QUERY_ID_S

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,