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)), (DECODE (BILLING_ATTRIBUTE_CATEGORY, 'FIRST WEEKDAY OF MONTH', BILLING_VALUE1, NULL)), (DECODE (BILLING_ATTRIBUTE_CATEGORY, 'LAST WEEKDAY OF MONTH', BILLING_VALUE1, NULL)), (DECODE (BILLING_ATTRIBUTE_CATEGORY, 'USER DEFINED', BILLING_VALUE3, NULL)), (DECODE (BILLING_ATTRIBUTE_CATEGORY, 'USER DEFINED', BILLING_VALUE4, NULL)), (DECODE (BILLING_ATTRIBUTE_CATEGORY, 'USER DEFINED', BILLING_VALUE5, NULL)), (DECODE (BILLING_ATTRIBUTE_CATEGORY, 'WEEKDAY EACH WEEK', BILLING_VALUE1, NULL)),
(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
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))
, (DECODE (BILLING_ATTRIBUTE_CATEGORY
, 'FIRST WEEKDAY OF MONTH'
, BILLING_VALUE1
, NULL))
, (DECODE (BILLING_ATTRIBUTE_CATEGORY
, 'LAST WEEKDAY OF MONTH'
, BILLING_VALUE1
, NULL))
, (DECODE (BILLING_ATTRIBUTE_CATEGORY
, 'USER DEFINED'
, BILLING_VALUE3
, NULL))
, (DECODE (BILLING_ATTRIBUTE_CATEGORY
, 'USER DEFINED'
, BILLING_VALUE4
, NULL))
, (DECODE (BILLING_ATTRIBUTE_CATEGORY
, 'USER DEFINED'
, BILLING_VALUE5
, NULL))
, (DECODE (BILLING_ATTRIBUTE_CATEGORY
, 'WEEKDAY EACH WEEK'
, BILLING_VALUE1
, NULL))
,
(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
|
|
|