DBA Data[Home] [Help]

APPS.MRP_GRAPH_LINE_CAPACITY dependencies on MRP_FORM_QUERY_S

Line 346: SELECT mrp_form_query_s.nextval

342: -- Load and flush the dates
343: initialize_dates;
344:
345: -- Get the query_id
346: SELECT mrp_form_query_s.nextval
347: INTO l_query_id
348: FROM dual;
349:
350: -- We want to show all valid working days and non-working days

Line 365: -- Insert the dates into mrp_form_query so that we can join

361: -- Load the dates into mrp_workbench_bucket_dates so that the
362: -- form can select them into the flat file.
363: date_cells_tab(l_bucket_number) := l_bucket_date;
364:
365: -- Insert the dates into mrp_form_query so that we can join
366: -- to it in MRP_CAPACITY_CURSOR to get the appropriate bucket
367: -- numbers.
368: INSERT INTO MRP_FORM_QUERY(QUERY_ID, LAST_UPDATE_DATE,
369: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, DATE1,