RECNAMEOI_TFLT_REC2_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') ) AND EXISTS ( SELECT 'X' FROM PSRECFIELDDB X2 WHERE A.RECNAME = X2.RECNAME AND X2.FIELDNAME = 'TNODE1') AND NOT EXISTS ( SELECT 'X' FROM PSRECFIELDDB X3 WHERE A.RECNAME = X3.RECNAME AND X3.FIELDNAME IN ('TREE_NAME_OTBI') ) AND NOT EXISTS ( SELECT 'X' FROM PS_OI_TFLT_FIELDS X4 WHERE X4.RECNAME_2 = 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). |