RQ_DF_GRID_VW

(SQL View)
 Index Back

Defect Filter Work Record

Quality application DEFECT Configurable Search View

SELECT A.BUSINESS_UNIT , A.R_DEFECT_ID , A.R_DEFECT_TYPE , A.R_REPORTED_BY , C.NAME_AC , A.R_ST_STATUS_CD , A.R_ST_REASON_CD , B.DESCR , A.R_SYMPTOM_CD , A.R_SEVERITY_LEVEL , A.R_SUBJECT , A.R_PARENT_DEFECT_ID , A.R_PRIORITY_CODE , A.R_FAIL_VERIFIED_BY , A.R_PRODUCTION_ID , E.R_IDENTIFICATION , A.R_ASSGN_PRSN_ID , D.NAME_AC , A.R_ASSGN_NAME , A.R_COMPONENT_ID , ' ' , A.SYNCID FROM PS_RQ_DEFECT A , PS_RQ_DEFECT0_VW AA , PS_RD_PERSON_NAME C , PS_RD_PERSON_NAME D , PS_PROD_ITEM B , PS_RQ_PRODUCTION E , PS_SET_CNTRL_REC F WHERE A.R_DELETED_SW <> 'Y' AND A.BUSINESS_UNIT = AA.BUSINESS_UNIT AND A.R_DEFECT_ID = AA.R_DEFECT_ID AND A.R_REPORTED_BY = C.PERSON_ID (+) AND C.PRIMARY_IND (+) = 'Y' AND A.R_ASSGN_PRSN_ID = D.PERSON_ID (+) AND D.PRIMARY_IND (+) = 'Y' AND A.BUSINESS_UNIT = F.SETCNTRLVALUE AND F.RECNAME = 'PROD_ITEM' AND B.SETID = F.SETID AND A.R_PROD_RLSE_ID = B.PRODUCT_ID AND AA.SETID = E.SETID (+) AND AA.R_PRODUCTION_ID = E.R_PRODUCTION_ID (+)

  • Related Language Record: RQ_DF_GRD_LNGVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_RQ_NONVW

    2 R_DEFECT_ID Character(15) VARCHAR2(15) NOT NULL Quality Defect Identification key unique by business unit
    3 R_DEFECT_TYPE Character(4) VARCHAR2(4) NOT NULL Defect Type
    DEFC=Defect
    ENHC=Enhancement
    4 R_REPORTED_BY Character(15) VARCHAR2(15) NOT NULL First Reported By .... FK to PERSONAL_DATA

    Prompt Table: RQ_EMPL_PRSN_VW

    5 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
    6 R_ST_STATUS_CD Character(4) VARCHAR2(4) NOT NULL STATUS CODE

    Prompt Table: RQ_UD_ST_STA_VW

    7 R_ST_REASON_CD Character(4) VARCHAR2(4) NOT NULL Status Reason

    Prompt Table: RQ_UD_ST_RSN_VW

    8 PRODUCTDESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 R_SYMPTOM_CD Character(4) VARCHAR2(4) NOT NULL Defect Symptom

    Prompt Table: RQ_UD_DEF_SYMPT

    10 R_SEVERITY_LEVEL Character(2) VARCHAR2(2) NOT NULL Defect Severity
    1=High
    2=Medium
    3=Low
    11 R_SUBJECT Character(254) VARCHAR2(254) NOT NULL subject
    12 R_PARENT_DEFECT_ID Character(15) VARCHAR2(15) NOT NULL Parent Defect Id
    13 R_PRIORITY_CODE Character(2) VARCHAR2(2) NOT NULL Priority
    1=High
    2=Medium
    3=Low
    14 R_FAIL_VERIFIED_BY Character(15) VARCHAR2(15) NOT NULL Defect Verified Person

    Prompt Table: RQ_EMPL_PRSN_VW

    15 R_PRODUCTION_ID Character(15) VARCHAR2(15) NOT NULL Production Identification number for Quality Application
    16 R_IDENTIFICATION Character(40) VARCHAR2(40) NOT NULL Id
    17 R_ASSGN_PRSN_ID Character(15) VARCHAR2(15) NOT NULL Defect Assigned to Person Id
    18 NAME_AC_SRCH Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    19 R_ASSGN_NAME Character(80) VARCHAR2(80) NOT NULL Defect Assigned To Name
    20 R_COMPONENT_ID Character(15) VARCHAR2(15) NOT NULL COMPONENT ID
    21 NAME_SEARCH Character(50) VARCHAR2(50) NOT NULL Name
    22 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.