VIEW: APPS.MRP_LOAD_PARAMETERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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