Product: | AS - Sales Foundation |
---|---|
Description: | Promotion relationships view |
Implementation/DBA Data: | Not implemented in this database |
SELECT PROMREL.ROWID
, PROMREL.PROMOTION_RELATIONSHIP_ID
, PROMREL.PARENT_PROMOTION_ID
, PROMREL.CHILD_PROMOTION_ID
, PROMREL.LAST_UPDATE_DATE
, PROMREL.LAST_UPDATED_BY
, PROMREL.CREATION_DATE
, PROMREL.CREATED_BY
, PROMREL.LAST_UPDATE_LOGIN
, CHILDPROM.TYPE
, CHILDPROM.CODE
, CHILDPROM.NAME
, ASLKP1.MEANING
, PROMREL.ATTRIBUTE_CATEGORY
, PROMREL.ATTRIBUTE1
, PROMREL.ATTRIBUTE2
, PROMREL.ATTRIBUTE3
, PROMREL.ATTRIBUTE4
, PROMREL.ATTRIBUTE5
, PROMREL.ATTRIBUTE6
, PROMREL.ATTRIBUTE7
, PROMREL.ATTRIBUTE8
, PROMREL.ATTRIBUTE9
, PROMREL.ATTRIBUTE10
, PROMREL.ATTRIBUTE11
, PROMREL.ATTRIBUTE12
, PROMREL.ATTRIBUTE13
, PROMREL.ATTRIBUTE14
, PROMREL.ATTRIBUTE15
FROM AS_PROMOTION_RELATIONSHIPS PROMREL
, AS_LOOKUPS ASLKP1
, AS_PROMOTIONS CHILDPROM
WHERE PROMREL.CHILD_PROMOTION_ID = CHILDPROM.PROMOTION_ID
AND CHILDPROM.TYPE = ASLKP1.LOOKUP_CODE(+)
AND ASLKP1.LOOKUP_TYPE(+) = 'PROMOTION_TYPE'