BUSINESS_UNITSP_RC_VR_HHDVW(SQL View) |
Index Back |
|---|---|
Call Center Business UnitsView used as prompt view for Case business unit look-up when security should not be applied. |
| SELECT DISTINCT (A.BUSINESS_UNIT) FROM PS_BUS_UNIT_TBL_RC A , PS_BUS_UNIT_TBL_FS B , PS_BUS_UNIT_RC_DEF C , PS_BUS_UNIT_RC_RDT D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.DISP_TMPL_FAM_CD = D.DISP_TMPL_FAM_CD AND C.DISP_TMPL_FAM_CD='CRM_HHD' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |