APPS.MRP_REPORT_INV_TURNS dependencies on MRP_FORM_QUERY

Line 70: FROM mrp_form_query

66: number5,
67: number6,
68: number7,
69: number8
70: FROM mrp_form_query
71: WHERE query_id = arg_query_id
72: ORDER BY date1;
73: BEGIN
74: /*--------------------------+

Line 86: update mrp_form_query

82: /*-----------------------------------------------------------+
83: | Write org_id, compile_designator, and schedule_designator |
84: | for each row of the current query_id |
85: +-----------------------------------------------------------*/
86: update mrp_form_query
87: set char1 = arg_compile_desig,
88: char2 = arg_sched_desig,
89: number12 = arg_org_id
90: where query_id = arg_query_id;

Line 163: | Write sum to mrp_form_query |

159: IF SQL%NOTFOUND THEN
160: RAISE select_wip;
161: END IF;
162: /*----------------------------+
163: | Write sum to mrp_form_query |
164: +----------------------------*/
165: UPDATE mrp_form_query
166: SET number1 = begin_inv + issued_inv
167: WHERE query_id = arg_query_id

Line 165: UPDATE mrp_form_query

161: END IF;
162: /*----------------------------+
163: | Write sum to mrp_form_query |
164: +----------------------------*/
165: UPDATE mrp_form_query
166: SET number1 = begin_inv + issued_inv
167: WHERE query_id = arg_query_id
168: AND date2 IS NOT NULL;
169:

Line 176: UPDATE mrp_form_query query

172: END IF;
173: /*-----------------------------------------+
174: | Calculate value of open purchase orders |
175: +-----------------------------------------*/
176: UPDATE mrp_form_query query
177: SET number2 =
178: (SELECT NVL(SUM(rec.new_order_quantity
179: * NVL(cst.item_cost, 0)), 0)
180: / 1000

Line 213: UPDATE mrp_form_query query

209: END IF;
210: /*-----------------------------------------------+
211: | Calculate value of open purchase requisitions |
212: +-----------------------------------------------*/
213: UPDATE mrp_form_query query
214: SET number3 =
215: (SELECT NVL(SUM(rec.new_order_quantity
216: * NVL(cst.item_cost,0)), 0)
217: / 1000

Line 250: UPDATE mrp_form_query query

246: END IF;
247: /*------------------------------------------------+
248: | Calculate value of MRP planned purchase orders |
249: +------------------------------------------------*/
250: UPDATE mrp_form_query query
251: SET number4 =
252: (SELECT NVL(SUM(rec.new_order_quantity
253: * NVL(cst.item_cost, 0)), 0)
254: / 1000

Line 294: UPDATE mrp_form_query query

290: | Calculate value of open discrete jobs and open flow schedules, |
291: | excluding material costs. Note that we include flow schedule |
292: | costs under the heading of discrete jobs in the report. |
293: +-----------------------------------------------------------------*/
294: UPDATE mrp_form_query query
295: SET number5 =
296: (SELECT NVL(SUM(rec.new_order_quantity
297: * (NVL(cst.tl_resource, 0)
298: + NVL(cst.tl_overhead, 0)

Line 335: UPDATE mrp_form_query query

331: /*------------------------------------------------------------------------+
332: | Calculate value of suggested repetitive schedules, excluding material |
333: | costs |
334: +------------------------------------------------------------------------*/
335: UPDATE mrp_form_query query
336: SET number6 =
337: (SELECT NVL(SUM(NVL(rec.daily_rate, 0)
338: * (NVL(cst.tl_resource, 0)
339: + NVL(cst.tl_overhead, 0)

Line 385: UPDATE mrp_form_query query

381: END IF;
382: /*------------------------------------------------------------------------+
383: | Calculate value of MRP planned discrete jobs, excluding material costs |
384: +------------------------------------------------------------------------*/
385: UPDATE mrp_form_query query
386: SET number7 =
387: (SELECT NVL(SUM(rec.new_order_quantity
388: * (NVL(cst.tl_resource, 0)
389: + NVL(cst.tl_overhead, 0)

Line 430: UPDATE mrp_form_query query

426: END IF;
427: /*----------------------------------------------------+
428: | Calculate value of master schedule, discrete items |
429: +----------------------------------------------------*/
430: UPDATE mrp_form_query query
431: SET number8 =
432: (SELECT NVL(SUM(dates.schedule_quantity * cst.item_cost), 0)
433: / 1000
434: FROM mrp_schedule_dates dates,

Line 473: UPDATE mrp_form_query query

469: END IF;
470: /*------------------------------------------------------+
471: | Calculate value of master schedule, repetitive items |
472: +------------------------------------------------------*/
473: UPDATE mrp_form_query query
474: SET number8 =
475: (SELECT query.number8 +
476: NVL(SUM(cst.item_cost
477: * dates.repetitive_daily_rate), 0)

Line 603: UPDATE mrp_form_query

599: IF SQL%NOTFOUND THEN
600: RAISE select_past_due_mds;
601: END IF;
602: master_schedule := master_schedule + past_due_master_schedule;
603: UPDATE mrp_form_query
604: SET number8 = master_schedule
605: WHERE rowid = my_rowid;
606: IF SQL%NOTFOUND THEN
607: RAISE update_past_due_mds;

Line 654: | mrp_form_query |

650: start_date_report));
651: END IF;
652: /*-------------------------------------------------------------+
653: | Write ending inventory, period turns and cumulative turns to |
654: | mrp_form_query |
655: +-------------------------------------------------------------*/
656: UPDATE mrp_form_query q
657: SET number9 = end_inv_this_period,
658: number10 = period_turns,

Line 656: UPDATE mrp_form_query q

652: /*-------------------------------------------------------------+
653: | Write ending inventory, period turns and cumulative turns to |
654: | mrp_form_query |
655: +-------------------------------------------------------------*/
656: UPDATE mrp_form_query q
657: SET number9 = end_inv_this_period,
658: number10 = period_turns,
659: number11 = cum_turns
660: WHERE rowid = my_rowid;