VRM_ITEMS_V

Details

• Schema: FUSION

• Object owner: VRM

• Object type: VIEW

Columns

Name
INVENTORY_ITEM_ID ORGANIZATION_ID ORGANIZATION_CODE ITEM_NUMBER ITEM_DESCRIPTION

Query

SQL_Statement
SELECT b.inventory_item_id , b.organization_id , mp.organization_code , b.item_number , b.description item_description FROM egp_system_items_vl b , INV_ORGANIZATION_DEFINITIONS_V mp WHERE b.organization_id = mp.organization_id