VIEW: APPS.MRP_SRS_SCHED_LOAD_SOURCE_V

Source

View Text - Preformatted

SELECT ORGANIZATION_ID , 6 , SELECTION_LIST_NAME , DESCRIPTION , NULL FROM MRP_LOAD_SELECTIONS WHERE SELECTION_LIST_TYPE = 1 UNION ALL SELECT ORGANIZATION_ID , 7 , SELECTION_LIST_NAME , DESCRIPTION , NULL FROM MRP_LOAD_SELECTIONS WHERE SELECTION_LIST_TYPE = 3 UNION ALL SELECT ORGANIZATION_ID , 9 , SELECTION_LIST_NAME , DESCRIPTION , NULL FROM MRP_LOAD_SELECTIONS WHERE SELECTION_LIST_TYPE = 4 UNION ALL SELECT ORGANIZATION_ID , 1 , SCHEDULE_DESIGNATOR , MSD.DESCRIPTION , MEANING FROM MFG_LOOKUPS , MRP_SCHEDULE_DESIGNATORS MSD WHERE LOOKUP_TYPE = 'MRP_DESIGNATOR_TYPE_SHORT' AND LOOKUP_CODE = SCHEDULE_TYPE AND SCHEDULE_TYPE = 1 AND NVL(DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) UNION ALL SELECT NVL(MPO.PLANNED_ORGANIZATION, MSD.ORGANIZATION_ID) , 8 , MSD.SCHEDULE_DESIGNATOR , MSD.DESCRIPTION , MEANING FROM MFG_LOOKUPS , MRP_ORGANIZATIONS_V MPO , MRP_SCHEDULE_DESIGNATORS MSD WHERE LOOKUP_TYPE = 'MRP_DESIGNATOR_TYPE_SHORT' AND LOOKUP_CODE = MSD.SCHEDULE_TYPE AND MSD.SCHEDULE_TYPE = 2 AND NVL(MSD.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND MSD.SCHEDULE_DESIGNATOR = MPO.COMPILE_DESIGNATOR (+) AND MSD.ORGANIZATION_ID = MPO.ORGANIZATION_ID (+) UNION ALL SELECT ORGANIZATION_ID , 2 , FORECAST_DESIGNATOR , DESCRIPTION , NULL FROM MRP_FORECAST_DESIGNATORS WHERE NVL(DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) UNION ALL SELECT 0 , 3 , NULL , NULL , NULL FROM DUAL UNION ALL SELECT MPO.PLANNED_ORGANIZATION , 4 , MDV.DESIGNATOR , MDV.DESCRIPTION , MEANING FROM MFG_LOOKUPS , MRP_PLAN_ORGANIZATIONS_V MPO , MRP_DESIGNATORS_VIEW MDV WHERE LOOKUP_TYPE = 'MRP_DESIGNATOR_TYPE_SHORT' AND LOOKUP_CODE = MDV.DESIGNATOR_TYPE AND MDV.DESIGNATOR_TYPE != 1 AND NVL(MDV.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND MPO.COMPILE_DESIGNATOR = MDV.DESIGNATOR AND MPO.ORGANIZATION_ID = MDV.ORGANIZATION_ID AND MPO.PLAN_TYPE = DECODE(MDV.DESIGNATOR_TYPE, 3, 1, 4, 3, MDV.DESIGNATOR_TYPE)

View Text - HTML Formatted

SELECT ORGANIZATION_ID
, 6
, SELECTION_LIST_NAME
, DESCRIPTION
, NULL
FROM MRP_LOAD_SELECTIONS
WHERE SELECTION_LIST_TYPE = 1 UNION ALL SELECT ORGANIZATION_ID
, 7
, SELECTION_LIST_NAME
, DESCRIPTION
, NULL
FROM MRP_LOAD_SELECTIONS
WHERE SELECTION_LIST_TYPE = 3 UNION ALL SELECT ORGANIZATION_ID
, 9
, SELECTION_LIST_NAME
, DESCRIPTION
, NULL
FROM MRP_LOAD_SELECTIONS
WHERE SELECTION_LIST_TYPE = 4 UNION ALL SELECT ORGANIZATION_ID
, 1
, SCHEDULE_DESIGNATOR
, MSD.DESCRIPTION
, MEANING
FROM MFG_LOOKUPS
, MRP_SCHEDULE_DESIGNATORS MSD
WHERE LOOKUP_TYPE = 'MRP_DESIGNATOR_TYPE_SHORT'
AND LOOKUP_CODE = SCHEDULE_TYPE
AND SCHEDULE_TYPE = 1
AND NVL(DISABLE_DATE
, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) UNION ALL SELECT NVL(MPO.PLANNED_ORGANIZATION
, MSD.ORGANIZATION_ID)
, 8
, MSD.SCHEDULE_DESIGNATOR
, MSD.DESCRIPTION
, MEANING
FROM MFG_LOOKUPS
, MRP_ORGANIZATIONS_V MPO
, MRP_SCHEDULE_DESIGNATORS MSD
WHERE LOOKUP_TYPE = 'MRP_DESIGNATOR_TYPE_SHORT'
AND LOOKUP_CODE = MSD.SCHEDULE_TYPE
AND MSD.SCHEDULE_TYPE = 2
AND NVL(MSD.DISABLE_DATE
, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
AND MSD.SCHEDULE_DESIGNATOR = MPO.COMPILE_DESIGNATOR (+)
AND MSD.ORGANIZATION_ID = MPO.ORGANIZATION_ID (+) UNION ALL SELECT ORGANIZATION_ID
, 2
, FORECAST_DESIGNATOR
, DESCRIPTION
, NULL
FROM MRP_FORECAST_DESIGNATORS
WHERE NVL(DISABLE_DATE
, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) UNION ALL SELECT 0
, 3
, NULL
, NULL
, NULL
FROM DUAL UNION ALL SELECT MPO.PLANNED_ORGANIZATION
, 4
, MDV.DESIGNATOR
, MDV.DESCRIPTION
, MEANING
FROM MFG_LOOKUPS
, MRP_PLAN_ORGANIZATIONS_V MPO
, MRP_DESIGNATORS_VIEW MDV
WHERE LOOKUP_TYPE = 'MRP_DESIGNATOR_TYPE_SHORT'
AND LOOKUP_CODE = MDV.DESIGNATOR_TYPE
AND MDV.DESIGNATOR_TYPE != 1
AND NVL(MDV.DISABLE_DATE
, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
AND MPO.COMPILE_DESIGNATOR = MDV.DESIGNATOR
AND MPO.ORGANIZATION_ID = MDV.ORGANIZATION_ID
AND MPO.PLAN_TYPE = DECODE(MDV.DESIGNATOR_TYPE
, 3
, 1
, 4
, 3
, MDV.DESIGNATOR_TYPE)