BO_IDRC_PIN_FLTR_VW(SQL View) |
Index Back |
|---|---|
PIN ViewPIN View for BO Search Setup. It brings BO_ID of agreement contact. |
| SELECT DISTINCT H.BO_ID_CONTACT FROM PS_RF_AGREEMENT G , PS_RF_AGR_CONTACT H WHERE G.AGRT_STATUS = '005' AND G.END_DT >= %CurrentDateIn AND G.START_DT <= %CurrentDateIn AND G.SETID = H.SETID AND G.AGREEMENT_CODE = H.AGREEMENT_CODE AND G.AGR_RENEWAL_NUM = H.AGR_RENEWAL_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |