REPORT_ENTITYBUYER_IDBUSINESS_UNITSRM_DB_BU_VW(SQL View) |
Index Back |
|---|---|
Security View/ Purchasing BUs |
| SELECT DISTINCT A.REPORT_ENTITY , A.BUYER_ID , B.BUSINESS_UNIT , C.DESCR FROM PS_PO_SPEND_BUYER A , PS_PRCR_ENTITY_BU B , PS_BUS_UNIT_TBL_FS C WHERE A.REPORT_ENTITY = B.REPORT_ENTITY AND B.UNIT_TYPE = 'P' AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND EXISTS ( SELECT 'X' FROM PS_PRCR_ENTITY_TBL D WHERE D.REPORT_ENTITY = A.REPORT_ENTITY AND D.REPORT_ENTITY = B.REPORT_ENTITY AND D.ENTITY_TYPE = 'S') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REPORT_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL | Reporting Entity ID |
| 2 | BUYER_ID |
Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |