CJM_XLA_SYSTEM_ITEMS_V

Details

  • Schema: FUSION

  • Object owner: CJM

  • Object type: VIEW

Columns

Name

INVENTORY_ITEM_ID

INV_ORG_ID

ITEM_SALES_ACCOUNT

INV_ITEM_GLOBAL_ATTR_CAT

INV_ITEM_GLOBAL_ATTR1

INV_ITEM_GLOBAL_ATTR2

INV_ITEM_GLOBAL_ATTR3

INV_ITEM_GLOBAL_ATTR4

INV_ITEM_GLOBAL_ATTR5

INV_ITEM_GLOBAL_ATTR6

INV_ITEM_GLOBAL_ATTR7

INV_ITEM_GLOBAL_ATTR8

INV_ITEM_GLOBAL_ATTR9

INV_ITEM_GLOBAL_ATTR10

Query

SQL_Statement

SELECT inventory_item_id inventory_item_id,

organization_id inv_org_id,

sales_account item_sales_account,

global_attribute_category inv_item_global_attr_cat,

global_attribute1 inv_item_global_attr1,

global_attribute2 inv_item_global_attr2,

global_attribute3 inv_item_global_attr3,

global_attribute4 inv_item_global_attr4,

global_attribute5 inv_item_global_attr5,

global_attribute6 inv_item_global_attr6,

global_attribute7 inv_item_global_attr7,

global_attribute8 inv_item_global_attr8,

global_attribute9 inv_item_global_attr9,

global_attribute10 inv_item_global_attr10

FROM egp_system_items_b_v