BUSINESS_UNITPHONE_FULL_NBREX_TW_BU_PHN_VW(SQL View) |
Index Back |
|---|---|
BU with Text Enabled |
| SELECT A.BUSINESS_UNIT_GL , A.PHONE_FULL_NBR FROM %Table(EX_TW_BU_PHONE) A , %Table(BUS_UNIT_TBL_EX) B WHERE A.BUSINESS_UNIT_GL = B.BUSINESS_UNIT_GL AND ALO_TXT_MSG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PHONE_FULL_NBR |
Character(17) | VARCHAR2(17) NOT NULL | Phone Number |