Hello Gurus,

I'm trying to show the value of isfulfillable field on all transaction lines (including Kit members/components) using SuiteQL.

Here is how the transaction looks:

Transaction Lines:
Item				ID		Type		isFulfillable:
Item A			        11580		Standalone	F
Item A			        11580		Standalone	F
Item B			        20034		Kit/Package     F


Item B (Kit/Package) Components:
Item				ID		Type		isFulfillable:
Item B : Component A	        19927		Standalone	F
Item B : Component B	        19224		Standalone	T

So far I was able to list the value of isfulfillable on all kit members using this SuiteQL query:

SELECT 
 MemberItem.ID AS ID, 
 MemberItem.isFulfillable AS isFulfillable 
FROM 
 Item AS ParentItem 
 INNER JOIN KitItemMember ON (
  KitItemMember.ParentItem = ParentItem.ID
 ) 
 INNER JOIN Item AS MemberItem ON (
  MemberItem.ID = KitItemMember.Item
 ) 
WHERE 
 ParentItem.ID IN (
  SELECT 
   Item.ID, 
  FROM 
   Transaction 
   INNER JOIN TransactionLine ON (
    TransactionLine.Transaction = Transaction.ID
   ) 
   INNER JOIN Item ON (Item.ID = TransactionLine.Item) 
  WHERE 
   (Transaction.ID = 19615846)
 ) 
ORDER BY 
 KitItemMember.LineNumber