EO_CURRCOMP_VW(SQL View) |
Index Back |
---|---|
Currency Conversion ComponentSelection components available from Run Control & MetaSql |
SELECT A.PROC_GRP_ID ,B.RCNTL_COMP_NAME ,B.RCNTL_COMP_NBR FROM PS_EO_PROC_GROUP A ,PS_EO_CURRCNV_COMP B |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROC_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Uniquely identifies a Currency Conversion Process Group |
2 | RCNTL_COMP_NAME | Character(20) | VARCHAR2(20) NOT NULL | Run Control Component Name |
3 | RCNTL_COMP_NBR | Number(3,0) | SMALLINT NOT NULL | Run Control Component Number |