View: GMD_OPRN_PROCESS_PARAMETERS_V1

Product:	GMD - Process Manufacturing Product Development
Description:	View of joining the overrides from operation resource and generic resource
Implementation/DBA Data:	APPS.GMD_OPRN_PROCESS_PARAMETERS_V1

View Text

SELECT 1 OPERATION_OVERRIDE
, O.OPRN_LINE_ID
, O.RESOURCES
, R.SEQUENCE_NO
, O.PARAMETER_ID
, O.TARGET_VALUE
, O.MINIMUM_VALUE
, O.MAXIMUM_VALUE
, O.CREATION_DATE
, O.LAST_UPDATE_LOGIN
, O.CREATED_BY
, O.LAST_UPDATE_DATE
, O.LAST_UPDATED_BY
FROM GMD_OPRN_PROCESS_PARAMETERS O
, GMP_RESOURCE_PARAMETERS R
WHERE O.RESOURCES = R.RESOURCES
AND O.PARAMETER_ID = R.PARAMETER_ID UNION SELECT 0 OPERATION_OVERRIDE
, O.OPRN_LINE_ID
, R.RESOURCES
, R.SEQUENCE_NO
, R.PARAMETER_ID
, R.TARGET_VALUE
, R.MINIMUM_VALUE
, R.MAXIMUM_VALUE
, R.CREATION_DATE
, R.LAST_UPDATE_LOGIN
, R.CREATED_BY
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
FROM GMP_RESOURCE_PARAMETERS R
, GMD_OPERATION_RESOURCES O
WHERE R.RESOURCES = O.RESOURCES
AND NOT EXISTS (SELECT 1
FROM GMD_OPRN_PROCESS_PARAMETERS P
WHERE P.RESOURCES = R.RESOURCES
AND P.PARAMETER_ID = R.PARAMETER_ID
AND P.OPRN_LINE_ID = O.OPRN_LINE_ID)

Columns