VIEW: APPS.CN_QM_GROUP_HIER

Source

View Text - Preformatted

SELECT r.group_relate_id, r.group_id comp_group_id, r.related_group_id parent_comp_group_id, r.relation_type, r.start_date_active, r.end_date_active, r.delete_flag, r.object_version_number, r.attribute1, r.attribute2, r.attribute3, r.attribute4, r.attribute5, r.attribute6, r.attribute7, r.attribute8, r.attribute9, r.attribute10, r.attribute11, r.attribute12, r.attribute13, r.attribute14, r.attribute15, r.attribute_category FROM jtf_rs_grp_relations r, jtf_rs_group_usages u1, jtf_rs_group_usages u2 WHERE u1.group_id = r.group_id AND u2.group_id = r.related_group_id AND u1.usage='SF_PLANNING' AND u2.usage='SF_PLANNING' AND r.delete_flag = 'N'

View Text - HTML Formatted

SELECT R.GROUP_RELATE_ID
, R.GROUP_ID COMP_GROUP_ID
, R.RELATED_GROUP_ID PARENT_COMP_GROUP_ID
, R.RELATION_TYPE
, R.START_DATE_ACTIVE
, R.END_DATE_ACTIVE
, R.DELETE_FLAG
, R.OBJECT_VERSION_NUMBER
, R.ATTRIBUTE1
, R.ATTRIBUTE2
, R.ATTRIBUTE3
, R.ATTRIBUTE4
, R.ATTRIBUTE5
, R.ATTRIBUTE6
, R.ATTRIBUTE7
, R.ATTRIBUTE8
, R.ATTRIBUTE9
, R.ATTRIBUTE10
, R.ATTRIBUTE11
, R.ATTRIBUTE12
, R.ATTRIBUTE13
, R.ATTRIBUTE14
, R.ATTRIBUTE15
, R.ATTRIBUTE_CATEGORY
FROM JTF_RS_GRP_RELATIONS R
, JTF_RS_GROUP_USAGES U1
, JTF_RS_GROUP_USAGES U2
WHERE U1.GROUP_ID = R.GROUP_ID
AND U2.GROUP_ID = R.RELATED_GROUP_ID
AND U1.USAGE='SF_PLANNING'
AND U2.USAGE='SF_PLANNING'
AND R.DELETE_FLAG = 'N'