ITEMTYPEBUVWLNG(SQL View) |
Index Back |
---|---|
Item Types Given for Bus. UnitITEMTYPEBUVWLNGis the related language recordfor the record ITEM_TYPE_BU_VW |
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.effdt <= %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Item Type |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |