RQ_FX_GRID_VW

(SQL View)
 Index Back

Fix Grid Filter View

Quality Application FIX Configurable Search View

SELECT A.BUSINESS_UNIT , A.R_FIX_ID , A.R_SUBJECT , A.R_COMPLEXITY_LEVEL , A.R_FIX_TEST_STATUS , B.DESCR , A.R_INTRODUCED_IN , D.R_IDENTIFICATION , A.R_COMPONENT_ID , A.R_1ST_FOUND_IN , A.R_FIXED_IN , A.R_FIX_VERIFIED_IN , A.R_VERIFIED_BY , C.NAME_AC , A.R_FIX_COMPLETED_BY , A.SYNCID FROM PS_RQ_FIX A , PS_RQ_FIX0_VW AA , PS_RD_PERSON_NAME C , PS_PROD_ITEM B , PS_RQ_PRODUCTION D , PS_SET_CNTRL_REC E WHERE A.BUSINESS_UNIT = AA.BUSINESS_UNIT AND A.R_FIX_ID = AA.R_FIX_ID AND A.R_VERIFIED_BY = C.PERSON_ID (+) AND C.PRIMARY_IND (+) = 'Y' AND A.BUSINESS_UNIT = E.SETCNTRLVALUE AND E.RECNAME = 'PROD_ITEM' AND B.SETID = E.SETID AND A.R_PROD_RLSE_ID = B.PRODUCT_ID AND AA.SETID = D.SETID (+) AND AA.R_PRODUCTION_ID = D.R_PRODUCTION_ID (+)

  • Related Language Record: RQ_FX_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_FIX_ID Character(15) VARCHAR2(15) NOT NULL Fix Identification
    3 R_SUBJECT Character(254) VARCHAR2(254) NOT NULL subject
    4 R_COMPLEXITY_LEVEL Character(2) VARCHAR2(2) NOT NULL the level of complexity this defect is ranked as
    1=Trivial
    2=Easy
    3=Medium
    4=Very Complex
    5 R_FIX_TEST_STATUS Character(4) VARCHAR2(4) NOT NULL testing status of the fix in quality management
    FAIL=Failed
    IPRG=In Progress
    PASS=Passed
    PEND=Pending
    PPAS=Partially Passed
    6 PRODUCTDESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 R_INTRODUCED_IN Character(15) VARCHAR2(15) NOT NULL defines environment in which this defect was found
    8 R_IDENTIFICATION Character(40) VARCHAR2(40) NOT NULL Id
    9 R_COMPONENT_ID Character(15) VARCHAR2(15) NOT NULL COMPONENT ID
    10 R_1ST_FOUND_IN Character(15) VARCHAR2(15) NOT NULL defect problem found in 1st environment
    11 R_FIXED_IN Character(15) VARCHAR2(15) NOT NULL defines the environment in which this fix was done
    12 R_FIX_VERIFIED_IN Character(15) VARCHAR2(15) NOT NULL version of production used to verify the fix
    13 R_VERIFIED_BY Character(15) VARCHAR2(15) NOT NULL Verified By

    Prompt Table: RQ_EMPL_PRSN_VW

    14 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
    15 R_FIX_COMPLETED_BY Character(15) VARCHAR2(15) NOT NULL Fix completed By this person
    16 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.