VIEW: APPS.PA_BILLING_CYCLES_DFV

Source

View Text - Preformatted

SELECT ROWID, BILLING_ATTRIBUTE_CATEGORY, (DECODE (BILLING_ATTRIBUTE_CATEGORY, 'USER DEFINED', FND_NUMBER.CANONICAL_TO_NUMBER(BILLING_VALUE1), 'DATE OF MONTH', FND_NUMBER.CANONICAL_TO_NUMBER(BILLING_VALUE1), 'BILLING CYCLE DAYS', FND_NUMBER.CANONICAL_TO_NUMBER(BILLING_VALUE1), NULL)), (DECODE (BILLING_ATTRIBUTE_CATEGORY, 'USER DEFINED', FND_NUMBER.CANONICAL_TO_NUMBER(BILLING_VALUE2), 'DATE OF MONTH', FND_NUMBER.CANONICAL_TO_NUMBER(BILLING_VALUE2), NULL)), (DECODE (BILLING_ATTRIBUTE_CATEGORY, 'DATE OF MONTH', FND_NUMBER.CANONICAL_TO_NUMBER(BILLING_VALUE3), NULL)), BILLING_VALUE1, BILLING_VALUE1, BILLING_VALUE3, BILLING_VALUE4, BILLING_VALUE5, BILLING_VALUE1,  
 (DECODE (BILLING_ATTRIBUTE_CATEGORY,  
      'BILLING CYCLE DAYS', BILLING_ATTRIBUTE_CATEGORY || '.' || BILLING_VALUE1,  
      'DATE OF MONTH', BILLING_ATTRIBUTE_CATEGORY || '.' || BILLING_VALUE1 || '.' || BILLING_VALUE2 || '.' || BILLING_VALUE3,  
      'FIRST WEEKDAY OF MONTH', BILLING_ATTRIBUTE_CATEGORY || '.' || BILLING_VALUE1,  
      'LAST WEEKDAY OF MONTH', BILLING_ATTRIBUTE_CATEGORY || '.' || BILLING_VALUE1,  
      'USER DEFINED', BILLING_ATTRIBUTE_CATEGORY || '.' || BILLING_VALUE1 || '.' || BILLING_VALUE2 || '.' || BILLING_VALUE3 || '.' || BILLING_VALUE4 || '.' || BILLING_VALUE5,  
      'WEEKDAY EACH WEEK', BILLING_ATTRIBUTE_CATEGORY || '.' || BILLING_VALUE1, NULL)) 
 FROM PA_BILLING_CYCLES

View Text - HTML Formatted

SELECT ROWID
, BILLING_ATTRIBUTE_CATEGORY
, (DECODE (BILLING_ATTRIBUTE_CATEGORY
, 'USER DEFINED'
, FND_NUMBER.CANONICAL_TO_NUMBER(BILLING_VALUE1)
, 'DATE OF MONTH'
, FND_NUMBER.CANONICAL_TO_NUMBER(BILLING_VALUE1)
, 'BILLING CYCLE DAYS'
, FND_NUMBER.CANONICAL_TO_NUMBER(BILLING_VALUE1)
, NULL))
, (DECODE (BILLING_ATTRIBUTE_CATEGORY
, 'USER DEFINED'
, FND_NUMBER.CANONICAL_TO_NUMBER(BILLING_VALUE2)
, 'DATE OF MONTH'
, FND_NUMBER.CANONICAL_TO_NUMBER(BILLING_VALUE2)
, NULL))
, (DECODE (BILLING_ATTRIBUTE_CATEGORY
, 'DATE OF MONTH'
, FND_NUMBER.CANONICAL_TO_NUMBER(BILLING_VALUE3)
, NULL))
, BILLING_VALUE1
, BILLING_VALUE1
, BILLING_VALUE3
, BILLING_VALUE4
, BILLING_VALUE5
, BILLING_VALUE1
, (DECODE (BILLING_ATTRIBUTE_CATEGORY
, 'BILLING CYCLE DAYS'
, BILLING_ATTRIBUTE_CATEGORY || '.' || BILLING_VALUE1
, 'DATE OF MONTH'
, BILLING_ATTRIBUTE_CATEGORY || '.' || BILLING_VALUE1 || '.' || BILLING_VALUE2 || '.' || BILLING_VALUE3
, 'FIRST WEEKDAY OF MONTH'
, BILLING_ATTRIBUTE_CATEGORY || '.' || BILLING_VALUE1
, 'LAST WEEKDAY OF MONTH'
, BILLING_ATTRIBUTE_CATEGORY || '.' || BILLING_VALUE1
, 'USER DEFINED'
, BILLING_ATTRIBUTE_CATEGORY || '.' || BILLING_VALUE1 || '.' || BILLING_VALUE2 || '.' || BILLING_VALUE3 || '.' || BILLING_VALUE4 || '.' || BILLING_VALUE5
, 'WEEKDAY EACH WEEK'
, BILLING_ATTRIBUTE_CATEGORY || '.' || BILLING_VALUE1
, NULL))
FROM PA_BILLING_CYCLES