2527: l_stmt_no := 20;
2528: BEGIN
2529: SELECT 'Y'
2530: INTO x_result
2531: FROM BOM_BILL_OF_MATERIALS BOM,
2532: BOM_INVENTORY_COMPONENTS BIC,
2533: MTL_SYSTEM_ITEMS MTL
2534: WHERE BOM.Assembly_item_id = pInventory_item_id
2535: AND BOM.Organization_id = pOrg_id