CFMNL_OBJ_LN_VW(SQL View) |
Index Back |
---|---|
CF Manual Steps Objects ListList of Objects that needs to be acted upon in the corresponding manual step. |
SELECT D.CF_PROJECT , D.SEQUENCE_NBR_6B , D.PS_PRODUCT , D.DESCR80 , A.LANGUAGE_CD , A.LONGNAME FROM PS_CFMANUAL_OBJECT D , PSDBFLDLABLLANG A , PSDBFLDLABL B WHERE D.SEQUENCE_NBR_6B <> 1 AND B.DEFAULT_LABEL = 1 AND B.FIELDNAME = D.PS_PRODUCT AND A.FIELDNAME = B.FIELDNAME AND A.LABEL_ID = B.LABEL_ID AND B.FIELDNAME IN ( SELECT C.FIELDNAME FROM PSRECFIELDDB C WHERE C.RECNAME = 'FDM_PROD_SBR') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CF_PROJECT | Character(15) | VARCHAR2(15) NOT NULL | CF Configuration ID |
2 | SEQUENCE_NBR_6B | Number(6,0) | INTEGER NOT NULL | Sequence B |
3 | PS_PRODUCT | Character(18) | VARCHAR2(18) NOT NULL | PeopleSoft Product |
4 | DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | Description |
5 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
6 | PROG_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Program Type |