View: JTF_BRM_EXPRESSION_LINES_V

Product:	JTF - CRM Foundation
Description:	View used in the simple tab of the business rule workbench form.
Implementation/DBA Data:	APPS.JTF_BRM_EXPRESSION_LINES_V

View Text

SELECT JBE.ROWID ROW_ID
, JBE.EXPRESSION_LINE_ID
, JBE.RULE_ID
, JBE.SORT_SEQUENCE
, JBE.BRM_LEFT_PARENTHESIS_TYPE
, JBE.BRM_LEFT_PARENTHESIS_CODE
, FL1.MEANING BRM_LEFT_PARENTHESIS
, JBE.LEFT_VALUE
, JBE.BRM_OPERATOR_TYPE
, JBE.BRM_OPERATOR_CODE
, FL2.MEANING BRM_OPERATOR
, JBE.RIGHT_VALUE
, JBE.BRM_RIGHT_PARENTHESIS_TYPE
, JBE.BRM_RIGHT_PARENTHESIS_CODE
, FL3.MEANING BRM_RIGHT_PARENTHESIS
, JBE.BRM_BOOLEAN_OPERATOR_TYPE
, JBE.BRM_BOOLEAN_OPERATOR_CODE
, FL4.MEANING BRM_BOOLEAN_OPERATOR
FROM JTF_BRM_EXPRESSION_LINES JBE
, (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_LEFT_PARENTHESIS_TYPE'
AND FND.ENABLED_FLAG = 'Y'
AND ( FND.START_DATE_ACTIVE <= TRUNC(SYSDATE) OR FND.START_DATE_ACTIVE IS NULL )
AND ( FND.END_DATE_ACTIVE > TRUNC(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_OPERATOR_TYPE'
AND FND.ENABLED_FLAG = 'Y'
AND ( FND.START_DATE_ACTIVE <= TRUNC(SYSDATE) OR FND.START_DATE_ACTIVE IS NULL )
AND ( FND.END_DATE_ACTIVE > TRUNC(SYSDATE) OR FND.END_DATE_ACTIVE IS NULL ) )FL2
, (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_RIGHT_PARENTHESIS_TYPE'
AND FND.ENABLED_FLAG = 'Y'
AND ( FND.START_DATE_ACTIVE <= TRUNC(SYSDATE) OR FND.START_DATE_ACTIVE IS NULL )
AND ( FND.END_DATE_ACTIVE > TRUNC(SYSDATE) OR FND.END_DATE_ACTIVE IS NULL ) )FL3
, (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_BOOLEAN_OPERATOR_TYPE'
AND FND.ENABLED_FLAG = 'Y'
AND ( FND.START_DATE_ACTIVE <= TRUNC(SYSDATE) OR FND.START_DATE_ACTIVE IS NULL )
AND ( FND.END_DATE_ACTIVE > TRUNC(SYSDATE) OR FND.END_DATE_ACTIVE IS NULL ) )FL4
WHERE JBE.BRM_LEFT_PARENTHESIS_TYPE = FL1.LOOKUP_TYPE(+)
AND JBE.BRM_OPERATOR_TYPE = FL2.LOOKUP_TYPE(+)
AND JBE.BRM_RIGHT_PARENTHESIS_TYPE = FL3.LOOKUP_TYPE(+)
AND JBE.BRM_BOOLEAN_OPERATOR_TYPE = FL4.LOOKUP_TYPE(+)
AND JBE.BRM_LEFT_PARENTHESIS_CODE = FL1.LOOKUP_CODE(+)
AND JBE.BRM_OPERATOR_CODE = FL2.LOOKUP_CODE(+)
AND JBE.BRM_RIGHT_PARENTHESIS_CODE = FL3.LOOKUP_CODE(+)
AND JBE.BRM_BOOLEAN_OPERATOR_CODE = FL4.LOOKUP_CODE(+)

Columns