VIEW: APPS.JE_GR_TRNOVR_RULE_LINES_V

Source

View Text - Preformatted

SELECT trl.rowid row_id, trl.trnovr_rule_line_id , trl.trnovr_rule_id , trl.application_id, trl.lookup_type , lt.meaning group_type, trl.lookup_code, lv.meaning group_name, lv.description, trl.exclude_flag , trl.creation_date , trl.created_by , trl.last_updated_by , trl.last_update_date , trl.last_update_login , trl.attribute_category , trl.attribute1 , trl.attribute2 , trl.attribute3 , trl.attribute4 , trl.attribute5 , trl.attribute6 , trl.attribute7 , trl.attribute8 , trl.attribute9 , trl.attribute10 , trl.attribute11 , trl.attribute12 , trl.attribute13 , trl.attribute14 , trl.attribute15 from je_gr_trnovr_rule_lines trl, fnd_lookup_values_vl lv, fnd_lookup_types_vl lt WHERE trl.lookup_code = lv.lookup_code and trl.lookup_type = lv.lookup_type and lv.lookup_type = lt.lookup_type and lv.enabled_flag = 'Y' and trl.application_id = lt.application_id and trl.lookup_type <> 'VENDOR TYPE' UNION SELECT trl.rowid row_id, trl.trnovr_rule_line_id , trl.trnovr_rule_id , trl.application_id, trl.lookup_type , lt.meaning group_type, trl.lookup_code, lv.meaning group_name, lv.description, trl.exclude_flag , trl.creation_date , trl.created_by , trl.last_updated_by , trl.last_update_date , trl.last_update_login , trl.attribute_category , trl.attribute1 , trl.attribute2 , trl.attribute3 , trl.attribute4 , trl.attribute5 , trl.attribute6 , trl.attribute7 , trl.attribute8 , trl.attribute9 , trl.attribute10 , trl.attribute11 , trl.attribute12 , trl.attribute13 , trl.attribute14 , trl.attribute15 from je_gr_trnovr_rule_lines trl, fnd_lookup_values_vl lv, fnd_lookup_types_vl lt WHERE trl.lookup_code = lv.lookup_code and trl.lookup_type = lv.lookup_type and lv.lookup_type = lt.lookup_type and lv.enabled_flag = 'Y' and trl.lookup_type = 'VENDOR TYPE'

View Text - HTML Formatted

SELECT TRL.ROWID ROW_ID
, TRL.TRNOVR_RULE_LINE_ID
, TRL.TRNOVR_RULE_ID
, TRL.APPLICATION_ID
, TRL.LOOKUP_TYPE
, LT.MEANING GROUP_TYPE
, TRL.LOOKUP_CODE
, LV.MEANING GROUP_NAME
, LV.DESCRIPTION
, TRL.EXCLUDE_FLAG
, TRL.CREATION_DATE
, TRL.CREATED_BY
, TRL.LAST_UPDATED_BY
, TRL.LAST_UPDATE_DATE
, TRL.LAST_UPDATE_LOGIN
, TRL.ATTRIBUTE_CATEGORY
, TRL.ATTRIBUTE1
, TRL.ATTRIBUTE2
, TRL.ATTRIBUTE3
, TRL.ATTRIBUTE4
, TRL.ATTRIBUTE5
, TRL.ATTRIBUTE6
, TRL.ATTRIBUTE7
, TRL.ATTRIBUTE8
, TRL.ATTRIBUTE9
, TRL.ATTRIBUTE10
, TRL.ATTRIBUTE11
, TRL.ATTRIBUTE12
, TRL.ATTRIBUTE13
, TRL.ATTRIBUTE14
, TRL.ATTRIBUTE15
FROM JE_GR_TRNOVR_RULE_LINES TRL
, FND_LOOKUP_VALUES_VL LV
, FND_LOOKUP_TYPES_VL LT
WHERE TRL.LOOKUP_CODE = LV.LOOKUP_CODE
AND TRL.LOOKUP_TYPE = LV.LOOKUP_TYPE
AND LV.LOOKUP_TYPE = LT.LOOKUP_TYPE
AND LV.ENABLED_FLAG = 'Y'
AND TRL.APPLICATION_ID = LT.APPLICATION_ID
AND TRL.LOOKUP_TYPE <> 'VENDOR TYPE' UNION SELECT TRL.ROWID ROW_ID
, TRL.TRNOVR_RULE_LINE_ID
, TRL.TRNOVR_RULE_ID
, TRL.APPLICATION_ID
, TRL.LOOKUP_TYPE
, LT.MEANING GROUP_TYPE
, TRL.LOOKUP_CODE
, LV.MEANING GROUP_NAME
, LV.DESCRIPTION
, TRL.EXCLUDE_FLAG
, TRL.CREATION_DATE
, TRL.CREATED_BY
, TRL.LAST_UPDATED_BY
, TRL.LAST_UPDATE_DATE
, TRL.LAST_UPDATE_LOGIN
, TRL.ATTRIBUTE_CATEGORY
, TRL.ATTRIBUTE1
, TRL.ATTRIBUTE2
, TRL.ATTRIBUTE3
, TRL.ATTRIBUTE4
, TRL.ATTRIBUTE5
, TRL.ATTRIBUTE6
, TRL.ATTRIBUTE7
, TRL.ATTRIBUTE8
, TRL.ATTRIBUTE9
, TRL.ATTRIBUTE10
, TRL.ATTRIBUTE11
, TRL.ATTRIBUTE12
, TRL.ATTRIBUTE13
, TRL.ATTRIBUTE14
, TRL.ATTRIBUTE15
FROM JE_GR_TRNOVR_RULE_LINES TRL
, FND_LOOKUP_VALUES_VL LV
, FND_LOOKUP_TYPES_VL LT
WHERE TRL.LOOKUP_CODE = LV.LOOKUP_CODE
AND TRL.LOOKUP_TYPE = LV.LOOKUP_TYPE
AND LV.LOOKUP_TYPE = LT.LOOKUP_TYPE
AND LV.ENABLED_FLAG = 'Y'
AND TRL.LOOKUP_TYPE = 'VENDOR TYPE'