View: MRP_SRS_SCHED_LOAD_SOURCE_V

Product:	MRP - Master Scheduling/MRP
Description:	Sources for schedule load
Implementation/DBA Data:	APPS.MRP_SRS_SCHED_LOAD_SOURCE_V

View Text

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)

Columns