Need a OTBI SQL Query to obtain a list of items with 'Item Status' as 'Inactive' (See question)
Summary: Need a OTBI SQL Query to obtain a master list of items from Product Information Management (PIM) with 'Item Status' as 'Inactive' along with values of three other item attributes mentioned below. A SQL query will be much appreciated. The SQL output should ideally have the below columns of data. Thanks in advance.
Item Number,
Item Organization or Inventory Organization,
Item Status,
Purchasable,
Internally Transferable,
Transfer Orders Enabled
========================================
Below are the screenshots of the item attributes I am referring to, above:
Item Status & Purchasable attributes in PIM:
Internally Transferable & Transfer Orders Enabled attributes in PIM:
Tagged:
0