VIEW: APPS.QP_ATTRIBUTE_DEFNS_DFV

Source

View Text - Preformatted

SELECT ROWID, PRICING_CONTEXT, (DECODE (PRICING_CONTEXT, 'AHL_PRICING', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE1), NULL)), (DECODE (PRICING_CONTEXT, 'BREAK_UOM', PRICING_ATTRIBUTE1, NULL)), (DECODE (PRICING_CONTEXT, 'ITEM', PRICING_ATTRIBUTE1, NULL)), (DECODE (PRICING_CONTEXT, 'ITEM', PRICING_ATTRIBUTE2, NULL)), (DECODE (PRICING_CONTEXT, 'ITEM', PRICING_ATTRIBUTE24, NULL)), (DECODE (PRICING_CONTEXT, 'ITEM', PRICING_ATTRIBUTE3, NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', PRICING_ATTRIBUTE10, NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE1), NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', PRICING_ATTRIBUTE17, NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', PRICING_ATTRIBUTE18, NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', PRICING_ATTRIBUTE19, NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', PRICING_ATTRIBUTE12, NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', PRICING_ATTRIBUTE22, NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE16), NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', PRICING_ATTRIBUTE11, NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', PRICING_ATTRIBUTE13, NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', PRICING_ATTRIBUTE14, NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', PRICING_ATTRIBUTE20, NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', PRICING_ATTRIBUTE21, NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE15), NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', PRICING_ATTRIBUTE2, NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', PRICING_ATTRIBUTE3, NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE7), NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE8), NULL)), (DECODE (PRICING_CONTEXT, 'LOGISTICS', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE9), NULL)), (DECODE (PRICING_CONTEXT, 'OTA', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE1), NULL)), (DECODE (PRICING_CONTEXT, 'PERIODICITY', PRICING_ATTRIBUTE1, NULL)), (DECODE (PRICING_CONTEXT, 'PO_PRICING_ATTRIBUTES', PRICING_ATTRIBUTE4, NULL)), (DECODE (PRICING_CONTEXT, 'PO_PRICING_ATTRIBUTES', PRICING_ATTRIBUTE7, NULL)), (DECODE (PRICING_CONTEXT, 'PO_PRICING_ATTRIBUTES', PRICING_ATTRIBUTE8, NULL)), (DECODE (PRICING_CONTEXT, 'PO_PRICING_ATTRIBUTES', PRICING_ATTRIBUTE9, NULL)), (DECODE (PRICING_CONTEXT, 'PO_PRICING_ATTRIBUTES', PRICING_ATTRIBUTE10, NULL)), (DECODE (PRICING_CONTEXT, 'PO_PRICING_ATTRIBUTES', PRICING_ATTRIBUTE12, NULL)), (DECODE (PRICING_CONTEXT, 'PO_PRICING_ATTRIBUTES', PRICING_ATTRIBUTE13, NULL)), (DECODE (PRICING_CONTEXT, 'PO_PRICING_ATTRIBUTES', PRICING_ATTRIBUTE6, NULL)), (DECODE (PRICING_CONTEXT, 'PO_PRICING_ATTRIBUTES', PRICING_ATTRIBUTE15, NULL)), (DECODE (PRICING_CONTEXT, 'PR-CRB', PRICING_ATTRIBUTE30, NULL)), (DECODE (PRICING_CONTEXT, 'PRICING ATTRIBUTE', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE10), NULL)), (DECODE (PRICING_CONTEXT, 'PRICING ATTRIBUTE', PRICING_ATTRIBUTE11, NULL)), (DECODE (PRICING_CONTEXT, 'PRICING ATTRIBUTE', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE12), NULL)), (DECODE (PRICING_CONTEXT, 'PRICING ATTRIBUTE', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE13), NULL)), (DECODE (PRICING_CONTEXT, 'PRICING ATTRIBUTE', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE14), NULL)), (DECODE (PRICING_CONTEXT, 'PRICING ATTRIBUTE', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE15), NULL)), (DECODE (PRICING_CONTEXT, 'PRICING ATTRIBUTE', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE16), NULL)), (DECODE (PRICING_CONTEXT, 'PRICING ATTRIBUTE', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE17), NULL)), (DECODE (PRICING_CONTEXT, 'PRICING ATTRIBUTE', PRICING_ATTRIBUTE1, NULL)), (DECODE (PRICING_CONTEXT, 'PRICING ATTRIBUTE', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE20), NULL)), (DECODE (PRICING_CONTEXT, 'PRICING ATTRIBUTE', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE21), NULL)), (DECODE (PRICING_CONTEXT, 'QP_INTERNAL', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE1), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', PRICING_ATTRIBUTE85, NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE10), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE12), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE3), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE21), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE22), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE23), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE24), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE25), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE26), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE27), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE28), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE29), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE1), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE30), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE31), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE32), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE33), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE34), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE35), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE36), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE37), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE38), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE39), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE40), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE11), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE41), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE42), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE43), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE44), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE45), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE46), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE13), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE14), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE15), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE20), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE6), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE4), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE5), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE7), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE8), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE2), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE18), NULL)), (DECODE (PRICING_CONTEXT, 'VOLUME', FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE19), NULL)),  
 (DECODE (PRICING_CONTEXT,  
      'AHL_PRICING', PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE1,  
      'BREAK_UOM', PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE1,  
      'ITEM', PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE1 || '.' || PRICING_ATTRIBUTE2 || '.' || PRICING_ATTRIBUTE24 || '.' || PRICING_ATTRIBUTE3,  
      'LOGISTICS', PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE10 || '.' || PRICING_ATTRIBUTE1 || '.' || PRICING_ATTRIBUTE17 || '.' || PRICING_ATTRIBUTE18 || '.' || PRICING_ATTRIBUTE19 || '.' || PRICING_ATTRIBUTE12 || '.' || PRICING_ATTRIBUTE22 || '.' || PRICING_ATTRIBUTE16 || '.' || PRICING_ATTRIBUTE11 || '.' || PRICING_ATTRIBUTE13 || '.' || PRICING_ATTRIBUTE14 || '.' || PRICING_ATTRIBUTE20 || '.' || PRICING_ATTRIBUTE21 || '.' || PRICING_ATTRIBUTE15 || '.' || PRICING_ATTRIBUTE2 || '.' || PRICING_ATTRIBUTE3 || '.' || PRICING_ATTRIBUTE7 || '.' || PRICING_ATTRIBUTE8 || '.' || PRICING_ATTRIBUTE9,  
      'OTA', PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE1,  
      'PERIODICITY', PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE1,  
      'PO_PRICING_ATTRIBUTES', PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE4 || '.' || PRICING_ATTRIBUTE7 || '.' || PRICING_ATTRIBUTE8 || '.' || PRICING_ATTRIBUTE9 || '.' || PRICING_ATTRIBUTE10 || '.' || PRICING_ATTRIBUTE12 || '.' || PRICING_ATTRIBUTE13 || '.' || PRICING_ATTRIBUTE6 || '.' || PRICING_ATTRIBUTE15,  
      'PR-CRB', PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE30,  
      'PRICING ATTRIBUTE', PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE10 || '.' || PRICING_ATTRIBUTE11 || '.' || PRICING_ATTRIBUTE12 || '.' || PRICING_ATTRIBUTE13 || '.' || PRICING_ATTRIBUTE14 || '.' || PRICING_ATTRIBUTE15 || '.' || PRICING_ATTRIBUTE16 || '.' || PRICING_ATTRIBUTE17 || '.' || PRICING_ATTRIBUTE1 || '.' || PRICING_ATTRIBUTE20 || '.' || PRICING_ATTRIBUTE21,  
      'QP_INTERNAL', PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE1,  
      'VOLUME', PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE85 || '.' || PRICING_ATTRIBUTE10 || '.' || PRICING_ATTRIBUTE12 || '.' || PRICING_ATTRIBUTE3 || '.' || PRICING_ATTRIBUTE21 || '.' || PRICING_ATTRIBUTE22 || '.' || PRICING_ATTRIBUTE23 || '.' || PRICING_ATTRIBUTE24 || '.' || PRICING_ATTRIBUTE25 || '.' || PRICING_ATTRIBUTE26 || '.' || PRICING_ATTRIBUTE27 || '.' || PRICING_ATTRIBUTE28 || '.' || PRICING_ATTRIBUTE29 || '.' || PRICING_ATTRIBUTE1 || '.' || PRICING_ATTRIBUTE30 || '.' || PRICING_ATTRIBUTE31 || '.' || PRICING_ATTRIBUTE32 || '.' || PRICING_ATTRIBUTE33 || '.' || PRICING_ATTRIBUTE34 || '.' || PRICING_ATTRIBUTE35 || '.' || PRICING_ATTRIBUTE36 || '.' || PRICING_ATTRIBUTE37 || '.' || PRICING_ATTRIBUTE38 || '.' || PRICING_ATTRIBUTE39 || '.' || PRICING_ATTRIBUTE40 || '.' || PRICING_ATTRIBUTE11 || '.' || PRICING_ATTRIBUTE41 || '.' || PRICING_ATTRIBUTE42 || '.' || PRICING_ATTRIBUTE43 || '.' || PRICING_ATTRIBUTE44 || '.' || PRICING_ATTRIBUTE45 || '.' || PRICING_ATTRIBUTE46 || '.' || PRICING_ATTRIBUTE13 || '.' || PRICING_ATTRIBUTE14 || '.' || PRICING_ATTRIBUTE15 || '.' || PRICING_ATTRIBUTE20 || '.' || PRICING_ATTRIBUTE6 || '.' || PRICING_ATTRIBUTE4 || '.' || PRICING_ATTRIBUTE5 || '.' || PRICING_ATTRIBUTE7 || '.' || PRICING_ATTRIBUTE8 || '.' || PRICING_ATTRIBUTE2 || '.' || PRICING_ATTRIBUTE18 || '.' || PRICING_ATTRIBUTE19, NULL)) 
 FROM QP_ATTRIBUTE_DEFNS

