[Home] [Help]
137: 1,
138: sysdate,
139: 1
140: FROM mrp_plan_schedules_v pln_sched,
141: mrp_system_items sys,
142: mrp_plan_organizations_v org
143: WHERE sys.compile_designator = org.compile_designator
144: AND sys.organization_id = org.planned_organization
145: AND org.planned_organization = pln_sched.input_organization_id(+)
190: 1,
191: sysdate,
192: 1
193: FROM mrp_schedule_dates dates,
194: mrp_system_items sys,
195: mrp_bis_inv_detail inv
196: WHERE dates.rate_end_date IS NULL
197: AND dates.schedule_date(+)
198: between plan_dates_rec.start_date and plan_dates_rec.end_date
457: dates.organization_id)), 0)
458: / 1000
459: INTO revenue, cost
460: FROM mrp_schedule_dates dates,
461: mrp_system_items sys
462: WHERE dates.organization_id = sys.organization_id
463: AND dates.inventory_item_id = sys.inventory_item_id
464: AND dates.schedule_level = 3
465: AND dates.schedule_designator = sched_name
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
488: AND dates.inventory_item_id = sys.inventory_item_id
489: AND dates.schedule_level = 3
1336:
1337: CURSOR INV_VALUES_C1 IS
1338: SELECT NVL(SUM(NVL(rec.new_order_quantity,0)),0) *
1339: mrp_item_cost(rec.inventory_item_id, rec.organization_id)
1340: FROM mrp_system_items msi,
1341: mrp_recommendations rec
1342: WHERE rec.disposition_status_type = 1
1343: AND TRUNC(rec.new_schedule_date) between p_start_date and p_end_date
1344: AND rec.order_type in (1,2,5,8)
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
1365: AND ((calendar_date = TRUNC(rec.new_wip_start_date)
1366: AND rec.order_type in (3,27))