MATL_GRPTYP2_LN(SQL View) |
Index Back |
---|---|
Material Group Type2 ViewThis table is a view that is used as a prompt table for Group Type. It will only give Group Types for Material Type = 'SUM'. This is the related language record for MATL_GRPTYP2_VW. This is the related language record for MATL_GRPTYP3_VW. This is the related language record for MATL_GRP_TYP_VW. |
SELECT A.INSTITUTION , A.GENL_MATL_GROUP , B.EFFDT , A1.LANGUAGE_CD , A1.DESCR FROM PS_MATL_GRPTYP_TBL A , PS_MATL_GRP_LNG A1 , PS_MATL_GRP_TBL B WHERE A.INSTITUTION = A1.INSTITUTION AND A.GENL_MATL_GROUP = A1.GENL_MATL_GROUP AND A.EFFDT = A1.EFFDT AND A.INSTITUTION = B.INSTITUTION AND A.GENL_MATL_GROUP = B.GENL_MATL_GROUP AND B.EFFDT = A.EFFDT AND A.GENL_MATL_TYPE = 'SUM' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | GENL_MATL_GROUP | Character(8) | VARCHAR2(8) NOT NULL | Material Group |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |