[Home] [Help]
View: RLM_CUST_INV_ITEM_V
View Text
SELECT ITEM_NUMBER ITEM_NUMBER
, INVENTORY_ITEM_ID ITEM_ID
, DESCRIPTION DESCRIPTION
, 0 CUSTOMER_ID
, ORGANIZATION_ID ORGANIZATION_ID
, 'INTERNAL' INT_EXT_CODE
FROM MTL_ITEM_FLEXFIELDS UNION SELECT DISTINCT CUSTOMER_ITEM_NUMBER ITEM_NUMBER
, CUSTOMER_ITEM_ID ITEM_ID
, CUSTOMER_ITEM_DESC DESCRIPTION
, CUSTOMER_ID CUSTOMER_ID
, 0 ORGANIZATION_ID
, 'EXTERNAL' INT_EXT_CODE
FROM MTL_CUSTOMER_ITEMS
Columns
Name |
ITEM_NUMBER |
ITEM_ID |
DESCRIPTION |
CUSTOMER_ID |
ORGANIZATION_ID |
INT_EXT_CODE |