View Text - HTML Formatted

SELECT ROWID
, PRICING_CONTEXT
, (DECODE (PRICING_CONTEXT
, 'AHL_PRICING'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE1)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'BREAK_UOM'
, PRICING_ATTRIBUTE1
, NULL))
, (DECODE (PRICING_CONTEXT
, 'ITEM'
, PRICING_ATTRIBUTE1
, NULL))
, (DECODE (PRICING_CONTEXT
, 'ITEM'
, PRICING_ATTRIBUTE2
, NULL))
, (DECODE (PRICING_CONTEXT
, 'ITEM'
, PRICING_ATTRIBUTE24
, NULL))
, (DECODE (PRICING_CONTEXT
, 'ITEM'
, PRICING_ATTRIBUTE3
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, PRICING_ATTRIBUTE10
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE1)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, PRICING_ATTRIBUTE17
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, PRICING_ATTRIBUTE18
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, PRICING_ATTRIBUTE19
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, PRICING_ATTRIBUTE12
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, PRICING_ATTRIBUTE22
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE16)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, PRICING_ATTRIBUTE11
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, PRICING_ATTRIBUTE13
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, PRICING_ATTRIBUTE14
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, PRICING_ATTRIBUTE20
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, PRICING_ATTRIBUTE21
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE15)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, PRICING_ATTRIBUTE2
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, PRICING_ATTRIBUTE3
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE7)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE8)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'LOGISTICS'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE9)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'OTA'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE1)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PERIODICITY'
, PRICING_ATTRIBUTE1
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PO_PRICING_ATTRIBUTES'
, PRICING_ATTRIBUTE4
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PO_PRICING_ATTRIBUTES'
, PRICING_ATTRIBUTE7
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PO_PRICING_ATTRIBUTES'
, PRICING_ATTRIBUTE8
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PO_PRICING_ATTRIBUTES'
, PRICING_ATTRIBUTE9
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PO_PRICING_ATTRIBUTES'
, PRICING_ATTRIBUTE10
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PO_PRICING_ATTRIBUTES'
, PRICING_ATTRIBUTE12
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PO_PRICING_ATTRIBUTES'
, PRICING_ATTRIBUTE13
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PO_PRICING_ATTRIBUTES'
, PRICING_ATTRIBUTE6
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PO_PRICING_ATTRIBUTES'
, PRICING_ATTRIBUTE15
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PR-CRB'
, PRICING_ATTRIBUTE30
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PRICING ATTRIBUTE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE10)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PRICING ATTRIBUTE'
, PRICING_ATTRIBUTE11
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PRICING ATTRIBUTE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE12)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PRICING ATTRIBUTE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE13)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PRICING ATTRIBUTE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE14)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PRICING ATTRIBUTE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE15)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PRICING ATTRIBUTE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE16)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PRICING ATTRIBUTE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE17)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PRICING ATTRIBUTE'
, PRICING_ATTRIBUTE1
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PRICING ATTRIBUTE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE20)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'PRICING ATTRIBUTE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE21)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'QP_INTERNAL'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE1)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, PRICING_ATTRIBUTE85
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE10)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE12)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE3)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE21)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE22)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE23)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE24)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE25)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE26)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE27)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE28)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE29)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE1)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE30)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE31)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE32)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE33)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE34)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE35)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE36)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE37)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE38)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE39)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE40)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE11)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE41)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE42)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE43)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE44)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE45)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE46)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE13)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE14)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE15)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE20)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE6)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE4)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE5)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE7)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE8)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE2)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE18)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'VOLUME'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRICING_ATTRIBUTE19)
, NULL))
, (DECODE (PRICING_CONTEXT
, 'AHL_PRICING'
, PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE1
, 'BREAK_UOM'
, PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE1
, 'ITEM'
, PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE1 || '.' || PRICING_ATTRIBUTE2 || '.' || PRICING_ATTRIBUTE24 || '.' || PRICING_ATTRIBUTE3
, 'LOGISTICS'
, PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE10 || '.' || PRICING_ATTRIBUTE1 || '.' || PRICING_ATTRIBUTE17 || '.' || PRICING_ATTRIBUTE18 || '.' || PRICING_ATTRIBUTE19 || '.' || PRICING_ATTRIBUTE12 || '.' || PRICING_ATTRIBUTE22 || '.' || PRICING_ATTRIBUTE16 || '.' || PRICING_ATTRIBUTE11 || '.' || PRICING_ATTRIBUTE13 || '.' || PRICING_ATTRIBUTE14 || '.' || PRICING_ATTRIBUTE20 || '.' || PRICING_ATTRIBUTE21 || '.' || PRICING_ATTRIBUTE15 || '.' || PRICING_ATTRIBUTE2 || '.' || PRICING_ATTRIBUTE3 || '.' || PRICING_ATTRIBUTE7 || '.' || PRICING_ATTRIBUTE8 || '.' || PRICING_ATTRIBUTE9
, 'OTA'
, PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE1
, 'PERIODICITY'
, PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE1
, 'PO_PRICING_ATTRIBUTES'
, PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE4 || '.' || PRICING_ATTRIBUTE7 || '.' || PRICING_ATTRIBUTE8 || '.' || PRICING_ATTRIBUTE9 || '.' || PRICING_ATTRIBUTE10 || '.' || PRICING_ATTRIBUTE12 || '.' || PRICING_ATTRIBUTE13 || '.' || PRICING_ATTRIBUTE6 || '.' || PRICING_ATTRIBUTE15
, 'PR-CRB'
, PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE30
, 'PRICING ATTRIBUTE'
, PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE10 || '.' || PRICING_ATTRIBUTE11 || '.' || PRICING_ATTRIBUTE12 || '.' || PRICING_ATTRIBUTE13 || '.' || PRICING_ATTRIBUTE14 || '.' || PRICING_ATTRIBUTE15 || '.' || PRICING_ATTRIBUTE16 || '.' || PRICING_ATTRIBUTE17 || '.' || PRICING_ATTRIBUTE1 || '.' || PRICING_ATTRIBUTE20 || '.' || PRICING_ATTRIBUTE21
, 'QP_INTERNAL'
, PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE1
, 'VOLUME'
, PRICING_CONTEXT || '.' || PRICING_ATTRIBUTE85 || '.' || PRICING_ATTRIBUTE10 || '.' || PRICING_ATTRIBUTE12 || '.' || PRICING_ATTRIBUTE3 || '.' || PRICING_ATTRIBUTE21 || '.' || PRICING_ATTRIBUTE22 || '.' || PRICING_ATTRIBUTE23 || '.' || PRICING_ATTRIBUTE24 || '.' || PRICING_ATTRIBUTE25 || '.' || PRICING_ATTRIBUTE26 || '.' || PRICING_ATTRIBUTE27 || '.' || PRICING_ATTRIBUTE28 || '.' || PRICING_ATTRIBUTE29 || '.' || PRICING_ATTRIBUTE1 || '.' || PRICING_ATTRIBUTE30 || '.' || PRICING_ATTRIBUTE31 || '.' || PRICING_ATTRIBUTE32 || '.' || PRICING_ATTRIBUTE33 || '.' || PRICING_ATTRIBUTE34 || '.' || PRICING_ATTRIBUTE35 || '.' || PRICING_ATTRIBUTE36 || '.' || PRICING_ATTRIBUTE37 || '.' || PRICING_ATTRIBUTE38 || '.' || PRICING_ATTRIBUTE39 || '.' || PRICING_ATTRIBUTE40 || '.' || PRICING_ATTRIBUTE11 || '.' || PRICING_ATTRIBUTE41 || '.' || PRICING_ATTRIBUTE42 || '.' || PRICING_ATTRIBUTE43 || '.' || PRICING_ATTRIBUTE44 || '.' || PRICING_ATTRIBUTE45 || '.' || PRICING_ATTRIBUTE46 || '.' || PRICING_ATTRIBUTE13 || '.' || PRICING_ATTRIBUTE14 || '.' || PRICING_ATTRIBUTE15 || '.' || PRICING_ATTRIBUTE20 || '.' || PRICING_ATTRIBUTE6 || '.' || PRICING_ATTRIBUTE4 || '.' || PRICING_ATTRIBUTE5 || '.' || PRICING_ATTRIBUTE7 || '.' || PRICING_ATTRIBUTE8 || '.' || PRICING_ATTRIBUTE2 || '.' || PRICING_ATTRIBUTE18 || '.' || PRICING_ATTRIBUTE19
, NULL))
FROM QP_ATTRIBUTE_DEFNS