VRM_PRICE_SEGMENT_ASSIGNS

Details

Schema: FUSION
Object owner: VRM
Object type: VIEW

Columns

Name
COLUMN_NAME ATTRIBUTE_ID DOCUMENT_TYPE_ID STRUCTURE_INSTANCE_NUMBER DIMENSION_ASSIGNMENT_ID SEGMENTS_ASSIGNMENT_ID TEMPLATE_ID

Name

COLUMN_NAME

ATTRIBUTE_ID

DOCUMENT_TYPE_ID

STRUCTURE_INSTANCE_NUMBER

DIMENSION_ASSIGNMENT_ID

SEGMENTS_ASSIGNMENT_ID

TEMPLATE_ID

Query

SQL_Statement
SELECT DECODE(period_number,1,'SEGMENT1',2,'SEGMENT2',3,'SEGMENT3',4,'SEGMENT4',5,'SEGMENT5' , 6,'SEGMENT6',7,'SEGMENT7',8,'SEGMENT8',9,'SEGMENT9',10,'SEGMENT10' , 11,'SEGMENT11',12,'SEGMENT12',13,'SEGMENT13',14,'SEGMENT14',15,'SEGMENT15' , 16,'SEGMENT16',17,'SEGMENT17',18,'SEGMENT18',19,'SEGMENT19',20,'SEGMENT20' , 21,'SEGMENT21',22,'SEGMENT22',23,'SEGMENT23',24,'SEGMENT24',25,'SEGMENT25' , 26,'SEGMENT26',27,'SEGMENT27',28,'SEGMENT28',29,'SEGMENT29',30,'SEGMENT30' ) COLUMN_NAME, DECODE(period_number,1,psa.segment_attribute_1,2,psa.segment_attribute_2,3,psa.segment_attribute_3,4,psa.segment_attribute_4,5,psa.segment_attribute_5, 6,psa.segment_attribute_6,7,psa.segment_attribute_7,8,psa.segment_attribute_8,9,psa.segment_attribute_9,10,psa.segment_attribute_10, 11,psa.segment_attribute_11,12,psa.segment_attribute_12,13,psa.segment_attribute_13,14,psa.segment_attribute_14,15,psa.segment_attribute_15, 16,psa.segment_attribute_16,17,psa.segment_attribute_17,18,psa.segment_attribute_18,19,psa.segment_attribute_19,20,psa.segment_attribute_20, 21,psa.segment_attribute_21,22,psa.segment_attribute_22,23,psa.segment_attribute_23,24,psa.segment_attribute_24,25,psa.segment_attribute_25, 26,psa.segment_attribute_26,27,psa.segment_attribute_27,28,psa.segment_attribute_28,29,psa.segment_attribute_29,30,psa.segment_attribute_30 ) ATTRIBUTE_ID, psa.document_type_id, psa.structure_instance_number, psa.dimension_assignment_id, psa.segments_assignment_id, psa.template_id FROM vrm_price_segment_assigns psa, ra_rule_schedules ra WHERE ra.rule_id = -1 AND ra.period_number <=30

SQL_Statement

SELECT DECODE(period_number,1,'SEGMENT1',2,'SEGMENT2',3,'SEGMENT3',4,'SEGMENT4',5,'SEGMENT5' ,

6,'SEGMENT6',7,'SEGMENT7',8,'SEGMENT8',9,'SEGMENT9',10,'SEGMENT10' ,

11,'SEGMENT11',12,'SEGMENT12',13,'SEGMENT13',14,'SEGMENT14',15,'SEGMENT15' ,

16,'SEGMENT16',17,'SEGMENT17',18,'SEGMENT18',19,'SEGMENT19',20,'SEGMENT20' ,

21,'SEGMENT21',22,'SEGMENT22',23,'SEGMENT23',24,'SEGMENT24',25,'SEGMENT25' ,

26,'SEGMENT26',27,'SEGMENT27',28,'SEGMENT28',29,'SEGMENT29',30,'SEGMENT30' ) COLUMN_NAME,

DECODE(period_number,1,psa.segment_attribute_1,2,psa.segment_attribute_2,3,psa.segment_attribute_3,4,psa.segment_attribute_4,5,psa.segment_attribute_5,

6,psa.segment_attribute_6,7,psa.segment_attribute_7,8,psa.segment_attribute_8,9,psa.segment_attribute_9,10,psa.segment_attribute_10,

11,psa.segment_attribute_11,12,psa.segment_attribute_12,13,psa.segment_attribute_13,14,psa.segment_attribute_14,15,psa.segment_attribute_15,

16,psa.segment_attribute_16,17,psa.segment_attribute_17,18,psa.segment_attribute_18,19,psa.segment_attribute_19,20,psa.segment_attribute_20,

21,psa.segment_attribute_21,22,psa.segment_attribute_22,23,psa.segment_attribute_23,24,psa.segment_attribute_24,25,psa.segment_attribute_25,

26,psa.segment_attribute_26,27,psa.segment_attribute_27,28,psa.segment_attribute_28,29,psa.segment_attribute_29,30,psa.segment_attribute_30

) ATTRIBUTE_ID,

psa.document_type_id,

psa.structure_instance_number,

psa.dimension_assignment_id,

psa.segments_assignment_id,

psa.template_id

FROM vrm_price_segment_assigns psa,

ra_rule_schedules ra

WHERE ra.rule_id = -1

AND ra.period_number <=30