EODP_PVT_PRD_VW(SQL View) |
Index Back |
---|---|
Product View for EODP SearchProduct view for data privacy Search |
SELECT A.PTPG_PGRIDNAME , B.XLATLONGNAME FROM PSPGCORE A , PSXLATITEM B WHERE B.FIELDNAME = 'OBJECTOWNERID' AND B.FIELDVALUE = A.OBJECTOWNERID AND %EffdtCheck(PSXLATITEM C, B, %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PTPG_PGRIDNAME | Character(30) | VARCHAR2(30) NOT NULL | Pivot Grid Name (see PSPGCORE). |
2 | EODP_PROD_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Product Description |