RECNAMEOI_TFLT_REC_VW(SQL View) |
Index Back |
|---|---|
OTBI TFLT Rec ViewOTBI Tree Flattener prompt view |
| SELECT RECNAME FROM PSRECDEFN A WHERE RECTYPE = 0 AND EXISTS ( SELECT 'X' FROM PSRECFIELDDB X WHERE A.RECNAME = X.RECNAME AND X.FIELDNAME IN ('TREE_NAME_OTBI', 'TREE_NAME') ) AND EXISTS ( SELECT 'X' FROM PSRECFIELDDB X2 WHERE A.RECNAME = X2.RECNAME AND X2.FIELDNAME = 'TNODE2') AND NOT EXISTS ( SELECT 'X' FROM PS_OI_TFLT_FIELDS X3 WHERE X3.RECNAME = A.RECNAME) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |