1. Tables and Views for SCM
  2. EGP_ITEM_PRIMARY_UOMS_V

EGP_ITEM_PRIMARY_UOMS_V

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: VIEW

Columns

Name

INVENTORY_ITEM_ID

ITEM_NUMBER

PRIMARY_UOM_CODE

Query

SQL_Statement

SELECT DISTINCT inventory_item_id, item_number, primary_uom_code

FROM egp_system_items_b B

WHERE B.TEMPLATE_ITEM_FLAG = 'N'

AND B.APPROVAL_STATUS = 'A'

AND B.ACD_TYPE = 'PROD'

AND B.CHANGE_LINE_ID = -1

AND B.VERSION_ID = -1