VIEW: APPS.PO_VENDORS1_DFV

Source

View Text - Preformatted

SELECT ROWID, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE1, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JE.IT.APXVDMVD.WHT_INFO', TO_DATE(GLOBAL_ATTRIBUTE2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE9, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.CO.APXVDMVD.SUPPLIERS', GLOBAL_ATTRIBUTE10, 'JL.CL.APXVDMVD.SUPPLIERS', GLOBAL_ATTRIBUTE10, 'JL.AR.APXVDMVD.SUPPLIERS', GLOBAL_ATTRIBUTE10, NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.CO.APXVDMVD.SUPPLIERS', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE12), 'JL.AR.APXVDMVD.SUPPLIERS', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE12), NULL)), GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.BR.APXVDMVD.VENDORS', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE3), NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.BR.APXVDMVD.VENDORS', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE4), NULL)), GLOBAL_ATTRIBUTE5, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.BR.APXVDMVD.VENDORS', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE6), NULL)), GLOBAL_ATTRIBUTE7, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.BR.APXVDMVD.VENDORS', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE8), NULL)), GLOBAL_ATTRIBUTE12,  
 (DECODE (GLOBAL_ATTRIBUTE_CATEGORY,  
      'JA.TW.APXVDMVD.PO_VENDORS', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1 || '.' || GLOBAL_ATTRIBUTE2,  
      'JE.GR.APXVDMVD.SUPPLIERS', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1,  
      'JE.IT.APXVDMVD.WHT_INFO', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE2 || '.' || GLOBAL_ATTRIBUTE3,  
      'JL.AR.APXVDMVD.SUPPLIERS', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE9 || '.' || GLOBAL_ATTRIBUTE10 || '.' || GLOBAL_ATTRIBUTE12 || '.' || GLOBAL_ATTRIBUTE15 || '.' || GLOBAL_ATTRIBUTE16 || '.' || GLOBAL_ATTRIBUTE1,  
      'JL.BR.APXVDMVD.VENDORS', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1 || '.' || GLOBAL_ATTRIBUTE2 || '.' || GLOBAL_ATTRIBUTE3 || '.' || GLOBAL_ATTRIBUTE4 || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8,  
      'JL.CL.APXVDMVD.SUPPLIERS', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE10 || '.' || GLOBAL_ATTRIBUTE12,  
      'JL.CO.APXVDMVD.SUPPLIERS', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE10 || '.' || GLOBAL_ATTRIBUTE12, NULL)) 
 FROM PO_VENDORS

View Text - HTML Formatted

SELECT ROWID
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE1
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JE.IT.APXVDMVD.WHT_INFO'
, TO_DATE(GLOBAL_ATTRIBUTE2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE9
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.CO.APXVDMVD.SUPPLIERS'
, GLOBAL_ATTRIBUTE10
, 'JL.CL.APXVDMVD.SUPPLIERS'
, GLOBAL_ATTRIBUTE10
, 'JL.AR.APXVDMVD.SUPPLIERS'
, GLOBAL_ATTRIBUTE10
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.CO.APXVDMVD.SUPPLIERS'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE12)
, 'JL.AR.APXVDMVD.SUPPLIERS'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE12)
, NULL))
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.BR.APXVDMVD.VENDORS'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE3)
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.BR.APXVDMVD.VENDORS'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE4)
, NULL))
, GLOBAL_ATTRIBUTE5
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.BR.APXVDMVD.VENDORS'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE6)
, NULL))
, GLOBAL_ATTRIBUTE7
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.BR.APXVDMVD.VENDORS'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE8)
, NULL))
, GLOBAL_ATTRIBUTE12
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JA.TW.APXVDMVD.PO_VENDORS'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1 || '.' || GLOBAL_ATTRIBUTE2
, 'JE.GR.APXVDMVD.SUPPLIERS'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1
, 'JE.IT.APXVDMVD.WHT_INFO'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE2 || '.' || GLOBAL_ATTRIBUTE3
, 'JL.AR.APXVDMVD.SUPPLIERS'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE9 || '.' || GLOBAL_ATTRIBUTE10 || '.' || GLOBAL_ATTRIBUTE12 || '.' || GLOBAL_ATTRIBUTE15 || '.' || GLOBAL_ATTRIBUTE16 || '.' || GLOBAL_ATTRIBUTE1
, 'JL.BR.APXVDMVD.VENDORS'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1 || '.' || GLOBAL_ATTRIBUTE2 || '.' || GLOBAL_ATTRIBUTE3 || '.' || GLOBAL_ATTRIBUTE4 || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || GLOBAL_ATTRIBUTE8
, 'JL.CL.APXVDMVD.SUPPLIERS'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE10 || '.' || GLOBAL_ATTRIBUTE12
, 'JL.CO.APXVDMVD.SUPPLIERS'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE10 || '.' || GLOBAL_ATTRIBUTE12
, NULL))
FROM PO_VENDORS