View: JTF_BRM_PARAMETERS_V

Product:	JTF - CRM Foundation
Description:	View used for the business rule monitor form.
Implementation/DBA Data:	APPS.JTF_BRM_PARAMETERS_V

View Text

SELECT JBP.ROWID ROW_ID
, JBP.PARAMETER_ID
, JBP.CREATED_BY
, JBP.CREATION_DATE
, JBP.LAST_UPDATED_BY
, JBP.LAST_UPDATE_LOGIN
, JBP.BRM_UOM_TYPE
, JBP.BRM_UOM_CODE
, FL1.MEANING BRM_UOM_MEANING
, JBP.BRM_INTERVAL
, JBP.BRM_WF_COMMAND_TYPE
, JBP.BRM_WF_COMMAND_CODE
, FL2.MEANING BRM_WF_COMMAND_MEANING
, JBP.WORKFLOW_PROCESS_ID
, JBP.WORKFLOW_ITEM_TYPE
, JBP.WORKFLOW_PROCESS_NAME
FROM JTF_BRM_PARAMETERS JBP
, (SELECT FND.LOOKUP_TYPE
, FND.LOOKUP_CODE
, FND.MEANING
, FND.DESCRIPTION
, FND.ENABLED_FLAG
, FND.START_DATE_ACTIVE
, FND.END_DATE_ACTIVE
FROM FND_LOOKUPS FND
WHERE FND.LOOKUP_TYPE = 'JTF_BRM_UOM_TYPE'
AND FND.ENABLED_FLAG = 'Y'
AND (FND.START_DATE_ACTIVE <= SYSDATE OR FND.START_DATE_ACTIVE IS NULL)
AND (FND.END_DATE_ACTIVE > SYSDATE OR FND.END_DATE_ACTIVE IS NULL) ) FL1
, (SELECT FND.LOOKUP_TYPE
, FND.LOOKUP_CODE
, FND.MEANING
, FND.DESCRIPTION
, FND.ENABLED_FLAG
, FND.START_DATE_ACTIVE
, FND.END_DATE_ACTIVE
FROM FND_LOOKUPS FND
WHERE FND.LOOKUP_TYPE = 'JTF_BRM_WF_COMMAND_TYPE'
AND FND.ENABLED_FLAG = 'Y'
AND (FND.START_DATE_ACTIVE <= SYSDATE OR FND.START_DATE_ACTIVE IS NULL)
AND (FND.END_DATE_ACTIVE > SYSDATE OR FND.END_DATE_ACTIVE IS NULL) ) FL2
WHERE JBP.BRM_UOM_TYPE = FL1.LOOKUP_TYPE(+)
AND JBP.BRM_UOM_CODE = FL1.LOOKUP_CODE(+)
AND JBP.BRM_WF_COMMAND_TYPE = FL2.LOOKUP_TYPE(+)
AND JBP.BRM_WF_COMMAND_CODE = FL2.LOOKUP_CODE(+)

Columns