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 |