Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | Designator view |
Implementation/DBA Data: | APPS.MRP_DESIGNATORS_VIEW |
SELECT S.SCHEDULE_DESIGNATOR
, S.ORGANIZATION_ID
, S.LAST_UPDATE_DATE
, S.LAST_UPDATED_BY
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATE_LOGIN
, S.DESCRIPTION
, S.SCHEDULE_TYPE
, S.DISABLE_DATE
, S.MPS_RELIEF
, S.USE_NEW_PLANNER
, S.ORGANIZATION_SELECTION
, S.PRODUCTION
FROM MRP_SCHEDULE_DESIGNATORS S UNION ALL SELECT D.COMPILE_DESIGNATOR
, D.ORGANIZATION_ID
, D.LAST_UPDATE_DATE
, D.LAST_UPDATED_BY
, D.CREATION_DATE
, D.CREATED_BY
, D.LAST_UPDATE_LOGIN
, D.DESCRIPTION
, DECODE(D.DRP_PLAN
, 1
, 4
, 3)
, D.DISABLE_DATE
, -1
, D.USE_NEW_PLANNER
, D.ORGANIZATION_SELECTION
, D.PRODUCTION
FROM MRP_DESIGNATORS D