CS_CLAUSE_AG_VW

(SQL View)
 Index Back

Agreement clause

11/8/2012 RMK 14727022 Remove level 0 from sql text view to allow clause with purchasing binds (any level); this is to fulfill use cases to bind agreement results (header and line agreements). Users must set up the binds in clauses correctly (ie. same source record as header agreement, and line agreement)

SELECT D.SETID ,D.CS_OBJECT_TYPE ,D.CS_OBJECT_ID ,D.CS_TITLE ,H.DESCR60 FROM PS_CS_OBJECTS_HDR H , PS_CS_OBJECTS_DTL D WHERE D.SETID = H.SETID AND D.CS_OBJECT_TYPE = '0001' AND D.CS_OBJECT_TYPE = H.CS_OBJECT_TYPE AND D.CS_OBJECT_ID = H.CS_OBJECT_ID AND D.EFF_STATUS = 'A' AND D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_CS_OBJECTS_DTL D_ED WHERE D.SETID = D_ED.SETID AND D.CS_OBJECT_TYPE = D_ED.CS_OBJECT_TYPE AND D.CS_OBJECT_ID = D_ED.CS_OBJECT_ID AND D_ED.EFFDT <=%CurrentDateIn AND D_ED.CS_APPROVAL_STATUS = 'A' ) AND EXISTS ( SELECT 'X' FROM PS_CS_OBJS_SOURCE S WHERE S.SETID = D.SETID AND S.CS_OBJECT_TYPE = D.CS_OBJECT_TYPE AND S.CS_OBJECT_ID = D.CS_OBJECT_ID AND S.EFFDT = D.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 CS_TITLE Character(254) VARCHAR2(254) NOT NULL title
    5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description