DBA Data[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on MRP_KANBAN_ACTUAL_PROD_V

Line 1469: FROM mrp_kanban_actual_prod_v

1465:
1466: CURSOR parent_schedule_entries IS
1467: SELECT sum(planned_quantity) PQ,
1468: scheduled_completion_date
1469: FROM mrp_kanban_actual_prod_v
1470: WHERE organization_id = g_kanban_info_rec.organization_id
1471: AND scheduled_completion_date between g_kanban_info_rec.start_date AND
1472: g_kanban_info_rec.cutoff_date
1473: AND primary_item_id IN

Line 2823: FROM mrp_kanban_actual_prod_v

2819: SELECT sum(planned_quantity) PQ,
2820: scheduled_completion_date,
2821: schedule_type,
2822: line_id
2823: FROM mrp_kanban_actual_prod_v
2824: WHERE organization_id = g_kanban_info_rec.organization_id
2825: AND scheduled_completion_date between g_kanban_info_rec.start_date AND
2826: g_kanban_info_rec.cutoff_date
2827: AND primary_item_id IN

Line 3557: FROM mrp_kanban_actual_prod_v

3553: CURSOR GetActualProductionDemand IS
3554: SELECT primary_item_id,
3555: alternate_bom_designator,
3556: line_id
3557: FROM mrp_kanban_actual_prod_v
3558: WHERE organization_id = g_kanban_info_rec.organization_id
3559: AND scheduled_completion_date between g_kanban_info_rec.start_date AND
3560: g_kanban_info_rec.cutoff_date
3561: AND primary_item_id IN