FND_SEGMENT_ATTRIBUTE

Details

Schema: EBS
Object owner: FND
Object type: VIEW

Columns

Name
APPLICATION_ID ID_FLEX_CODE ID_FLEX_NUM APPLICATION_COLUMN_NAME SEGMENT_ATTRIBUTE_TYPE ATTRIBUTE_VALUE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Name

APPLICATION_ID

ID_FLEX_CODE

ID_FLEX_NUM

APPLICATION_COLUMN_NAME

SEGMENT_ATTRIBUTE_TYPE

ATTRIBUTE_VALUE

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT B.APPLICATION_ID APPLICATION_ID, B.KEY_FLEXFIELD_CODE ID_FLEX_CODE, B.STRUCTURE_INSTANCE_NUMBER ID_FLEX_NUM, B.COLUMN_NAME APPLICATION_COLUMN_NAME, B.SEGMENT_LABEL_CODE SEGMENT_ATTRIBUTE_TYPE, DECODE(LS.SEGMENT_LABEL_CODE, NULL, SUBSTR(B.GLOBAL_FLAG,1,1), SUBSTR('Y', 1, 1)) ATTRIBUTE_VALUE, NVL(B.CREATION_DATE, B.CREATION_DATE) CREATION_DATE, NVL(B.CREATED_BY, B.CREATED_BY) CREATED_BY, NVL(B.LAST_UPDATE_DATE, B.LAST_UPDATE_DATE) LAST_UPDATE_DATE, NVL(B.LAST_UPDATED_BY, B.LAST_UPDATED_BY) LAST_UPDATED_BY, NVL(B.LAST_UPDATE_LOGIN, B.LAST_UPDATE_LOGIN) LAST_UPDATE_LOGIN FROM (SELECT SIB.APPLICATION_ID, SIB.KEY_FLEXFIELD_CODE, SIB.STRUCTURE_INSTANCE_NUMBER, SGB.STRUCTURE_ID, SGB.SEGMENT_CODE, SGB.COLUMN_NAME, SLB.SEGMENT_LABEL_CODE, SLB.GLOBAL_FLAG, SGI.CREATION_DATE, SGI.CREATED_BY, SGI.LAST_UPDATE_DATE, SGI.LAST_UPDATED_BY, SGI.LAST_UPDATE_LOGIN FROM FND_KF_SEGMENT_INSTANCES SGI, FND_KF_SEGMENT_LABELS_B SLB, FND_KF_STR_INSTANCES_B SIB, FND_KF_SEGMENTS_B SGB WHERE SIB.STRUCTURE_INSTANCE_ID = SGI.STRUCTURE_INSTANCE_ID AND SGB.STRUCTURE_ID = SIB.STRUCTURE_ID AND SGB.SEGMENT_CODE = SGI.SEGMENT_CODE AND SLB.APPLICATION_ID = SIB.APPLICATION_ID AND SLB.KEY_FLEXFIELD_CODE = SIB.KEY_FLEXFIELD_CODE) B, (select kls2.structure_id, kls2.segment_code, kls2.segment_label_code from fnd_kf_labeled_segments kls2 ) LS WHERE LS.STRUCTURE_ID(+) = B.STRUCTURE_ID AND LS.SEGMENT_CODE(+) = B.SEGMENT_CODE AND LS.SEGMENT_LABEL_CODE(+) = B.SEGMENT_LABEL_CODE

SQL_Statement

SELECT

B.APPLICATION_ID APPLICATION_ID,

B.KEY_FLEXFIELD_CODE ID_FLEX_CODE,

B.STRUCTURE_INSTANCE_NUMBER ID_FLEX_NUM,

B.COLUMN_NAME APPLICATION_COLUMN_NAME,

B.SEGMENT_LABEL_CODE SEGMENT_ATTRIBUTE_TYPE,

DECODE(LS.SEGMENT_LABEL_CODE,

NULL, SUBSTR(B.GLOBAL_FLAG,1,1),

SUBSTR('Y', 1, 1)) ATTRIBUTE_VALUE,

NVL(B.CREATION_DATE, B.CREATION_DATE) CREATION_DATE,

NVL(B.CREATED_BY, B.CREATED_BY) CREATED_BY,

NVL(B.LAST_UPDATE_DATE, B.LAST_UPDATE_DATE) LAST_UPDATE_DATE,

NVL(B.LAST_UPDATED_BY, B.LAST_UPDATED_BY) LAST_UPDATED_BY,

NVL(B.LAST_UPDATE_LOGIN, B.LAST_UPDATE_LOGIN) LAST_UPDATE_LOGIN

FROM (SELECT SIB.APPLICATION_ID,

SIB.KEY_FLEXFIELD_CODE,

SIB.STRUCTURE_INSTANCE_NUMBER,

SGB.STRUCTURE_ID,

SGB.SEGMENT_CODE,

SGB.COLUMN_NAME,

SLB.SEGMENT_LABEL_CODE,

SLB.GLOBAL_FLAG,

SGI.CREATION_DATE,

SGI.CREATED_BY,

SGI.LAST_UPDATE_DATE,

SGI.LAST_UPDATED_BY,

SGI.LAST_UPDATE_LOGIN

FROM FND_KF_SEGMENT_INSTANCES SGI,

FND_KF_SEGMENT_LABELS_B SLB,

FND_KF_STR_INSTANCES_B SIB,

FND_KF_SEGMENTS_B SGB

WHERE SIB.STRUCTURE_INSTANCE_ID = SGI.STRUCTURE_INSTANCE_ID

AND SGB.STRUCTURE_ID = SIB.STRUCTURE_ID

AND SGB.SEGMENT_CODE = SGI.SEGMENT_CODE

AND SLB.APPLICATION_ID = SIB.APPLICATION_ID

AND SLB.KEY_FLEXFIELD_CODE = SIB.KEY_FLEXFIELD_CODE) B,

(select kls2.structure_id, kls2.segment_code, kls2.segment_label_code

from fnd_kf_labeled_segments kls2

) LS

WHERE LS.STRUCTURE_ID(+) = B.STRUCTURE_ID

AND LS.SEGMENT_CODE(+) = B.SEGMENT_CODE

AND LS.SEGMENT_LABEL_CODE(+) = B.SEGMENT_LABEL_CODE