Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | Kanban Plans View |
Implementation/DBA Data: | APPS.MRP_KANBAN_PLANS_V |
SELECT KAN.ROWID
, KAN.ORGANIZATION_ID
, KAN.KANBAN_PLAN_ID
, KAN.KANBAN_DESIGNATOR
, KAN.LAST_UPDATE_DATE
, KAN.LAST_UPDATED_BY
, KAN.CREATION_DATE
, KAN.CREATED_BY
, KAN.LAST_UPDATE_LOGIN
, KAN.DESCRIPTION
, KAN.INPUT_TYPE
, KAN.INPUT_DESIGNATOR
, DECODE(KAN.INPUT_TYPE
, 1
, FCT.DESCRIPTION
, SCH.DESCRIPTION)
, KAN.PLAN_START_DATE
, KAN.PLAN_COMPLETION_DATE
, KAN.DISABLE_DATE
, KAN.BOM_EFFECTIVITY_DATE
, KAN.PLAN_CUTOFF_DATE
FROM MRP_FORECAST_DESIGNATORS FCT
, MRP_SCHEDULE_DESIGNATORS SCH
, MRP_KANBAN_PLANS KAN
WHERE FCT.ORGANIZATION_ID(+) = KAN.ORGANIZATION_ID
AND FCT.FORECAST_DESIGNATOR(+) = KAN.INPUT_DESIGNATOR
AND SCH.ORGANIZATION_ID(+) = KAN.ORGANIZATION_ID
AND SCH.SCHEDULE_DESIGNATOR(+) = KAN.INPUT_DESIGNATOR