DBA Data[Home] [Help]

APPS.MRP_EPI dependencies on MRP_RECOMMENDATIONS

Line 1341: mrp_recommendations rec

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)
1345: AND msi.planning_make_buy_code = 2

Line 1363: mrp_recommendations rec

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))
1367: OR (calendar_date BETWEEN TRUNC(rec.first_unit_start_date)