SF_COMP_ISS_LVW

(SQL View)
 Index Back

Component Issue View

02/17/98 Rajeev Created Rel Lang view 04/20/00 ST Added keys so that the lang view is in synch with SF_COMP_ISS_VW

SELECT DISTINCT SIT.business_unit , SIT.pick_batch_id , SIT.picklist_line_no , SIT.component_id , SIT.production_id , SIT.op_sequence , SIT.mg_orig_comp_id , SIT.qty_code , SIT.to_storage_area , SIT.to_stor_level_1 , SIT.to_stor_level_2 , SIT.to_stor_level_3 , SIT.to_stor_level_4 , MIL.language_cd , MIL.descr FROM ps_sf_iss_transfer SIT , ps_set_cntrl_rec SCR , PS_MASTER_ITM_LANG MIL WHERE SIT.business_unit = SCR.setcntrlvalue AND SCR.recname = 'MASTER_ITEM_TBL' AND MIL.setid = SCR.setid AND MIL.inv_item_id = SIT.component_id

  • Related Language Record for SF_COMP_ISS_VW

    • # 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 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
    4 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
    5 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
    6 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
    7 MG_ORIG_COMP_ID Character(18) VARCHAR2(18) NOT NULL original component ID
    8 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
    ASY=Assembly
    ORD=Order
    9 TO_STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
    10 TO_STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
    11 TO_STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
    12 TO_STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
    13 TO_STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
    14 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    15 DESCR Character(30) VARCHAR2(30) NOT NULL Description