APPS.MRP_EPI dependencies on MRP_FORM_QUERY

Line 1433: -- Use mrp_form_query to gather resource data to

1429: l_query_id NUMBER;
1430: BEGIN
1431:
1432: -- ---------------------------------------------
1433: -- Use mrp_form_query to gather resource data to
1434: -- be summarized
1435: -- ---------------------------------------------
1436: SELECT mrp_form_query_s.nextval
1437: INTO l_query_id

Line 1436: SELECT mrp_form_query_s.nextval

1432: -- ---------------------------------------------
1433: -- Use mrp_form_query to gather resource data to
1434: -- be summarized
1435: -- ---------------------------------------------
1436: SELECT mrp_form_query_s.nextval
1437: INTO l_query_id
1438: FROM dual;
1439:
1440: INSERT INTO mrp_form_query

Line 1440: INSERT INTO mrp_form_query

1436: SELECT mrp_form_query_s.nextval
1437: INTO l_query_id
1438: FROM dual;
1439:
1440: INSERT INTO mrp_form_query
1441: (query_id,
1442: number1,
1443: char1,
1444: number2,

Line 1537: FROM mrp_form_query

1533: sysdate,
1534: 1,
1535: sysdate,
1536: 1
1537: FROM mrp_form_query
1538: WHERE query_id = l_query_id
1539: GROUP BY number1, char1, number2, number3, number4, date1;
1540:
1541: -- -----------------------------------

Line 1552: delete from MRP_FORM_QUERY where query_id = l_query_id;

1548: SET utilization = required_hours/available_hours
1549: WHERE available_hours <> 0;
1550: ***/
1551:
1552: delete from MRP_FORM_QUERY where query_id = l_query_id;
1553:
1554: END mrp_resource_util;
1555:
1556: END mrp_epi;