SETIDVENDOR_IDCNTCT_SEQ_NUMSCR_CNT_SCR_VW(SQL View) |
Index Back |
|---|---|
Supplier ContactSupplier Contact |
| SELECT B.SETID , B.VENDOR_ID , B.CNTCT_SEQ_NUM , B.DESCR FROM PS_VNDR_CNTCT_SCR B , PS_VENDOR_CNTCT C WHERE B.SETID = C.SETID AND B.VENDOR_ID = C.VENDOR_ID AND B.CNTCT_SEQ_NUM = C.CNTCT_SEQ_NUM AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_VENDOR_CNTCT D WHERE D.SETID = C.SETID AND D.VENDOR_ID = C.VENDOR_ID AND D.CNTCT_SEQ_NUM = C.CNTCT_SEQ_NUM AND D.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | CNTCT_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |