AUC_CLAUSE_VW

(SQL View)
 Index Back

Bid Factor clause view

11/8/2012 RMK 14727022 Sql text should be the same as CS_CLAUSE_AG_VW

SELECT A.SETID , A.CS_OBJECT_TYPE , A.CS_OBJECT_ID , A.DESCR60 , B.CS_TITLE , B.NUM_CHILDREN , B.ALTS_EXIST FROM PS_CS_OBJECTS_HDR A , PS_CS_OBJECTS_DTL B WHERE A.CS_OBJECT_TYPE = '0001' AND B.SETID = A.SETID AND B.CS_OBJECT_TYPE = A.CS_OBJECT_TYPE AND B.CS_OBJECT_ID = A.CS_OBJECT_ID AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_CS_OBJECTS_DTL C WHERE C.SETID = B.SETID AND C.CS_OBJECT_TYPE = B.CS_OBJECT_TYPE AND C.CS_OBJECT_ID = B.CS_OBJECT_ID AND C.EFFDT <= %CurrentDateIn AND C.CS_APPROVAL_STATUS = 'A') AND EXISTS ( SELECT 'X' FROM PS_CS_OBJS_SOURCE S WHERE S.SETID = B.SETID AND S.CS_OBJECT_TYPE = B.CS_OBJECT_TYPE AND S.CS_OBJECT_ID = B.CS_OBJECT_ID AND S.EFFDT = B.EFFDT AND (S.CS_SOURCE_TRANS = '02' OR S.CS_SOURCE_TRANS = '99') )

  • Related Language Record: CS_CLAUSE_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CS_OBJECT_TYPE Character(4) VARCHAR2(4) NOT NULL 06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles
    0001=Clause
    0002=Section
    0003=Ad Hoc Clause
    0004=Rule
    0005=Bind Variables
    0006=Wizard Definition
    0007=Document Configurator
    0008=Document
    0015=Word Template
    1000=All

    Default Value: 0001

    3 CS_OBJECT_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    5 CS_TITLE Character(254) VARCHAR2(254) NOT NULL title
    6 NUM_CHILDREN Number(3,0) SMALLINT NOT NULL Number of children
    7 ALTS_EXIST Character(1) VARCHAR2(1) NOT NULL cel - alternates exist flag in Contract Management