[Home] [Help]
229: sysdate,
230: 1,
231: sysdate,
232: 1
233: FROM bom_calendar_dates cal,
234: mtl_parameters mtl,
235: mrp_schedule_dates dates,
236: mrp_bis_inv_detail inv
237: WHERE cal.calendar_date BETWEEN dates.schedule_date AND dates.rate_end_date
479: mrp_item_cost(dates.inventory_item_id,
480: dates.organization_id)), 0)
481: / 1000
482: INTO revenue, cost
483: FROM bom_calendar_dates cal,
484: mrp_schedule_dates dates,
485: mrp_system_items sys,
486: mtl_parameters param
487: WHERE dates.organization_id = sys.organization_id
697: mtl_category_sets scat,
698: mtl_categories_kfv cat,
699: mtl_categories_vl vcat,
700: mtl_item_categories icat,
701: bom_calendar_dates cal,
702: mtl_parameters mp,
703: mtl_system_items_kfv sys3,
704: mtl_system_items_kfv sys2,
705: mtl_system_items_kfv sys,
994: mtl_category_sets scat,
995: mtl_categories_kfv cat,
996: mtl_categories_vl vcat,
997: mtl_item_categories icat,
998: bom_calendar_dates cal,
999: mtl_parameters mp,
1000: mtl_system_items_kfv sys3,
1001: mtl_system_items_kfv sys2,
1002: mtl_system_items_kfv sys,
1356: CURSOR INV_VALUES_C2 IS
1357: SELECT NVL(SUM(DECODE(order_type,4,NVL(rec.daily_rate,0),
1358: NVL(rec.new_order_quantity,0))),0) *
1359: mrp_item_cost(rec.inventory_item_id, rec.organization_id)
1360: FROM bom_calendar_dates cal,
1361: mtl_parameters mtl,
1362: mrp_system_items msi,
1363: mrp_recommendations rec
1364: WHERE rec.disposition_status_type = 1
1463: sysdate,
1464: 1,
1465: sysdate,
1466: 1
1467: FROM bom_calendar_dates cal,
1468: mtl_parameters param,
1469: crp_available_resources_v avail
1470: WHERE cal.calendar_date BETWEEN avail.resource_start_date
1471: AND NVL(avail.resource_end_date,avail.resource_start_date)
1489: sysdate,
1490: 1,
1491: sysdate,
1492: 1
1493: FROM bom_calendar_dates cal,
1494: mtl_parameters param,
1495: crp_resource_requirements_v req
1496: WHERE cal.calendar_date BETWEEN req.resource_date
1497: AND NVL(req.resource_end_date,req.resource_date)