VIEW: APPS.GMD_OPRN_PROCESS_PARAMETERS_V1

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)