DBA Data[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on MRP_SCHEDULE_DATES

Line 1878: FROM mrp_schedule_dates

1874: SELECT
1875: decode(schedule_quantity,NULL,MRP_KANBAN_PLAN_PK.Get_Repetitive_Demand(
1876: schedule_date,rate_end_date,repetitive_daily_rate),schedule_quantity),
1877: schedule_date
1878: FROM mrp_schedule_dates
1879: WHERE organization_id = g_kanban_info_rec.organization_id
1880: AND schedule_designator = g_kanban_info_rec.input_designator
1881: AND schedule_level = 2
1882: AND schedule_date BETWEEN g_kanban_info_rec.start_date AND

Line 2884: FROM mrp_schedule_dates

2880: schedule_date,rate_end_date,repetitive_daily_rate),schedule_quantity),
2881: schedule_date,
2882: schedule_origination_type,
2883: line_id
2884: FROM mrp_schedule_dates
2885: WHERE organization_id = g_kanban_info_rec.organization_id
2886: AND schedule_designator = g_kanban_info_rec.input_designator
2887: AND schedule_level = 2
2888: AND schedule_date BETWEEN g_kanban_info_rec.start_date AND

Line 3216: FROM mrp_schedule_dates

3212: CURSOR cur_schedule_entries IS
3213: SELECT inventory_item_id,
3214: schedule_origination_type,
3215: line_id
3216: FROM mrp_schedule_dates
3217: WHERE organization_id = g_kanban_info_rec.organization_id
3218: AND schedule_designator = g_kanban_info_rec.input_designator
3219: AND schedule_level = 2
3220: AND schedule_date BETWEEN g_kanban_info_rec.start_date AND