VIEW: APPS.JTF_BRM_EXPRESSION_LINES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)