1. Tables and Views for Financials
  2. VRM_PRICE_SEG_ASSIGNMENTS_V

VRM_PRICE_SEG_ASSIGNMENTS_V

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: VIEW

Columns

Name

SEGMENTS_ASSIGNMENT_ID

TEMPLATE_ID

SEGMENT_CODE

ATTRIBUTE_ID

COLUMN_NAME

DIMENSION_ASSIGNMENT_ID

STRUCTURE_INSTANCE_NUMBER

DOCUMENT_TYPE_ID

Query

SQL_Statement

SELECT psa.segments_assignment_id,

psa.template_id,

seg.segment_code,

psa.attribute_id,

psa.column_name,

psa.dimension_assignment_id,

psa.structure_instance_number,

psa.document_type_id

FROM vrm_price_segment_assigns_v psa,

fnd_kf_str_instances_vl str,

fnd_kf_segments_b seg

WHERE psa.structure_instance_number = str.structure_instance_number

AND str.structure_id = seg.structure_id

AND str.application_id = '10455'

AND str.key_flexfield_code = 'VRM'

AND seg.column_name = psa.column_name