PC_TEMPLATE_VW

(SQL View)
Index Back

3PI: Get Integration Template


SELECT B.SETCNTRLVALUE , A.SETID , A.INTEGRATION_TMPL , A.DESCR , A.CURRENCY_CD FROM PS_PC_INT_TMPL A , PS_SET_CNTRL_REC B WHERE B.SETID = A.SETID AND B.RECNAME = 'PC_INT_TMPL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value

Prompt Table: SP_BU_PC_NONVW

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 INTEGRATION_TMPL Character(15) VARCHAR2(15) NOT NULL Integration
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code