View: MRP_LOAD_PARAMETERS_V

Product:	MRP - Master Scheduling/MRP
Description:	Forecast and master schedule source list information
Implementation/DBA Data:	APPS.MRP_LOAD_PARAMETERS_V

View Text

SELECT M.ROWID ROW_ID
, M.QUERY_ID
, M.PROCESS_STATUS
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_LOGIN
, M.ORGANIZATION_ID
, M.SCHEDULE_DESIGNATOR
, M.FORECAST_DESIGNATOR
, M.LOAD_SOURCE
, M.LOAD_DESTINATION
, M.SOURCE_ORGANIZATION_ID
, M.SOURCE_SCHEDULE_DESIGNATOR
, M.SOURCE_FORECAST_DESIGNATOR
, M.ERROR_MESSAGE
, M.SELECTION_LIST_NAME
, M.SELECTION_LIST_TYPE
, 5 SOURCE_TYPE
, F.DESCRIPTION SOURCE_DESCRIPTION
, F.DEMAND_CLASS SOURCE_DEMAND_CLASS
, M.SOURCE_FORECAST_DESIGNATOR SOURCE_DESIGNATOR
, P.ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE
FROM MTL_PARAMETERS P
, MRP_FORECAST_DESIGNATORS F
, MRP_LOAD_PARAMETERS M
WHERE M.LOAD_SOURCE = 2
AND M.SOURCE_FORECAST_DESIGNATOR = F.FORECAST_DESIGNATOR
AND M.SOURCE_ORGANIZATION_ID = F.ORGANIZATION_ID
AND M.SOURCE_ORGANIZATION_ID = P.ORGANIZATION_ID
AND F.FORECAST_DESIGNATOR IS NOT NULL UNION SELECT M.ROWID ROW_ID
, M.QUERY_ID
, M.PROCESS_STATUS
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_LOGIN
, M.ORGANIZATION_ID
, M.SCHEDULE_DESIGNATOR
, M.FORECAST_DESIGNATOR
, M.LOAD_SOURCE
, M.LOAD_DESTINATION
, M.SOURCE_ORGANIZATION_ID
, M.SOURCE_SCHEDULE_DESIGNATOR
, M.SOURCE_FORECAST_DESIGNATOR
, M.ERROR_MESSAGE
, M.SELECTION_LIST_NAME
, M.SELECTION_LIST_TYPE
, S.SCHEDULE_TYPE SOURCE_TYPE
, S.DESCRIPTION SOURCE_DESCRIPTION
, S.DEMAND_CLASS SOURCE_DEMAND_CLASS
, M.SOURCE_SCHEDULE_DESIGNATOR SOURCE_DESIGNATOR
, P.ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE
FROM MTL_PARAMETERS P
, MRP_ORGANIZATIONS_V O
, MRP_SCHEDULE_DESIGNATORS S
, MRP_LOAD_PARAMETERS M
WHERE M.LOAD_SOURCE = 1
AND M.SOURCE_SCHEDULE_DESIGNATOR = S.SCHEDULE_DESIGNATOR
AND S.SCHEDULE_DESIGNATOR = O.COMPILE_DESIGNATOR(+)
AND S.ORGANIZATION_ID = O.ORGANIZATION_ID(+)
AND M.SOURCE_ORGANIZATION_ID = NVL(O.PLANNED_ORGANIZATION
, S.ORGANIZATION_ID)
AND M.SOURCE_ORGANIZATION_ID = P.ORGANIZATION_ID
AND S.SCHEDULE_DESIGNATOR IS NOT NULL UNION SELECT M.ROWID ROW_ID
, M.QUERY_ID
, M.PROCESS_STATUS
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_LOGIN
, M.ORGANIZATION_ID
, M.SCHEDULE_DESIGNATOR
, M.FORECAST_DESIGNATOR
, M.LOAD_SOURCE
, M.LOAD_DESTINATION
, M.SOURCE_ORGANIZATION_ID
, M.SOURCE_SCHEDULE_DESIGNATOR
, M.SOURCE_FORECAST_DESIGNATOR
, M.ERROR_MESSAGE
, M.SELECTION_LIST_NAME
, M.SELECTION_LIST_TYPE
, DECODE(D.DESIGNATOR_TYPE
, 2
, 3
, 3
, 4
, 4
, 6) SOURCE_TYPE
, D.DESCRIPTION SOURCE_DESCRIPTION
, NULL SOURCE_DEMAND_CLASS
, M.SOURCE_SCHEDULE_DESIGNATOR SOURCE_DESIGNATOR
, P.ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE
FROM MTL_PARAMETERS P
, MRP_PLAN_ORGANIZATIONS_V O
, MRP_DESIGNATORS_VIEW D
, MRP_LOAD_PARAMETERS M
WHERE M.LOAD_SOURCE = 4
AND M.SOURCE_SCHEDULE_DESIGNATOR = D.DESIGNATOR
AND D.DESIGNATOR = O.COMPILE_DESIGNATOR
AND D.ORGANIZATION_ID = O.ORGANIZATION_ID
AND M.SOURCE_ORGANIZATION_ID = O.PLANNED_ORGANIZATION
AND M.SOURCE_ORGANIZATION_ID = P.ORGANIZATION_ID
AND D.DESIGNATOR IS NOT NULL

Columns