DBA Data[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on MRP_KANBAN_ACTUAL_PROD_V

Line 1390: FROM mrp_kanban_actual_prod_v

1386:
1387: CURSOR parent_schedule_entries IS
1388: SELECT sum(planned_quantity) PQ,
1389: scheduled_completion_date
1390: FROM mrp_kanban_actual_prod_v
1391: WHERE organization_id = g_kanban_info_rec.organization_id
1392: AND scheduled_completion_date between g_kanban_info_rec.start_date AND
1393: g_kanban_info_rec.cutoff_date
1394: AND primary_item_id IN

Line 2641: FROM mrp_kanban_actual_prod_v

2637: SELECT sum(planned_quantity) PQ,
2638: scheduled_completion_date,
2639: schedule_type,
2640: line_id
2641: FROM mrp_kanban_actual_prod_v
2642: WHERE organization_id = g_kanban_info_rec.organization_id
2643: AND scheduled_completion_date between g_kanban_info_rec.start_date AND
2644: g_kanban_info_rec.cutoff_date
2645: AND primary_item_id IN

Line 3229: FROM mrp_kanban_actual_prod_v

3225: CURSOR GetActualProductionDemand IS
3226: SELECT primary_item_id,
3227: alternate_bom_designator,
3228: line_id
3229: FROM mrp_kanban_actual_prod_v
3230: WHERE organization_id = g_kanban_info_rec.organization_id
3231: AND scheduled_completion_date between g_kanban_info_rec.start_date AND
3232: g_kanban_info_rec.cutoff_date
3233: AND primary_item_id IN