VIEW: APPS.MRP_DESIGNATORS_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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