SF_PRDN_AREA_VW(SQL View) |
Index Back |
---|---|
Production Area/Routing ViewCN#EG750-4.0 dbe (Engineering Routings) - Added new field: RTG_STATE to WHERE clause. 9/26/97 ebn CN#EN750-1.0 : Changed view to take into account the Reference Routing Item on BU_ITEMS_INV for Master Routing Enhancement. 10/14/98 SCC CN#EN800-4.0: Remove RTG_TYPE from key since it's restricted as part of WHERE clause. 05/13/00 RT Created related lang view sf_prdn_arealvw |
SELECT a.business_unit , a.inv_item_id , b.rtg_code , b.descr , a.ref_routing_item FROM PS_BU_ITEMS_INV a , ps_en_rtg_header b WHERE b.business_unit = a.business_unit AND b.inv_item_id = a.ref_routing_item AND b.rtg_type = 'PR' AND b.rtg_state = 'PR' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
3 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL | Routing Code |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | REF_ROUTING_ITEM | Character(18) | VARCHAR2(18) NOT NULL | Reference Routing Item |