What is a good way to ignore package components via sql. I believe it will be a self join?
I have a use case where some parts are used as package components and are useable products on their own and can be on same customer order. I would like to keep only package part and ignore if its component. any help on sql will be appreciated.
I found Sales_Part_Package_API.Exist_Components() and Sales_Part_Package_API.Exists() but so far not very successful.
Question
Ignore Package Components via Sql query
Hi Uzma
Sales_Part_API.Get_Catalog_Type() can be used for this purpose. There are two overload methods one only uses “catalog_no” and the other uses “contract” and “catalog_no”. Part types of sales parts are denoted as below.
INVENTORY_PART = 'INV';
NON_INVENTORY_PART = 'NON';
PACKAGE_PART = 'PKG';
COMPONENT_PART = 'KOMP'
Therefore if the catalog_type is ‘KOMP’ then can ignore it.
Best Regards,
Anjaleen
Hi again Uzma
If you want to use a SQL query then check column value “catalog_type” directly in SALES_PART_TAB. Even the previously mentioned getter method does the same.
Best Regards,
Anjaleen
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.