View: JE_GR_TRNOVR_RULE_LINES_V

Product:	JE - European Localizations
Description:
Implementation/DBA Data:	APPS.JE_GR_TRNOVR_RULE_LINES_V

View Text

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'

Columns