RQ_RELATION_VW

(SQL View)
 Index Back

Defect Relationship View

View of Defect Relationships in quality application

SELECT A.BUSINESS_UNIT , A.R_DEFECT_ID , C.R_RELATION_TYPE , B.R_HIERARCHICAL_IND , B.R_PARENT_LBL , B.R_CHILD_LBL , B.R_EQUIVALENT_LBL , C.BUSINESS_UNIT , C.R_DEFECT_ID , C.R_RELATED_BU , C.R_RELATED_DEFECT , C.ROW_ADDED_DTTM , C.ROW_ADDED_OPRID , A.R_ST_STATUS_CD FROM PS_RQ_DEFECT A , PS_RQ_RELATION_TBL 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: RQ_RELATIONLVW

    • # 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 R_RELATION_TYPE Character(5) VARCHAR2(5) NOT NULL Quality Relationship Type

    Prompt Table: RQ_RELATION_TBL
    Set Control Field: BUSINESS_UNIT

    4 R_HIERARCHICAL_IND Character(1) VARCHAR2(1) NOT NULL Hierarchical Indicator
    N=No
    Y=Yes
    5 R_PARENT_LBL Character(15) VARCHAR2(15) NOT NULL Defect Parent
    6 R_CHILD_LBL Character(15) VARCHAR2(15) NOT NULL used in defining relationship between Defects used to label the Child in the relationship
    7 R_EQUIVALENT_LBL Character(15) VARCHAR2(15) NOT NULL used in Quality to define equivalent relationships between two Defects
    8 R_REL_BU_PARENT Character(5) VARCHAR2(5) NOT NULL Related Defect Business Unit of the parent
    9 R_REL_DEF_PARENT Character(15) VARCHAR2(15) NOT NULL Related Defect Parent
    10 R_RELATED_BU Character(5) VARCHAR2(5) NOT NULL Related Business Unit
    11 R_RELATED_DEFECT Character(15) VARCHAR2(15) NOT NULL Related Defect field in Quality
    12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    13 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    14 R_ST_STATUS_CD Character(4) VARCHAR2(4) NOT NULL STATUS CODE