DBA Data[Home] [Help]

APPS.FLM_KANBAN_PLANNING_UTIL dependencies on MTL_KANBAN_CARD_ACTIVITY

Line 560: from mtl_kanban_card_activity mkca,

556: min(mrp_calendar.NEXT_WORK_DAY(mkps.organization_id,1,
557: case when trunc(mkca.creation_date+mkps.replenishment_lead_time) < l_plan_start_date then l_plan_start_date
558: else trunc(mkca.creation_date+mkps.replenishment_lead_time) end )) expected_date,
559: min(mrp_calendar.NEXT_WORK_DAY(mkps.organization_id,1,trunc(mkca.creation_date))) replenished_date
560: from mtl_kanban_card_activity mkca,
561: mtl_kanban_cards mkc,
562: mtl_kanban_pull_sequences mkps,
563: mtl_kanban_pull_sequences plan
564: where mkps.organization_id = plan.organization_id

Line 1423: from mtl_kanban_card_activity mkca,

1419: min(mrp_calendar.NEXT_WORK_DAY(mkps.organization_id,1,
1420: case when trunc(mkca.creation_date+mkps.replenishment_lead_time) < l_start_date then l_start_date
1421: else trunc(mkca.creation_date+mkps.replenishment_lead_time) end)) expected_date,
1422: min(mrp_calendar.NEXT_WORK_DAY(mkps.organization_id,1,trunc(mkca.creation_date))) replenished_date
1423: from mtl_kanban_card_activity mkca,
1424: mtl_kanban_cards mkc,
1425: mtl_kanban_pull_sequences mkps,
1426: mtl_kanban_pull_sequences plan
1427: where mkps.organization_id = plan.organization_id