PO_BUYERM_VW(SQL View) |
Index Back |
---|---|
Buyer Manager View |
SELECT A.BUYER_MANAGER ,A.BUYER_ID FROM PS_PO_MANAGER_TBL A UNION SELECT ' ' ,B.BUYER_ID FROM PS_BUYER_TBL B |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUYER_MANAGER | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
2 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |