GM_REQ_COMP_DL

(SQL View)
 Index Back

Required component


SELECT B.SETID , A.BUSINESS_UNIT , A.GM_REQ_APPROVAL , B.COMPONENT_ID_GR FROM PS_GM_CMP_WF_REQ A , PS_GM_COMPNT_TBL B WHERE A.GM_ELEMENT_VALUE = B.COMPONENT_ID_GR AND A.GM_REQ_APPROVAL = 'Y' AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_GM_COMPNT_TBL D WHERE B.SETID = D.SETID AND B.COMPONENT_ID_GR = D.COMPONENT_ID_GR AND D.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 GM_REQ_APPROVAL Character(1) VARCHAR2(1) NOT NULL Required Approval Process
4 COMPONENT_ID_GR Character(18) VARCHAR2(18) NOT NULL Component ID