BUSINESS_UNITPrompt Table: BUS_UNIT_TBL_IN
REF_ROUTING_ITEMINV_ITEM_IDLANGUAGE_CDEN_RTG_UITM_LVW(SQL View) |
Index Back |
|---|---|
Master Routing Item RL View8/1/99 CN# EN800-12.0 lee -related lang vw for en_rtg_uitem_vw 11/06/00 lee - added descr60 to view to match en_rtg_uitem_vw |
| SELECT DISTINCT (a.business_unit) , a.ref_routing_item , a.inv_item_id , e.language_cd , e.descr60 , e.descr FROM ps_bu_items_inv a , PS_MASTER_ITEM_TBL b , ps_set_cntrl_rec c , ps_master_itm_lang e WHERE c.recname='MASTER_ITEM_TBL' AND a.inv_item_id <> a.ref_routing_item AND a.inv_item_id=b.inv_item_id AND a.inv_item_id=e.inv_item_id AND b.inv_item_id=e.inv_item_id AND a.business_unit=c.setcntrlvalue AND b.setid=c.setid AND e.setid=b.setid AND e.setid=c.setid |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_IN |
| 2 | REF_ROUTING_ITEM |
Character(18) | VARCHAR2(18) NOT NULL | Reference Routing Item |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |