MST_ITM_COST_VW

(SQL View)
 Index Back

Item Master Actual Cost View


select b.setid, b.inv_item_id, a.itm_status_effdt, b.descr, b.inv_item_group, b.inv_prod_fam_cd from PS_MASTER_ITEM_TBL b, ps_bu_items_inv a, ps_set_cntrl_rec c where a.business_unit = c.setcntrlvalue and c.recname = 'MASTER_ITEM_TBL' and b.setid = c.setid and b.inv_item_id = a.inv_item_id and a. itm_status_current in ('1','2','3') and a.inventory_item = 'Y' and exists (select 'X' from ps_cm_item_meth_vw g where g.business_unit = a.business_unit and g.inv_item_id = a.inv_item_id and g.cm_type = '1')

  • Related Language Record: MST_ITM_CM_LVW

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: MST_ITM_PRPT_VW

    3 EFFDT Date(10) DATE Effective Date
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

    Prompt Table: INV_ITEM_GROUP

    6 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family

    Prompt Table: INV_ITEM_FAM