[Home] [Help]
View: VEH_CUST_INV_ITEM_V
Product: | VEH - Automotive Integration Kit (Obsolete) |
Description: | - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ITEM_NUMBER ITEM_NUMBER
, 0 CUSTOMER_ITEM_ID
, DESCRIPTION DESCRIPTION
, ORGANIZATION_ID ORGANIZATION_ID
, 'INTERNAL' INT_EXT_CODE
FROM MTL_ITEM_FLEXFIELDS UNION SELECT DISTINCT CUSTOMER_ITEM_NUMBER ITEM_NUMBER
, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, CUSTOMER_ITEM_DESC DESCRIPTION
, 0 ORGANIZATION_ID
, 'EXTERNAL' INT_EXT_CODE
FROM MTL_CUSTOMER_ITEMS
Columns
Name |
ITEM_NUMBER |
CUSTOMER_ITEM_ID |
DESCRIPTION |
ORGANIZATION_ID |
INT_EXT_CODE |