SF_ISS_COMP_VW

(SQL View)
 Index Back

SF Issue Component View

02/17/98 Lee: Added RLV: SF_ISS_COMP_LVW 2/19/98 RS : RL View Type OTH C2

select distinct a.business_unit, a.pick_batch_id, a.component_id, b.descr from ps_sf_iss_transfer a, PS_MASTER_ITEM_TBL b where b.setid = (select c.setid from PS_SET_CNTRL_REC c where c.setcntrlvalue = a.business_unit and c.recname = 'MASTER_ITEM_TBL') and b.inv_item_id = a.component_id

  • Related Language Record: SF_ISS_COMP_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
    3 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description