RQ_RELATIONLVW

(SQL View)
 Index Back

Defect Relationship Language

Language View of Defect Relationships in quality application

SELECT A.BUSINESS_UNIT , A.R_DEFECT_ID , B.LANGUAGE_CD , B.R_PARENT_LBL , B.R_CHILD_LBL , B.R_EQUIVALENT_LBL FROM PS_RQ_DEFECT A , PS_RQ_RELATION_LNG B , PS_RQ_RELATIONSHIP C WHERE ((A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.R_DEFECT_ID = C.R_DEFECT_ID) OR (A.BUSINESS_UNIT = C.R_RELATED_BU AND A.R_DEFECT_ID = C.R_RELATED_DEFECT)) AND B.R_RELATION_TYPE = C.R_RELATION_TYPE AND B.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'RQ_RELATION_TBL')

  • Related Language Record for RQ_RELATION_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 R_DEFECT_ID Character(15) VARCHAR2(15) NOT NULL Quality Defect Identification key unique by business unit
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 R_PARENT_LBL Character(15) VARCHAR2(15) NOT NULL Defect Parent
    5 R_CHILD_LBL Character(15) VARCHAR2(15) NOT NULL used in defining relationship between Defects used to label the Child in the relationship
    6 R_EQUIVALENT_LBL Character(15) VARCHAR2(15) NOT NULL used in Quality to define equivalent relationships between two Defects