eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_REPORT_INV_TURNS dependencies on CST_ITEM_COSTS

Line 103: FROM cst_item_costs cst,

99: SELECT NVL(SUM((sys.nettable_inventory_quantity)
100: * NVL(cst.item_cost, 0)), 0)
101: / 1000
102: INTO begin_inv
103: FROM cst_item_costs cst,
104: mrp_system_items sys
105: WHERE cst.organization_id = sys.organization_id
106: AND cst.inventory_item_id = sys.inventory_item_id
107: AND ( cst.cost_type_id = arg_cost_type

Line 114: FROM cst_item_costs cst1

110: (cst.cost_type_id = arg_def_cost_type)
111: AND
112: (NOT EXISTS
113: (SELECT 'Primary Cost Type Row'
114: FROM cst_item_costs cst1
115: WHERE cst1.inventory_item_id = cst.inventory_item_id
116: AND cst1.organization_id = arg_org_id
117: AND cst1.cost_type_id = arg_cost_type)
118: )

Line 134: FROM cst_item_costs cst,

130: SELECT NVL(SUM(NVL(wip.net_quantity, 0)
131: * NVL(cst.item_cost, 0)), 0)
132: / 1000
133: INTO issued_inv
134: FROM cst_item_costs cst,
135: mrp_wip_components wip
136: WHERE cst.organization_id = wip.organization_id
137: AND cst.inventory_item_id = wip.inventory_item_id
138: AND ( cst.cost_type_id = arg_cost_type

Line 145: FROM cst_item_costs cst1

141: (cst.cost_type_id = arg_def_cost_type)
142: AND
143: (NOT EXISTS
144: (SELECT 'Primary Cost Type Row'
145: FROM cst_item_costs cst1
146: WHERE cst1.inventory_item_id = cst.inventory_item_id
147: AND cst1.organization_id = arg_org_id
148: AND cst1.cost_type_id = arg_cost_type)
149: )

Line 181: FROM cst_item_costs cst,

177: SET number2 =
178: (SELECT NVL(SUM(rec.new_order_quantity
179: * NVL(cst.item_cost, 0)), 0)
180: / 1000
181: FROM cst_item_costs cst,
182: mrp_recommendations rec
183: WHERE cst.organization_id = rec.organization_id
184: AND cst.inventory_item_id = rec.inventory_item_id
185: AND ( cst.cost_type_id = arg_cost_type

Line 192: FROM cst_item_costs cst1

188: (cst.cost_type_id = arg_def_cost_type)
189: AND
190: (NOT EXISTS
191: (SELECT 'Primary Cost Type Row'
192: FROM cst_item_costs cst1
193: WHERE cst1.inventory_item_id = cst.inventory_item_id
194: AND cst1.organization_id = arg_org_id
195: AND cst1.cost_type_id = arg_cost_type)
196: )

Line 218: FROM cst_item_costs cst,

214: SET number3 =
215: (SELECT NVL(SUM(rec.new_order_quantity
216: * NVL(cst.item_cost,0)), 0)
217: / 1000
218: FROM cst_item_costs cst,
219: mrp_recommendations rec
220: WHERE cst.organization_id = rec.organization_id
221: AND cst.inventory_item_id = rec.inventory_item_id
222: AND ( cst.cost_type_id = arg_cost_type

Line 229: FROM cst_item_costs cst1

225: (cst.cost_type_id = arg_def_cost_type)
226: AND
227: (NOT EXISTS
228: (SELECT 'Primary Cost Type Row'
229: FROM cst_item_costs cst1
230: WHERE cst1.inventory_item_id = cst.inventory_item_id
231: AND cst1.organization_id = arg_org_id
232: AND cst1.cost_type_id = arg_cost_type)
233: )

Line 255: FROM cst_item_costs cst,

251: SET number4 =
252: (SELECT NVL(SUM(rec.new_order_quantity
253: * NVL(cst.item_cost, 0)), 0)
254: / 1000
255: FROM cst_item_costs cst,
256: mrp_system_items sys,
257: mrp_recommendations rec
258: WHERE cst.organization_id = sys.organization_id
259: AND cst.inventory_item_id = sys.inventory_item_id

Line 267: FROM cst_item_costs cst1

263: (cst.cost_type_id = arg_def_cost_type)
264: AND
265: (NOT EXISTS
266: (SELECT 'Primary Cost Type Row'
267: FROM cst_item_costs cst1
268: WHERE cst1.inventory_item_id = cst.inventory_item_id
269: AND cst1.organization_id = arg_org_id
270: AND cst1.cost_type_id = arg_cost_type)
271: )

Line 302: FROM cst_item_costs cst,

298: + NVL(cst.tl_overhead, 0)
299: + NVL(cst.tl_material_overhead, 0)
300: + NVL(cst.tl_outside_processing, 0))), 0)
301: / 1000
302: FROM cst_item_costs cst,
303: mrp_recommendations rec
304: WHERE cst.inventory_item_id = rec.inventory_item_id
305: AND cst.organization_id = rec.organization_id
306: AND ( cst.cost_type_id = arg_cost_type

Line 313: FROM cst_item_costs cst1

309: (cst.cost_type_id = arg_def_cost_type)
310: AND
311: (NOT EXISTS
312: (SELECT 'Primary Cost Type Row'
313: FROM cst_item_costs cst1
314: WHERE cst1.inventory_item_id = cst.inventory_item_id
315: AND cst1.organization_id = arg_org_id
316: AND cst1.cost_type_id = arg_cost_type)
317: )

Line 343: FROM cst_item_costs cst,

339: + NVL(cst.tl_overhead, 0)
340: + NVL(cst.tl_material_overhead, 0)
341: + NVL(cst.tl_outside_processing, 0))), 0)
342: / 1000
343: FROM cst_item_costs cst,
344: bom_calendar_dates cal,
345: mrp_recommendations rec
346: WHERE cst.inventory_item_id = rec.inventory_item_id
347: AND cst.organization_id = rec.organization_id

Line 355: FROM cst_item_costs cst1

351: (cst.cost_type_id = arg_def_cost_type)
352: AND
353: (NOT EXISTS
354: (SELECT 'Primary Cost Type Row'
355: FROM cst_item_costs cst1
356: WHERE cst1.inventory_item_id = cst.inventory_item_id
357: AND cst1.organization_id = arg_org_id
358: AND cst1.cost_type_id = arg_cost_type)
359: )

Line 393: FROM cst_item_costs cst,

389: + NVL(cst.tl_overhead, 0)
390: + NVL(cst.tl_material_overhead, 0)
391: + NVL(cst.tl_outside_processing, 0))), 0)
392: / 1000
393: FROM cst_item_costs cst,
394: mrp_system_items sys,
395: mrp_recommendations rec
396: WHERE cst.inventory_item_id = sys.inventory_item_id
397: AND cst.organization_id = sys.organization_id

Line 405: FROM cst_item_costs cst1

401: (cst.cost_type_id = arg_def_cost_type)
402: AND
403: (NOT EXISTS
404: (SELECT 'Primary Cost Type Row'
405: FROM cst_item_costs cst1
406: WHERE cst1.inventory_item_id = cst.inventory_item_id
407: AND cst1.organization_id = arg_org_id
408: AND cst1.cost_type_id = arg_cost_type)
409: )

Line 435: cst_item_costs cst,

431: SET number8 =
432: (SELECT NVL(SUM(dates.schedule_quantity * cst.item_cost), 0)
433: / 1000
434: FROM mrp_schedule_dates dates,
435: cst_item_costs cst,
436: mrp_system_items sys,
437: mrp_schedule_designators sched
438: WHERE cst.organization_id = sys.organization_id
439: AND cst.inventory_item_id = sys.inventory_item_id

Line 447: FROM cst_item_costs cst1

443: (cst.cost_type_id = arg_def_cost_type)
444: AND
445: (NOT EXISTS
446: (SELECT 'Primary Cost Type Row'
447: FROM cst_item_costs cst1
448: WHERE cst1.inventory_item_id = cst.inventory_item_id
449: AND cst1.organization_id = arg_org_id
450: AND cst1.cost_type_id = arg_cost_type)
451: )

Line 481: cst_item_costs cst,

477: * dates.repetitive_daily_rate), 0)
478: / 1000
479: FROM bom_calendar_dates cal,
480: mrp_schedule_dates dates,
481: cst_item_costs cst,
482: mrp_system_items sys,
483: mrp_schedule_designators sched
484: WHERE cst.organization_id = sys.organization_id
485: AND cst.inventory_item_id = sys.inventory_item_id

Line 493: FROM cst_item_costs cst1

489: (cst.cost_type_id = arg_def_cost_type)
490: AND
491: (NOT EXISTS
492: (SELECT 'Primary Cost Type Row'
493: FROM cst_item_costs cst1
494: WHERE cst1.inventory_item_id = cst.inventory_item_id
495: AND cst1.organization_id = arg_org_id
496: AND cst1.cost_type_id = arg_cost_type)
497: )

Line 565: cst_item_costs cst,

561: dates.schedule_quantity)), 0) / 1000
562: INTO past_due_master_schedule
563: FROM bom_calendar_dates cal,
564: mrp_schedule_dates dates,
565: cst_item_costs cst,
566: mrp_system_items sys,
567: mrp_schedule_designators sched
568: WHERE cst.organization_id = sys.organization_id
569: AND cst.inventory_item_id = sys.inventory_item_id

Line 577: FROM cst_item_costs cst1

573: (cst.cost_type_id = arg_def_cost_type)
574: AND
575: (NOT EXISTS
576: (SELECT 'Primary Cost Type Row'
577: FROM cst_item_costs cst1
578: WHERE cst1.inventory_item_id = cst.inventory_item_id
579: AND cst1.organization_id = arg_org_id
580: AND cst1.cost_type_id = arg_cost_type)
581: )