DBA Data[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on MRP_SCHEDULE_DATES

Line 1973: FROM mrp_schedule_dates

1969: SELECT
1970: decode(schedule_quantity,NULL,MRP_KANBAN_PLAN_PK.Get_Repetitive_Demand(
1971: schedule_date,rate_end_date,repetitive_daily_rate),schedule_quantity),
1972: schedule_date
1973: FROM mrp_schedule_dates
1974: WHERE organization_id = g_kanban_info_rec.organization_id
1975: AND schedule_designator = g_kanban_info_rec.input_designator
1976: AND schedule_level = 2
1977: AND schedule_date BETWEEN g_kanban_info_rec.start_date AND

Line 3138: FROM mrp_schedule_dates

3134: schedule_date,rate_end_date,repetitive_daily_rate),schedule_quantity),
3135: schedule_date,
3136: schedule_origination_type,
3137: line_id
3138: FROM mrp_schedule_dates
3139: WHERE organization_id = g_kanban_info_rec.organization_id
3140: AND schedule_designator = g_kanban_info_rec.input_designator
3141: AND schedule_level = 2
3142: AND schedule_date BETWEEN g_kanban_info_rec.start_date AND

Line 3544: FROM mrp_schedule_dates

3540: CURSOR cur_schedule_entries IS
3541: SELECT inventory_item_id,
3542: schedule_origination_type,
3543: line_id
3544: FROM mrp_schedule_dates
3545: WHERE organization_id = g_kanban_info_rec.organization_id
3546: AND schedule_designator = g_kanban_info_rec.input_designator
3547: AND schedule_level = 2
3548: AND schedule_date BETWEEN g_kanban_info_rec.start_date AND