GVT_ACTN_RSN_PR

(SQL View)
 Index Back

Job Actions by WIP Actions


SELECT A.GVT_WIP_RECORD , A.GVT_WIP_ACTVTY , A.PNLGRPNAME , C.ACTION , C.ACTION_REASON , C.EFFDT , C.EFF_STATUS , C.DESCR FROM PS_GVT_ACTVTY_PGRP A ,PS_ACTN_REASON_TBL C WHERE (A.GVT_ALL_JOB_ACTNS = 'Y' OR (C.ACTION IN ( SELECT B1.ACTION FROM PS_GVT_ACTVTY_ACTN B1 WHERE B1.GVT_WIP_RECORD = A.GVT_WIP_RECORD AND B1.GVT_WIP_ACTVTY = A.GVT_WIP_ACTVTY AND B1.PNLGRPNAME = A.PNLGRPNAME AND B1.ACTION_REASON IS NULL) OR C.ACTION IN ( SELECT B2.ACTION FROM PS_GVT_ACTVTY_ACTN B2 WHERE B2.GVT_WIP_RECORD = A.GVT_WIP_RECORD AND B2.GVT_WIP_ACTVTY = A.GVT_WIP_ACTVTY AND B2.PNLGRPNAME = A.PNLGRPNAME AND B2.ACTION_REASON IS NOT NULL) AND C.ACTION_REASON IN ( SELECT B3.ACTION_REASON FROM PS_GVT_ACTVTY_ACTN B3 WHERE B3.GVT_WIP_RECORD = A.GVT_WIP_RECORD AND B3.GVT_WIP_ACTVTY = A.GVT_WIP_ACTVTY AND B3.PNLGRPNAME = A.PNLGRPNAME AND B3.ACTION = C.ACTION)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GVT_WIP_RECORD Character(25) VARCHAR2(25) NOT NULL Transaction
2 GVT_WIP_ACTVTY Character(10) VARCHAR2(10) NOT NULL WIP Activity
3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
4 ACTION Character(3) VARCHAR2(3) NOT NULL Action
5 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
6 EFFDT Date(10) DATE Effective Date
7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description