SPITYPBUNONVWLN(SQL View) |
Index Back |
---|---|
Item Types Given for Bus. UnitSPITYPBUNONVWLN is the language record related to SP_ITYPBU_NONVW. A related language record enables text fields on a table to be translated into various languages for use in other countries. |
SELECT B.business_unit ,C.item_type , c.LANGUAGE_CD ,c.descr FROM ps_set_cntrl_rec A , ps_bus_unit_tbl_sf B , PS_ITEM_TYPE_LNG C WHERE A.setcntrlvalue = B.institution AND A.recname = 'ITEM_TYPE_TBL' AND C.setid = A.setid AND C.effdt = ( SELECT MAX(D.effdt) FROM PS_ITEM_TYPE_LNG D WHERE D.setid = C.setid AND D.item_type = C.item_type AND d.LANGUAGE_CD = c.LANGUAGE_CD AND D.effdt <= %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
2 | Character(12) | VARCHAR2(12) NOT NULL | Item Type | |
3 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |