[Home] [Help]
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
108: OR
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
260: AND ( cst.cost_type_id = arg_cost_type
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
398: AND ( cst.cost_type_id = arg_cost_type
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
440: AND ( cst.cost_type_id = arg_cost_type
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
486: AND ( cst.cost_type_id = arg_cost_type
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
570: AND ( cst.cost_type_id = arg_cost_type