GP_MT_SQLT_VW(SQL View) |
Index Back |
---|---|
SQL Text for MT DefinitionsSQL Text for MT Definitions |
SELECT T1.SQLID , T1.SQLTEXT FROM PSSQLTEXTDEFN T1 WHERE T1.SQLTYPE = '0' AND T1.MARKET = 'GBL' AND T1.DBTYPE = ' ' AND T1.EFFDT = ( SELECT MAX(EFFDT) FROM PSSQLTEXTDEFN T2 WHERE T2.SQLID = T1.SQLID AND T2.SQLTYPE = T1.SQLTYPE AND T2.MARKET = T1.MARKET AND T2.DBTYPE = T1.DBTYPE ) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |
2 | SQLTEXT | Long Character(14000) | CLOB | SQL Statement Text |