SP_OMIKUS_NONVW

(SQL View)
 Index Back

Ship From IBU Hierarchy

Date Initials Issue Description 081803 dms IR629385001 Turn on search keys

SELECT DISTINCT pi.setid , pi.product_id , sp.business_unit , sp.descr FROM ps_sp_buin_nonvw sp , PS_BU_ITEMS_INV bu , ps_prodkit_comps pc , ps_prod_item pi , ps_prod_item itm WHERE pc.setid = pi.setid AND pc.product_id = pi.product_id AND itm.setid = pc.setid AND itm.product_id = pc.prod_component_id AND sp.business_unit = bu.business_unit AND bu.inv_item_id = itm.inv_item_id

  • Related Language Record: SP_OMIKUSLNONVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description