SF_PRDN_AREA_VW

(SQL View)
Index Back

Production Area/Routing View

CN#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'

  • Related Language Record: SF_PRDN_AREALVW
  • # 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