Question

Ignore Package Components via Sql query

  • 5 April 2022
  • 3 replies
  • 71 views
O
Rank
Userlevel 4
Badge +10

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.

3 replies

A
Rank
Userlevel 3
Badge +5

Hi Uzma @OrangeCloud ,

 

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

A
Rank
Userlevel 3
Badge +5

Hi again Uzma @OrangeCloud ,

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

O
Rank
Userlevel 4
Badge +10

thanks , this wouldn’t work for my purpose. no issues. I am good for now.

Reply


Terms & ConditionsCookie settings