INIU_TRNOPTD_VW(SQL View) |
Index Back |
---|---|
Distinct NonPairs IntercompanyView to get distinct BU pairs from the INIU_TRANOPT_VW |
SELECT DISTINCT SOURCE_BUS_UNIT , DESTIN_BU FROM PS_INIU_TRANOPT_VW |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
2 | DESTIN_BU | Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |